protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowindex = Convert.ToInt32(e.CommandArgument);
int adjid = Int32.Parse(((Label)GridView2.Rows[rowindex].FindControl("Label1")).Text);
using (LastADEntities entities = new LastADEntities())
{
AdjVoucher abc = entities.AdjVouchers.Where(p => p.AdjVoucherId == adjid).First();
if (e.CommandName == "Issue Voucher")
{
abc.ApprovedDate = DateTime.Now;
//abc.ApprovalEmpNum = ...
abc.Status = "Authorised";
entities.SaveChanges();
Transaction trans = new Transaction();
string itemname = ((Label)GridView2.Rows[rowindex].FindControl("Label3")).Text;
string ItemId = Business.Finditemidbyname(itemname);
trans.ItemId = ItemId;
int Quantity = Int32.Parse(((Label)GridView2.Rows[rowindex].FindControl("Label4")).Text);
trans.Quantity = Quantity;
ItemList i = entities.ItemLists.Find(ItemId);
int stock = (int)i.Stock;
int Balance = stock + (Quantity);
trans.Balance = Balance;
trans.AdjVoucherId = adjid;
trans.EntryDate = DateTime.Now;
entities.Transactions.Add(trans);
entities.SaveChanges();
GridView2.DataBind();
ItemList xyz = entities.ItemLists.Where(p => p.ItemId == ItemId).First();
xyz.Stock = Balance;
entities.SaveChanges();
Response.Redirect("~/6StoreSupervisor/SupervisorAdjVoucher.aspx");
}
else if (e.CommandName == "Inform Manager")
{
abc.Status = "PendingDHAuthorisation";
entities.SaveChanges();
Response.Redirect("~/6StoreSupervisor/SupervisorAdjVoucher.aspx");
}
}
}
public String UpdateAdjVoucher(WCF_AdjVoucher AdjV)
{
LastADEntities entities = new LastADEntities();
AdjVoucher adj = new AdjVoucher();
adj.ItemId = AdjV.ItemId;
adj.QuantityAdj = Int32.Parse(AdjV.QuantityAdj);
adj.Reason = AdjV.Reason;
adj.RequestEmpNum = Int32.Parse(AdjV.RequestEmpNum);
adj.SubmitDate = DateTime.Now;
adj.Status = "Pending Authorisation";
entities.AdjVouchers.Add(adj);
entities.SaveChanges();
return("Successfully");
}
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");
}