public bool InsertAdjustmentVoucher(adjustmentvoucher header, List<adjustmentvoucherdetail> details) { try { //creating a adjustmentvoucherheader entity.adjustmentvouchers.Add(header); entity.SaveChanges(); //creating adjustmentdetails foreach (adjustmentvoucherdetail d in details) { int tranID = d.ADVID; d.ADVID = header.ADVID; entity.adjustmentvoucherdetails.Add(d); //Update Transaction var query = from t in entity.transactions where t.TransItemID == d.ADVItemID && t.TransID == tranID select t; transaction tran = query.FirstOrDefault(); tran.TransCode = "ADF"; entity.SaveChanges(); } return true; } catch (Exception ex) { return false; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { AdjustmentService service = new AdjustmentService(); adjustmentvoucher adjVoucher = new adjustmentvoucher(); adjVoucher.ADVDate = DateTime.Today; int userID = Convert.ToInt32(Session["userid"].ToString()); adjVoucher.ADVIOrderByEmpID = userID; // adjVoucher.ADVApprovedByEMpID = 2; adjVoucher.ADVStatus = "Pending"; double totalPrice = 0; List<adjustmentvoucherdetail> detailList = new List<adjustmentvoucherdetail>(); foreach (GridViewRow i in dgvAdjustmentVoucher.Rows) { adjustmentvoucherdetail adjVoucher_details = new adjustmentvoucherdetail(); adjVoucher_details.ADVID = Convert.ToInt32(i.Cells[6].Text.ToString()); adjVoucher_details.ADVItemID = Convert.ToInt32(i.Cells[0].Text.ToString()); adjVoucher_details.ADVItemUnitCost = 0; adjVoucher_details.ADVQuantAdj = Convert.ToInt32(i.Cells[2].Text.ToString()); TextBox t = (TextBox)i.FindControl("txtReason"); int itemafter = Convert.ToInt32(i.Cells[5].Text.ToString()); int quantbefore = itemafter + adjVoucher_details.ADVQuantAdj; adjVoucher_details.ADVReason = t.Text.ToString(); adjVoucher_details.ADVItemUnitCost = Convert.ToInt32(i.Cells[3].Text.ToString()); adjVoucher_details.ADVQuantBefore = quantbefore; adjVoucher_details.ADVQuantAfter = Convert.ToInt32(i.Cells[5].Text.ToString()); adjVoucher_details.ADVAdjustedCost = Convert.ToInt32(i.Cells[4].Text.ToString()); detailList.Add(adjVoucher_details); totalPrice = totalPrice + adjVoucher_details.ADVAdjustedCost; } service.saveAdjustmentVoucher(adjVoucher, detailList ,totalPrice); Response.Redirect("ViewStockAdjustmentList.aspx"); } catch (Exception ex) { Label1.Text = "Un expected error occurs! please contact to admin"; } }
public bool saveAdjustmentVoucher(adjustmentvoucher a ,List<adjustmentvoucherdetail> d ,double totalprice) { try { rep.InsertAdjustmentVoucher(a, d); if (totalprice < 250) { List<storeemp> supervisors = selectStoreSupervisor(); foreach (storeemp emp in supervisors) { MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); //mail.To.Add(new MailAddress(emailID)); mail.To.Add(new MailAddress(emp.StoreEmpEmail)); mail.Subject = "Adjustment Voucher :"; String Header = "<head>" + "<title>Adjustment voucher to approve</title>" + "<meta charset=\"UTF-8\">" + " <meta name=\"viewport\" content=\"width=device-width\">" + " <link rel=\"stylesheet\" href=\"http://bootswatch.com/flatly/bootstrap.css\">" + " <link rel=\"stylesheet\" href=\"http://bootswatch.com/assets/css/bootswatch.min.css\">" + " </head>"; String BodyStart = "<body>"; String BodyContent = "There is new adjustment voucher to approve."; String BodyEnd = "</body>"; mail.Body = Header + BodyStart + BodyContent + BodyEnd; mail.IsBodyHtml = true; SmtpClient sc = new SmtpClient(); sc.Host = "smtp.gmail.com"; sc.Port = 25; sc.Credentials = new System.Net.NetworkCredential("*****@*****.**", "12345678!"); sc.EnableSsl = true; sc.Send(mail); } } else if (totalprice >= 250) { storeemp manager = selectManager(); MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); //mail.To.Add(new MailAddress(emailID)); mail.To.Add(new MailAddress(manager.StoreEmpEmail)); mail.Subject = "Adjustment Voucher:"; String Header = "<head>" + "<title>Adjustment voucher to approve</title>" + "<meta charset=\"UTF-8\">" + " <meta name=\"viewport\" content=\"width=device-width\">" + " <link rel=\"stylesheet\" href=\"http://bootswatch.com/flatly/bootstrap.css\">" + " <link rel=\"stylesheet\" href=\"http://bootswatch.com/assets/css/bootswatch.min.css\">" + " </head>"; String BodyStart = "<body>"; String BodyContent = "There is new adjustment voucher to approve."; String BodyEnd = "</body>"; mail.Body = Header + BodyStart + BodyContent + BodyEnd; mail.IsBodyHtml = true; SmtpClient sc = new SmtpClient(); sc.Host = "smtp.gmail.com"; sc.Port = 25; sc.Credentials = new System.Net.NetworkCredential("*****@*****.**", "12345678!"); sc.EnableSsl = true; sc.Send(mail); } return true; } catch (Exception ex) { return false; } }