protected void Button1_Click(object sender, EventArgs e)
{
string departname = TextBox1.Text;
string itemnumber = TextBox2.Text;
int qunty = Convert.ToInt32(TextBox3.Text);
using (model)
{
string departid = model.Departments.Where(x => x.Department_Name == departname).Select(y => y.Department_Name).FirstOrDefault();
var depart = model.Disbursement_List.Where(x => x.Department_ID == departid && x.Status == "Pending").FirstOrDefault();
var list = model.Disbursement_List_dtl.Where(x => x.Disburse_ID == depart.Disburse_ID).ToList();
Disbursement_List_dtl list_Dtl = list.Where(x => x.Item_number == itemnumber).FirstOrDefault();
list_Dtl.Quantity -= qunty;
model.SaveChanges();
rollbackrequest(itemnumber, departid, qunty);
}
}
public static string disbursementprocess()
{
try
{
string[] departmentlist = new string[] { "CMC", "COO", "CSE", "ELC", "ENG", "HSE", "MEC", "MED", "REG", "STR" };
using (Logic_University_Entity m = new Logic_University_Entity())
{
DateTime date = DateTime.Now;
var s = date.ToString("yyyy-MM-dd");
DateTime da = DateTime.Parse(s);
var list = m.Request_completed.Where(x => x.Date == (da)).GroupBy(x => new { x.Department_ID, x.Item_Number, x.Inventory }).Select(x => new { x.Key.Department_ID, x.Key.Item_Number, req_qunty = x.Sum(y => y.Req_quantity), Deli_qunty = x.Sum(y => y.Delivered_quantity), x.Key.Inventory.Description }).ToList();
List <DemoClass> demos = new List <DemoClass>();
List <ClerkViewRequest> clist = new List <ClerkViewRequest>();
foreach (var v in list)
{
clist.Add(new ClerkViewRequest {
Department_ID = v.Department_ID, itemnumber = v.Item_Number, description = v.Description, Requried_qunty = v.req_qunty, delivered_qunty = v.Deli_qunty
});
}
foreach (var d in departmentlist)
{
List <ClerkViewRequest> disList = new List <ClerkViewRequest>();
foreach (var l in clist)
{
if (l.Department_ID.Equals(d))
{
disList.Add(l);
}
}
if (disList.Count != 0)
{
using (Logic_University_Entity dl = new Logic_University_Entity())
{
Disbursement_List disbursement_List = new Disbursement_List();
disbursement_List.Department_ID = d;
disbursement_List.Disburse_date = DateTime.Now;
disbursement_List.Status = "Pending";
dl.Disbursement_List.Add(disbursement_List);
dl.SaveChanges();
var lastrecord = dl.Disbursement_List.OrderByDescending(x => x.Disburse_ID).Take(1).FirstOrDefault();
foreach (var disDetails in disList)
{
Disbursement_List_dtl List_Dtl = new Disbursement_List_dtl();
List_Dtl.Disburse_ID = lastrecord.Disburse_ID;
List_Dtl.Item_number = disDetails.itemnumber;
List_Dtl.Quantity = disDetails.delivered_qunty;
List_Dtl.Discription = disDetails.description;
List_Dtl.req_qunty = disDetails.Requried_qunty;
dl.Disbursement_List_dtl.Add(List_Dtl);
dl.SaveChanges();
}
}
disList.Clear();
}
}
}
return("dis trun ");
}
catch (Exception exw)
{
return(exw.Message);
}
}
