public static int AddStationeryRequistion(Stationery_Requisition stationery_request) { ssisEntities.Stationery_Requisition.Add(stationery_request); int result = ssisEntities.SaveChanges(); return(result); }
protected void Page_Load(object sender, EventArgs e) { ssisEntities = new SSISEntities(); Stationery_Requisition stationeryRequest = new Stationery_Requisition(); LoginDetails loginDetails = User.Identity as LoginDetails; string userId = loginDetails.UserId; Session["Mysession"] = Convert.ToInt32(userId); if (IsPostBack) { selectedproductList = (List <Stationery_Catalogue>)Session["Cart"]; } }
protected void btnReject_Click(object sender, EventArgs e) { string reason = txtReason.Text; int id = Int32.Parse(Session["Requisition_ID"].ToString()); using (SSISEntities ctx = new SSISEntities()) { Stationery_Requisition sr = ctx.Stationery_Requisition.Where(x => x.Requisition_ID == id).First(); sr.Status = "Rejected"; sr.Reason = reason; ctx.SaveChanges(); } Response.Redirect("PendingRequisitions.aspx"); }
protected void BtnSubmit_Click(object sender, EventArgs e) { Stationery_Requisition stationeryRequest = new Stationery_Requisition(); LoginDetails loginDetails = User.Identity as LoginDetails; string userId = loginDetails.UserId; stationeryRequest.User_ID = Convert.ToInt32(userId); stationeryRequest.Status = SSISConstants.PENDING; stationeryRequest.Requisition_Date = DateTime.Now; stationeryRequest.Requisition_Items = addRequisition_Items(); int result = Stationery_Requisition_DAO.AddStationeryRequistion(stationeryRequest); sendEmail(); Response.Redirect("Departmentrep_request_stationery.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int id = Int32.Parse(Session["Requisition_ID"].ToString()); using (SSISEntities ctx = new SSISEntities()) { Stationery_Requisition sr = ctx.Stationery_Requisition.Where(x => x.Requisition_ID == id).First(); lblRequistionFormID.Text = sr.Requisition_ID.ToString(); lblRequistionDate.Text = Convert.ToDateTime(sr.Requisition_Date).ToString("dd-MMMMM-yyyy"); lblSubmittedBy.Text = sr.Employee.Name.ToString(); } } }
protected void BtnSubmit_Click(object sender, EventArgs e) { Stationery_Requisition stationeryRequest = new Stationery_Requisition(); LoginDetails loginDetails = User.Identity as LoginDetails; string userId = loginDetails.UserId; stationeryRequest.User_ID = Convert.ToInt32(userId); stationeryRequest.Status = SSISConstants.PENDING; stationeryRequest.Requisition_Date = DateTime.Now; stationeryRequest.Requisition_Items = addRequisition_Items(); int result = Stationery_Requisition_DAO.AddStationeryRequistion(stationeryRequest); sendEmail(); List <Stationery_Catalogue> reqList = (List <Stationery_Catalogue>)Session["Cart"]; reqList.Clear(); Session["Cart"] = reqList; Response.Redirect("RequestStationery.aspx"); }
protected void btnApprove_Click(object sender, EventArgs e) { Department_Orders depOrder; string itemID; SSISEntities model = new SSISEntities(); Stationery_Requisition reqToAdd = model.Stationery_Requisition.Where(x => x.Requisition_ID == id).First(); Employee emp = model.Employees.Where(x => x.Id == reqToAdd.User_ID).First(); string depId = model.Departments.Where(x => x.Department_ID == emp.Department_ID).Select(x => x.Department_ID).First(); foreach (Requisition_Items req in reqToAdd.Requisition_Items) { itemID = req.Item_ID; var result = model.Department_Orders.Where(x => x.Item_ID == itemID && x.Department_ID == depId).SingleOrDefault(); if (result == null) { Department_Orders deptOrder = new Department_Orders(); deptOrder.Department_ID = depId; deptOrder.Item_ID = itemID; deptOrder.Requisition_Date = reqToAdd.Requisition_Date; deptOrder.Requisition_Quantity = req.Quantity; deptOrder.Fulfilled_Quantity = 0; deptOrder.IOU_Quantity = 0; deptOrder.Return_Quantity = 0; model.Department_Orders.Add(deptOrder); //reqToAdd.Status = "Processed"; model.SaveChanges(); //string script = "alert('Successfully Added to Retriveal List');"; //ClientScript.RegisterClientScriptBlock(this.GetType(), "Successfully Added to Retriveal List", script, true); } else { depOrder = result; depOrder.Requisition_Quantity = depOrder.Requisition_Quantity + req.Quantity; model.SaveChanges(); } Response.Redirect("~/com.ssis.storeclerk/Store_ListofRequisitionForms.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { id = Int32.Parse(Request.QueryString["rid"]); if (!IsPostBack) { using (SSISEntities ctx = new SSISEntities()) { Stationery_Requisition sr = ctx.Stationery_Requisition.Where(x => x.Requisition_ID == id).First(); Employee em = ctx.Employees.Where(x => x.Id == sr.User_ID).First(); string s = ctx.Departments.Where(x => x.Department_ID == em.Department_ID).Select(x => x.Department_Name).First(); lblDepartmentName.Text = s; lblRequistionFormID.Text = sr.Requisition_ID.ToString(); lblRequistionDate.Text = Convert.ToDateTime(sr.Requisition_Date).ToString("dd-MMMMM-yyyy"); lblSubmittedBy.Text = sr.Employee.Name.ToString(); } EntityDataSource1.Where = "it.[Requisition_ID]=" + id + " "; } }