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");
}
}
}
internal static void generatedishburement(List <string> idlist, List <int> amtlist)
{
LastADEntities entities = new LastADEntities();
RequDetail requDetail = new RequDetail();
for (int i = 0; i < idlist.Count(); i++)
{
string id = idlist[i];
var c = entities.Requisitions.Where(x => x.Status.Equals("Waiting For Collection") &&
x.RequDetails.Select(y => y.ItemId).Contains(id)).OrderBy(x => x.SignDate).ToList();
foreach (Requisition requ in c)
{
DateTime entryday = DateTime.Now;
int? RetrievedAmtnt = requ.RequDetails.Where(x => x.ItemId.Equals(idlist[i])).Select(x => x.RequestedQuantity).First();
if (amtlist[i] == 0)
{
}
else if (amtlist[i] < RetrievedAmtnt)
{
RetrievedAmtnt = amtlist[i];
}
if (RetrievedAmtnt != 0)
{
RequDetail requde = new RequDetail();
requde = requ.RequDetails.Where(x => x.ItemId.Equals(id)).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();
amtlist[i] = amtlist[i] - Convert.ToInt32(RetrievedAmtnt);
}
}
foreach (Requisition requ in c)
{
requ.Status = "Waiting For Delivery";
entities.SaveChanges();
}
}
}
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 Button1_Click(object sender, EventArgs e)
{
LastADEntities entities = new LastADEntities();
List <PurchaseOrderDetail> pd = entities.PurchaseOrderDetails.Where(x => x.PurchaseOrderId == poid).ToList();
PurchaseOrder ppo = entities.PurchaseOrders.Where(x => x.PurchaseOrderId == poid).First();
foreach (PurchaseOrderDetail p in pd)
{
String id = p.ItemId;
int qty = Convert.ToInt16(p.Amount);
int qtyy = Convert.ToInt16(p.Quantity);
int balance = Convert.ToInt16(p.ItemList.Stock) + qtyy;
//DateTime entryday = Convert.ToDateTime(p.PurchaseOrder.DeliveryDate);
ppo.DeliveryDate = DateTime.Now;
Transaction t = new Transaction();
t.Balance = balance;
t.EntryDate = DateTime.Now;
t.ItemId = id;
t.Quantity = qtyy;
t.PurchaseOrderId = poid;
ItemList ii = new ItemList();
ii = entities.ItemLists.Find(id);
ii.Stock = balance;
entities.Transactions.Add(t);
entities.SaveChanges();
}
List <PurchaseOrder> po = POcontrol.GetPurchaseOrder();
GridView1.DataSource = po;
GridView1.DataBind();
GridView2.DataSource = "";
GridView2.DataBind();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int UserId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
int RoleId = Int32.Parse((row.FindControl("DropDownList1") as DropDownList).SelectedValue);
DateTime stdate;
DateTime eddate;
try
{
stdate = (row.FindControl("Calendar1") as Calendar).SelectedDate;
eddate = (row.FindControl("Calendar2") as Calendar).SelectedDate;
using (LastADEntities entities = new LastADEntities())
{
Employee employee = entities.Employees.Where(p => p.UserId == UserId).First <Employee>();
employee.StartDate = stdate;
employee.EndDate = eddate;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
BindGrid();
}
catch (Exception f)
{
f.ToString();
Response.Redirect("DelegateRep.aspx");
}
}
//public static void ChangeCollectionPoint(int id)
//{
// LastADEntities ctx = new LastADEntities();
// Department c = ctx.Departments.Where(x => x.CollectionPointId == id).First();
// c.CollectionPointId = id;
// ctx.SaveChanges();
//}
public static void ChangeCollectionPoint(int id, string dpcd)
{
LastADEntities ctx = new LastADEntities();
Department c = ctx.Departments.Where(x => x.DepartmentCode == dpcd).First();
c.CollectionPointId = id;
ctx.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
String DpCode = Session["DpCode"].ToString();
LastADEntities ctx = new LastADEntities();
Department c = ctx.Departments.Where(x => x.DepartmentCode == DpCode).First();
c.CollectionPointId = RadioButtonList1.SelectedIndex + 1;
ctx.SaveChanges();
}
public static void ConfirmRequsition(int requsitionid, string reason, string signby)
{
using (LastADEntities ctx = new LastADEntities())
{
Requisition requsition = ctx.Requisitions.Where(x => x.RequId == requsitionid).First <Requisition>();
requsition.Status = "Waiting for Collection";
requsition.SignDate = DateTime.Now;
requsition.SignBy = signby;
requsition.Note = reason;
ctx.SaveChanges();
}
}
protected void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
int requDetailId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
using (LastADEntities entities = new LastADEntities())
{
RequDetail requdetails = entities.RequDetails.Where(p => p.RequDetailId == requDetailId).First <RequDetail>();
entities.RequDetails.Remove(requdetails);
entities.SaveChanges();
}
BindGrid();
}
// get PurchaseOrder i's OrderDetail
public static void PlacePurchaseOrder(List <itemsuppliers> cclist)
{
LastADEntities entities = new LastADEntities();
String[] ss = cclist.GroupBy(c => c.SupplierId).Select(c => c.Key).ToArray();
String[] sss = cclist.Select(c => c.SupplierId).ToArray();
int m = ss.Count();
for (int i = 0; i < m; i++)
{
PurchaseOrder po = new PurchaseOrder();
po.SupplierCode = ss[i];
po.PurchaseDate = DateTime.Now;
entities.PurchaseOrders.Add(po);
entities.SaveChanges();
for (int j = 0; j < cclist.Count(); j++)
{
if (sss[j] == ss[i])
{
PurchaseOrderDetail pod = new PurchaseOrderDetail();
pod.ItemId = cclist[j].ItemId;
ItemList item = new ItemList();
item = entities.ItemLists.Find(pod.ItemId);
decimal?price = item.ItemSuppliers.Where(x => x.SupplierCode.Equals(ss[i])).Select(x => x.Price).First();
pod.PurchaseOrderId = po.PurchaseOrderId;
pod.Quantity = cclist[j].ReOrderQty;
pod.Amount = pod.Quantity * price;
entities.PurchaseOrderDetails.Add(pod);
entities.SaveChanges();
}
}
}
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int UserId = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
int RoleId = Int32.Parse((row.FindControl("DropDownList1") as DropDownList).SelectedValue);
using (LastADEntities entities = new LastADEntities())
{
Employee employee = entities.Employees.Where(p => p.UserId == UserId).First <Employee>();
employee.RoleId = RoleId;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
BindGrid();
}
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 OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int requdetailid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Values[0]);
int requestedquantity = Int32.Parse((row.FindControl("TextBox1") as TextBox).Text);
using (LastADEntities entities = new LastADEntities())
{
RequDetail requdetail = entities.RequDetails.Where(p => p.RequDetailId == requdetailid).First <RequDetail>();
requdetail.RequestedQuantity = requestedquantity;
requdetail.OutstandingQuantity = requdetail.RequestedQuantity;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
BindGrid();
}
protected void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
String ItemId = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
int ReOrderLevel = Int32.Parse((row.FindControl("TextBox1") as TextBox).Text);
int ReOrderQty = Int32.Parse((row.FindControl("TextBox2") as TextBox).Text);
using (LastADEntities entities = new LastADEntities())
{
ItemList itemlist = entities.ItemLists.Where(p => p.ItemId.Equals(ItemId)).First <ItemList>();
itemlist.ReOrderLevel = ReOrderLevel;
itemlist.ReOrderQty = ReOrderQty;
entities.SaveChanges();
}
GridView1.EditIndex = -1;
BindGrid();
}
public static void RejectRequisition(int requisitionid, string reason, string signby)
{
using (LastADEntities ctx = new LastADEntities())
{
Requisition requsition = ctx.Requisitions.Where(x => x.RequId == requisitionid).First <Requisition>();
requsition.Status = "Rejected";
requsition.SignDate = DateTime.Now;
requsition.SignBy = signby;
requsition.Note = reason;
List <RequDetail> reqdetail = ctx.RequDetails.Where(y => y.RequId == requisitionid).ToList();
foreach (RequDetail a in reqdetail)
{
a.OutstandingQuantity = 0;
}
ctx.SaveChanges();
}
}
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");
}
public static String Confrimrequ(List <WCF_RequisitionDetail> WRDS)
{
//String WRDD= WRD.ToString();
//JArray array = (JArray)JsonConvert.DeserializeObject(WRDD);
//List<WCF_RequisitionDetail> WRDS = new List<WCF_RequisitionDetail>();
//foreach (JObject j in array)
//{
// WCF_RequisitionDetail w= j.ToObject<WCF_RequisitionDetail>();
// WRDS.Add(w);
//}
int requid = Convert.ToInt32(WRDS.First().Requid);
// int id = 13;
LastADEntities entities = new LastADEntities();
Requisition requ = entities.Requisitions.Where(x => x.RequId == requid).First();
List <RequDetail> details = requ.RequDetails.ToList();
int percentage = 0;
string ending = WRDS.ToString();
//String WCFitemid = "1";
try
{
// foreach (RequDetail detail in details)
for (int i = 0; i < WRDS.Count(); i++)
{
// entities.Entry(detail).State = System.Data.Entity.EntityState.Modified;
//WCFitemid = WRDS[i].itemid.ToString();
String WCFitemdesc = WRDS[i].name.ToString();
// ending = WCFitemid;
RequDetail wdetail = details.Where(x => x.ItemList.Description == WCFitemdesc).First();
wdetail.OutstandingQuantity = Convert.ToInt32(WRDS[i].OutstandingQuantity);
if (wdetail.OutstandingQuantity != 0)
{
percentage++;
}
else
{
}
if (percentage == 0)
{
requ.Status = "Completed";
requ.CollectionDate = DateTime.Now;
}
else
{
requ.Status = "Waiting for Collection";
}
entities.Entry(requ).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
ending = "execute successfully";
}
catch (Exception e)
{
ending = e.ToString();
}
return(ending);
}