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();
}
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 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();
}
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);
}
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");
}
