protected void PlaceOrderButton_Click(object sender, EventArgs e)
{
//Session["cclist"] = null;
List <itemsuppliers> cclist = (List <itemsuppliers>)Session["cclist"];
POcontrol.PlacePurchaseOrder(cclist);
string bossmail = "*****@*****.**";
Business.sendemail();
MailMessage mm = new MailMessage("*****@*****.**",
bossmail);
mm.Subject = "The PO has Sent to Suppliers please review";
for (int j = 0; j < cclist.Count; j++)
{
mm.Body = cclist[j].Description.ToString() + "," + mm.Body;
}
mm.Body = mm.Body + " Has been Placed. Please Review.";
Business.sendemail().Send(mm);
Response.Redirect("~/4StoreClerk/ClerkHome.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
LastADEntities entities = new LastADEntities();
Requisition req = new Requisition();
//employee id need to ad later
req.RequestedDate = DateTime.Now;
req.Status = "Pending Approval";
if (Session["EmpId"] != null)
{
req.EmployeeId = Int32.Parse(Session["EmpId"].ToString());
}
entities.Requisitions.Add(req);
entities.SaveChanges();
for (int i = 0; i < list2.Count; i++)
{
RequDetail reqdetail = new RequDetail();
reqdetail.RequId = req.RequId;
reqdetail.ItemId = list2[i].ToString();
TextBox tb = (TextBox)this.GridView1.Rows[i].Cells[2].FindControl("TextBox1");
int aa = Int32.Parse(tb.Text);
reqdetail.RequestedQuantity = aa;
reqdetail.OutstandingQuantity = aa;
entities.RequDetails.Add(reqdetail);
entities.SaveChanges();
}
Session["reqid"] = req.RequId;
string bossmail = "*****@*****.**";
if (Session["BossEmail"] != null)
{
bossmail = Session["BossEmail"].ToString();
}
Business.sendemail();
MailMessage mm = new MailMessage("*****@*****.**",
bossmail);
mm.Subject = "Requisition ID" + Session["reqid"].ToString() + " Has been submitted. Please Approve";
mm.Body = "Requisition ID" + Session["reqid"].ToString() + " Has been submitted. Please Approve";
Business.sendemail().Send(mm);
Response.Redirect("EmployeeHome.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
if (Session["Requid"] != null)
{
int Requid = Int32.Parse(Session["Requid"].ToString());
if (Session["EmpName"] != null)
{
string empname = Session["EmpName"].ToString();
string reason = TextBox2.Text;
Business.RejectRequisition(Requid, reason, empname);
Business.sendemail();
MailMessage mm = new MailMessage("*****@*****.**",
"*****@*****.**");
mm.Subject = "Requisition Form " + Requid.ToString() + " Status";
mm.Body = "Your Requisition Request has been rejected! Reason: " + reason;
Business.sendemail().Send(mm);
Response.Redirect("Authorise Requsition list.aspx");
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//Clicking this button will generate a new Adjustment voucher. Those values displayed in the gridview
//wil be added into the adjustment voucher accordingly. This adjustment voucher will be added into the database
LastADEntities entities = new LastADEntities();
for (int i = 0; i < list3.Rows.Count; i++)
{
AdjVoucher adj = new AdjVoucher();
adj.ItemId = (list3.Rows[i][0].ToString());
adj.QuantityAdj = Int32.Parse(list3.Rows[i][1].ToString());
adj.Reason = list3.Rows[i][2].ToString();
if (Session["EmpId"] != null)
{
adj.RequestEmpNum = Int32.Parse(Session["EmpId"].ToString());
}
adj.SubmitDate = DateTime.Now;
adj.Status = "Pending Authorisation";
entities.AdjVouchers.Add(adj);
entities.SaveChanges();
}
//An email will be sent to the supervisor for approval.
string bossmail = "*****@*****.**";
Business.sendemail();
MailMessage mm = new MailMessage("*****@*****.**",
bossmail);
mm.Subject = "The new Adjustment voucher has been send to you, please help us check and review";
mm.Body = "There are" + list3.Rows.Count.ToString() + " item need to be issued";
Business.sendemail().Send(mm);
Response.Redirect("DiscrepancyListSubmitted.aspx");
}
protected void Button4_Click(object sender, EventArgs e)
{
LastADEntities entities = new LastADEntities();
if (Session["a"] != null)
{
list2 = (ArrayList)Session["a"];
}
Requisition rr = new Requisition();
List <Requisition> c = new List <Requisition>();
List <string> email = new List <string>();
foreach (int i in list2)
{
rr = entities.Requisitions.Where(x => x.RequId == i).First();
string emal = rr.Employee.Department.Employees.Where(x => x.RoleId == 5).First().Email.ToString();
c.Add(rr);
email.Add(emal);
}
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
TextBox txt = (TextBox)this.GridView1.Rows[i].Cells[5].FindControl("TextBox1");
int RetrievedAmt = Int32.Parse(txt.Text);
Label lab = (Label)this.GridView1.Rows[i].Cells[2].FindControl("Label7");
RequDetail requDetail = new RequDetail();
c = c.Where(x => x.RequDetails.Select(y => y.ItemId).Contains(lab.Text)).OrderBy(x => x.SignDate).ToList();
foreach (Requisition requ in c)
{
DateTime entryday = DateTime.Now;
int? RetrievedAmtnt = requ.RequDetails.Where(x => x.ItemId.Equals(lab.Text)).Select(x => x.RequestedQuantity).First();
if (RetrievedAmt == 0)
{
}
else if (RetrievedAmt < RetrievedAmtnt)
{
RetrievedAmtnt = RetrievedAmt;
}
if (RetrievedAmtnt != 0)
{
RequDetail requde = new RequDetail();
requde = requ.RequDetails.Where(x => x.ItemId.Equals(lab.Text)).First();
int balance = Convert.ToInt32(requde.ItemList.Stock) - Convert.ToInt32(RetrievedAmtnt);
Transaction tt = new Transaction();
tt.Balance = balance;
tt.EntryDate = entryday;
tt.ItemId = requde.ItemId;
tt.Quantity = RetrievedAmtnt;
tt.Requid = requde.RequId;
ItemList ii = new ItemList();
ii = requde.ItemList;
ii.Stock = balance;
entities.Transactions.Add(tt);
entities.SaveChanges();
RetrievedAmt = RetrievedAmt - Convert.ToInt32(RetrievedAmtnt);
}
}
foreach (Requisition requ in c)
{
requ.Status = "Waiting For Delivery";
entities.SaveChanges();
}
}
foreach (string em in email)
{
string bossmail = em;
Business.sendemail();
MailMessage mm = new MailMessage("*****@*****.**",
bossmail);
mm.Subject = "Your Requisition order has been send to your collection point ";
mm.Body = "Your Requisition order has been send to your collection point, please collect your item before tmr 12:00pm ";
Business.sendemail().Send(mm);
}
Response.Redirect("DisbursementList.aspx");
}
