public ActionResult SubmitDiscrepency(RequisitionDetails Dp)
{
String ItemID = Dp.ItemID;
string StockcardID = getstockcardID(ItemID);
string DisStatus = "PendingForApproval";
using (SqlConnection conn = new SqlConnection(DataLink.connectionString))
{
conn.Open();
string cmdtext = @"insert into Discrepancy (DisbursementID,StockCardID,DiscrepancyQty,Reason,DiscrepancyStatus,ItemID) values ('" + Dp.DisbursementID + "','" + StockcardID + "'," + Dp.DeliveredQty + ",'" + Dp.Reason + "','" + DisStatus + "','" + ItemID + "')";
SqlCommand cmd = new SqlCommand(cmdtext, conn);
cmd.ExecuteNonQuery();
}
Users u = ds.GetUserInfo((int)Session["UserID"]);
string EmailID = u.EmailID;
int DiscrepancyId = GetDiscrepancyID();
SendEmailNotification send = new SendEmailNotification();
String EmailSubject = "Request Submitted DiscrepancyID#" + DiscrepancyId;
String EmailBody = "<p> Dear KyiPhyu,</p>";
EmailBody += "<p>Your order is ready to deliver with Discrepancy ID" + DiscrepancyId + " for your reference.</p>";
EmailBody += "<p>Thank you<br/>Logic University Staionery Store</p>";
EmailBody += "<p> Please do not reply to this email it is auto-generated.</p>";
send.SendEmailHTML("*****@*****.**", EmailSubject, EmailBody);
return(RedirectToAction("DisbursementList"));
}
public ActionResult StockCardDetail(string stockCardID, string id)
{
StockCradDetails scDetails = sc.createStockCardDetail(id);
sc.createDisbursementTransaction(stockCardID, id);
// List<StockCradDetails> scDisTran = sc.showDisbursementTransaction(stockCardID, id);
sc.createSupplierTransaction(stockCardID, id);
List <IncomingCode> incomingTran = sc.showSupplierTransaction(stockCardID);
int balance = sc.getLatestBalance(stockCardID, id);
int reorderLevel = sc.getReorderLevel(id);
if (balance <= reorderLevel)
{
Users u = ds.GetUserInfo((int)Session["UserID"]);
string EmailID = u.EmailID;
SendEmailNotification send = new SendEmailNotification();
String EmailSubject = "Reorder level low at ItemID#" + id;
String EmailBody = "<p> Dear SuSu,</p>";
EmailBody += "<p>Your reorder level is low in ItemID" + id + ". For your reference.</p>";
EmailBody += "<p>Thank you<br/>Logic University Staionery Store</p>";
EmailBody += "<p> Please do not reply to this email it is auto-generated.</p>";
send.SendEmailHTML("*****@*****.**", EmailSubject, EmailBody);
}
ViewBag.stockCardDetail = scDetails;
// ViewBag.scDisbursementTran = scDisTran;
ViewBag.incomingTran = incomingTran;
return(View());
}
//send Manger to notify when Discrepancy> 250
//by supervisor
public ActionResult sendMail()
{
Users u = ds.GetUserInfo((int)Session["UserID"]);
string EmailID = u.EmailID;
int discrepancyID = GetDiscrepancyID();
SendEmailNotification send = new SendEmailNotification();
String EmailSubject = "Request Submitted DiscrepancyID#" + discrepancyID;
String EmailBody = "<p> Dear KyiPhyu,</p>";
EmailBody += "<p>Your item has discrepancy in Discrepancy ID" + discrepancyID + " for your reference.</p>";
EmailBody += "<p>Thank you<br/>Logic University Staionery Store</p>";
EmailBody += "<p> Please do not reply to this email it is auto-generated.</p>";
send.SendEmailHTML("*****@*****.**", EmailSubject, EmailBody);
return(RedirectToAction("UpdateAdjustmentStatus", "Adjustment"));
}
