tdignan87
Well-known member
- Joined
- Jul 8, 2019
- Messages
- 95
- Programming Experience
- Beginner
Hi I am looking for some help if possible,
I have a query that writes off stock in our system which is older than 30 days. I would like the query results though to show in the body of the email it sends also so users know what stock has been written off. It doesn't need to be fancy, just a list of the query results.
Below is an example of my code
Thanks
I have a query that writes off stock in our system which is older than 30 days. I would like the query results though to show in the body of the email it sends also so users know what stock has been written off. It doesn't need to be fancy, just a list of the query results.
Below is an example of my code
Thanks
C#:
FbConnectionStringBuilder rfs = new FbConnectionStringBuilder();
rfs.DataSource =
"localhost";
rfs.Port = 3050;
rfs.Database = @";
rfs.UserID = "sysdba";
rfs.Password = "masterkey";
rfs.ServerType = FbServerType.Default;
FbConnection db = new FbConnection(rfs.ToString());
db.Open();
// String deletecommod = db.Query<String>("UPDATE STOCKDET SET STOCKDET.QTY = 0 WHERE STOCKDET.STOCKHDRID IN ( SELECT STOCKID FROM STOCKHDR WHERE STOCKHDR.RECEIVED <= " + date + ")" ).FirstOrDefault();
String deletecommod = db.Query<String>("UPDATE STOCKDET SET STOCKDET.QTY = 0 WHERE STOCKDET.STOCKHDRID IN ( SELECT STOCKID FROM STOCKHDR WHERE STOCKHDR.RECEIVED <= " + date +
"AND NOT STOCKHDR.COMMODITYID = '3082' AND NOT STOCKHDR.COMMODITYID = '3081' AND NOT STOCKHDR.COMMODITYID = '894' AND NOT STOCKHDR.COMMODITYID = '981' )").FirstOrDefault();
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient(stevensSMTP);
mail.From = new MailAddress(stevensNC);
mail.To.Add(stevens);
mail.Subject = "RFS Stock Clean Remnant Stock";
mail.Body = "RFS Production Schedule Clean <br> Remnant Stock older than 30 days has been 0'd from the system. Please contact support if further assistance is required</br>";
SmtpServer.Port = 25;
SmtpServer.Credentials = new System.Net.NetworkCredential(stevensNC, stevensPW);
SmtpServer.EnableSsl = true;
mail.IsBodyHtml = true;
SmtpServer.Send(mail);
// DateTime dateTime = new DateTime(2019, 6, 4);
// double date = Convert.ToSingle(dateTime.ToOADate());
// Console.WriteLine(date.ToString());
// Console.WriteLine("Successful");
}
catch (Exception ex)
{
Console.WriteLine("Not successful");
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.office365.com");
mail.From = new MailAddress("alerts@alertme.services");
mail.To.Add("tom.dignan@burtonsbiscuits.com");
mail.Subject = "RFS Stock Det Clean failed to update stock >30 days to 0";
mail.Body = "Exception Details" + ex.ToString();
SmtpServer.Port = 25;
SmtpServer.Credentials = new System.Net.NetworkCredential("alerts@alertme.services", "");
SmtpServer.EnableSsl = true;
mail.IsBodyHtml = true;
SmtpServer.Send(mail);
}
}
}
}