public static void updateEmplyeeRequest(int Id)
{
var empreq = model.Employee_Request.Where(x => x.Request_ID == Id).FirstOrDefault();
empreq.Status = "Completed";
model.SaveChanges();
}
public void UpdateValues1(string repname, string departId)
{
Department department = model.Departments.Where(c => c.Department_ID == departId).First <Department>();
Employee repid = model.Employees.Where(x => x.Employee_Name == repname).FirstOrDefault();
department.Representative_ID = repid.Employee_ID;
model.SaveChanges();
}
public static string Warelist(List <ClerkViewRequest> updatelist, Employee user)
{
try
{
Wrehse_Trans trans = new Wrehse_Trans();
trans.Employee_ID = user.Employee_ID;
trans.Trans_Date = DateTime.Now;
model.Wrehse_Trans.Add(trans);
model.SaveChanges();
Wrehse_Trans last = model.Wrehse_Trans.OrderByDescending(x => x.Trans_ID).Take(1).FirstOrDefault();
foreach (var v in updatelist)
{
Wrehse_Trans_Dtl trans_Dtl = new Wrehse_Trans_Dtl();
trans_Dtl.Trans_ID = last.Trans_ID;
trans_Dtl.Item_number = v.itemnumber;
trans_Dtl.Retrived_Qunty = v.CollectedQuntity;
trans_Dtl.Available_Qunty = v.CollectedQuntity;
model.Wrehse_Trans_Dtl.Add(trans_Dtl);
var inventoriesChange = model.Inventories.Where(x => x.Item_Number.Equals(v.itemnumber)).FirstOrDefault();
inventoriesChange.Quantity -= v.CollectedQuntity;
model.SaveChanges();
if (v.DamagedQuantity > 0)
{
Dmg_Goods_Dtl d = new Dmg_Goods_Dtl();
d.Item_number = v.itemnumber;
d.Damage_Qnty = v.DamagedQuantity;
d.Location = "warehouse";
d.Details = "Damage";
d.Employee_ID = user.Employee_ID;
d.Dmg_Date = System.DateTime.Today;
inventoriesChange.Quantity -= v.DamagedQuantity;
model.Dmg_Goods_Dtl.Add(d);
model.SaveChanges();
}
}
return("UPDATE SUCCESS AND get all item fro store and down from inventory and add damage if ");
}
catch (Exception)
{
return("ERROR IN UPDATING WAREHOUSE");
}
}
public static void AddRequest(string description, int quantity)
{
var xy = (from z in entities.Inventories where z.Description == description select z.Item_Number).SingleOrDefault();
string itemnumber = xy.ToString();
Emp_Request_items item = new Emp_Request_items();
item.Item_Number = itemnumber;
item.Quantity = quantity;
item.Status = "Pending";
entities.Emp_Request_items.Add(item);
entities.SaveChanges();
}
public static void recordDamageDetails(String Itemnumber, int Quantity, String Location)
{
Dmg_Goods_Dtl dmg = new Dmg_Goods_Dtl();
dmg.Item_number = Itemnumber;
dmg.Damage_Qnty = Quantity;
dmg.Location = Location;
dmg.Employee_ID = "ENG002";
dmg.Details = " ";
dmg.Dmg_Date = System.DateTime.Now;
model.Dmg_Goods_Dtl.Add(dmg);
model.SaveChanges();
}
public static void Deleteitem(string itemnumber)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = entities.Inventories.Where(p => p.Item_Number == itemnumber).First <Inventory>();
entities.Inventories.Remove(inventory);
entities.SaveChanges();
}
}
public void ValidateDelg()
{
try
{
Employee user = (Employee)Session["user"];
string ss = user.Department_ID;
Approver approver = model.Approvers.Where(c => c.Department_ID == ss && c.Status == "Active").First <Approver>();
if (approver.End_Date < DateTime.Today)
{
approver.Status = "Inactive";
}
model.SaveChanges();
}
catch (Exception)
{
}
}
// To notify the stor clerk by email regarding change of collection point by department representative
public void sendNotificationByEmail(Employee emp, string value)
{
using (Logic_University_Entity t = new Logic_University_Entity())
{
// need to write two sql queries
//1) to find the department of the employee logged in using session
//2) to find the email address of the clerk and send email
//3) to find the employee email address using session
Department d = t.Departments.Where(x => x.Department_ID == emp.Department_ID).First <Department>();
d.Collection_Point = value;
t.SaveChanges();
MailMessage mail = new MailMessage();
mail.IsBodyHtml = true;
mail.To.Add("*****@*****.**");
mail.Subject = "Change of Collection Point";
string departmentName = d.Department_Name;
string departHead = d.Department_Head;
string departID = d.Department_ID;
Employee e = t.Employees.Where(x => x.Employee_ID == emp.Employee_ID).First <Employee>();
string depRepName = e.Employee_Name;
StringBuilder sb = new StringBuilder();
sb.Append("<table border='5', bordercolorlight='#b9dcff', bordercolordark='#006fdd', width='400',align='center',bordercolor='black'><tr><th>Title</th><th>Details</th></tr><tr><td><b>Department</b></td>" + "<td>" + departmentName + "</td></tr>" +
"<tr><td><b>Department Head</b></td>" + "<td>" + departHead + "</td></tr>" +
"<tr><td><b>Department ID</b></td>" + "<td>" + departID + "</td></tr>" +
"<tr><td><b>Department Rep Name</b></td>" + "<td>" + depRepName + "</td></tr>" +
"<tr><td><b>Updated Collection Point</b></td>" + "<td>" + value + "</td></tr></table>");
mail.Body = sb.ToString();
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("*****@*****.**", "Surendran");
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "littleflower");
smtp.EnableSsl = true;
smtp.Send(mail);
}
}
public static void Edititem(string itemnumber, int quantity, string suppiler_ID_1, string suppiler_ID_2, string suppiler_ID_3)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = entities.Inventories.Where(p => p.Item_Number == itemnumber).First <Inventory>();
inventory.Quantity = quantity;
inventory.Supplier_ID_1 = suppiler_ID_1;
inventory.Supplier_ID_2 = suppiler_ID_2;
inventory.Supplier_ID_3 = suppiler_ID_3;
entities.SaveChanges();
}
}
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 void OnRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
int quantity = Convert.ToInt32(e.NewValues["Quantity"]);
using (Logic_University_Entity entitie = new Logic_University_Entity())
{
int id = Convert.ToInt32(Request.QueryString["ID"]);
string description = row.Cells[0].Text.ToString();
string item_number = entitie.Inventories.Where(x => x.Description == description).Select(x => x.Item_Number).FirstOrDefault();
var emp = entitie.Emp_Request_items.Where(p => p.Request_ID == id && p.Item_Number == item_number).FirstOrDefault();
emp.Quantity = quantity;
entitie.SaveChanges();
GridView1.EditIndex = -1;
bind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (CheckBox1.Checked)
{
Employee user = (Employee)Session["user"];
string departid = user.Department_ID;
singlist = m.Disbursement_List.Where(x => x.Department_ID == departid && x.Status == "Pending").ToList();
if (singlist.Count() != 0)
{
foreach (Disbursement_List item in singlist)
{
item.Status = "Acknowledged";
m.SaveChanges();
}
}
}
}
public void OnRowDeleting(object sender, GridViewDeleteEventArgs e)
{
GridViewRow row = GridView1.Rows[e.RowIndex];
string descr = row.Cells[0].Text.ToString();
using (Logic_University_Entity entities = new Logic_University_Entity())
{
var xy1 = entities.Inventories.Where(x => x.Description == descr).FirstOrDefault();
string id = xy1.Item_Number;
int req_id = Convert.ToInt32(Request.QueryString["ID"]);
var emp = entities.Emp_Request_items.Where
(x => x.Request_ID.Equals(req_id) && x.Item_Number.Equals(id)).
FirstOrDefault();
entities.Emp_Request_items.Remove(emp);
entities.SaveChanges();
bind();
}
}
protected void Approve_Click(object sender, EventArgs e)
{
Employee user = (Employee)Session["user"];
Logic_University_Entity model = new Logic_University_Entity();
List <Voucher_details> voucherslist = model.Voucher_details.Where(x => x.Status == "Pending").ToList();
var newlist = voucherslist.Select(x => new { Id = x.ID, Status = x.Status }).ToList();
foreach (var v in newlist)
{
var first = model.Voucher_details.Where(x => x.ID == v.Id).FirstOrDefault();
first.Approve_ID = "STR001"; // user.Employee_ID;
first.Status = "APPROVED";
model.SaveChanges();
}
}
public static void AddItem(string itemnumber, string category, string description, int reorder_level, int reorder_qty, decimal price, string unit_measure, int quantity, string bin_number, string suppiler_ID_1, string suppiler_ID_2, string suppiler_ID_3)
{
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Inventory inventory = new Inventory
{
Item_Number = itemnumber,
Category = category,
Description = description,
Reorder_level = reorder_level,
Reorder_qty = reorder_qty,
Price = price,
Unit_Measure = unit_measure,
Quantity = quantity,
Bin_number = bin_number,
Supplier_ID_1 = suppiler_ID_1,
Supplier_ID_2 = suppiler_ID_2,
Supplier_ID_3 = suppiler_ID_3,
};
entities.Inventories.Add(inventory);
entities.SaveChanges();
}
}
protected void btn_Submitrequest_Click(object sender, EventArgs e)
{
List <EmployeeMakeReq> employeeMakes = new List <EmployeeMakeReq>();
int count = Requestdetails.Rows.Count;
for (int i = 0; i < count; i++)
{
GridViewRow r = Requestdetails.Rows[i];
DropDownList description = (DropDownList)r.Cells[1].FindControl("DropDownList2");
TextBox b = (TextBox)r.Cells[2].FindControl("TextBox1");
string desc = description.Text.ToString();
int quantity = Convert.ToInt32(b.Text);
employeeMakes.Add(new EmployeeMakeReq(desc, quantity));
}
try
{
Employee user = (Employee)Session["user"];
using (Logic_University_Entity entities = new Logic_University_Entity())
{
Employee_Request request = new Employee_Request();
request.Department_ID = user.Department_ID;
request.Employee_ID = user.Employee_ID;
request.Date_of_Request = System.DateTime.Now;
request.Status = "Pending";
entities.Employee_Request.Add(request);
entities.SaveChanges();
Employee_Request Requestid = entities.Employee_Request.OrderByDescending(x => x.Request_ID).Take(1).FirstOrDefault();
foreach (var v in employeeMakes)
{
var xy = (from z in entities.Inventories where z.Description == v.Description select z.Item_Number).SingleOrDefault();
string itemnumber = xy.ToString();
Emp_Request_items item = new Emp_Request_items();
item.Request_ID = Requestid.Request_ID;
item.Item_Number = itemnumber;
item.Quantity = v.Quantity;
item.Status = "Pending";
entities.Emp_Request_items.Add(item);
entities.SaveChanges();
}
btn_Submitrequest.Enabled = false;
}
MailMessage mail = new MailMessage();
mail.IsBodyHtml = false;
string empid = user.Employee_ID;
string mv = sm.Employees.Where(x => x.Employee_ID == empid).FirstOrDefault <Employee>().Email;
mail.To.Add(mv);
mail.Subject = "Application for Stationary requests";
string name = user.Employee_Name;
mail.Body = "Hi HOD," + Environment.NewLine + "I've applied for stationary." + Environment.NewLine + "Best Regards," + Environment.NewLine + name;
SmtpClient smtp = new SmtpClient();
mail.From = new MailAddress("*****@*****.**", "Surendran");
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "littleflower");
smtp.EnableSsl = true;
smtp.Send(mail);
Response.Write(@"<script language='javascript'>alert('Request Sent successfully');window.location.href='RepHome.aspx'</script>");
}
catch (Exception)
{
}
}
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);
}
}
