protected void gvApproval_RowCommand(object sender, GridViewCommandEventArgs e) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); int approvalId = int.Parse(e.CommandArgument.ToString()); int approvalResponse = 0; GridViewRow row = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer); string comment = ((TextBox)row.FindControl("txtComment")).Text.Trim(); using (DataTable dtApproval = new DataTable()) { dtApproval.Columns.Add("ApprovalId"); dtApproval.Columns.Add("ServiceBookId"); dtApproval.Columns.Add("ItemId"); dtApproval.Columns.Add("ApprovalStatus"); dtApproval.Columns.Add("IsLowYield"); dtApproval.Columns.Add("CallStatus"); dtApproval.Columns.Add("RespondBy"); dtApproval.Columns.Add("Comment"); dtApproval.Columns.Add("RequisiteQty"); DataRow drApprovalItem = dtApproval.NewRow(); drApprovalItem["ApprovalId"] = approvalId; drApprovalItem["ServiceBookId"] = 0; drApprovalItem["ItemId"] = 0; drApprovalItem["ApprovalStatus"] = (e.CommandName == "Approve") ? (int)ApprovalStatus.Approved : (int)ApprovalStatus.Rejected; drApprovalItem["RespondBy"] = Convert.ToInt32(HttpContext.Current.User.Identity.Name); drApprovalItem["Comment"] = comment; dtApproval.Rows.Add(drApprovalItem); dtApproval.AcceptChanges(); serviceBook.ApprovalItems = dtApproval; serviceBook.ApprovalItems.AcceptChanges(); approvalResponse = objServiceBook.Service_ServiceBookDetailsApproval_Save(serviceBook); if (approvalResponse > 0) { Service_ServiceBookDetailsApproval_GetAll(); Message.IsSuccess = true; Message.Text = "Toner response has been given."; } else { Message.IsSuccess = false; Message.Text = "Toner response failed."; } Message.Show = true; } }
private void Service_ServiceBookDetailsApproval_GetAll() { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook() { MachineId = txtMachineId.Text.Trim(), FromDate = (!string.IsNullOrEmpty(txtLogFromDate.Text.Trim()) ? Convert.ToDateTime(txtLogFromDate.Text.Trim()) : DateTime.MinValue), ToDate = (!string.IsNullOrEmpty(txtLogToDate.Text.Trim()) ? Convert.ToDateTime(txtLogToDate.Text.Trim()) : DateTime.MinValue), ApprovalStatus = Convert.ToInt32(ddlApprovalStatus.SelectedValue), CallType = (int)CallType.Toner }; DataTable dt = objServiceBook.Service_ServiceBookDetailsApproval_GetAll(serviceBook); gvApproval.DataSource = dt; gvApproval.DataBind(); }
protected void btnSearch_Click(object sender, EventArgs e) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); serviceBook.CustomerName = txtCustomerName.Text.Trim(); serviceBook.ModelId = int.Parse(ddlDocketProduct.SelectedValue); serviceBook.MachineId = txtMachineId.Text.Trim(); serviceBook.FromDate = (!string.IsNullOrEmpty(txtFromDocketDate.Text.Trim())) ? Convert.ToDateTime(txtFromDocketDate.Text.Trim()) : DateTime.MinValue; serviceBook.ToDate = (!string.IsNullOrEmpty(txtToDocketDate.Text.Trim())) ? Convert.ToDateTime(txtToDocketDate.Text.Trim()) : DateTime.MinValue; serviceBook.CallStatusId = int.Parse(ddlDocketCallStatus.SelectedValue); serviceBook.DocketType = ddlDocketType.SelectedValue; serviceBook.EmployeeId_FK = int.Parse(ddlServiceEngineer.SelectedValue); DataTable dt = objServiceBook.Service_ServiceBook_GetAll(Convert.ToInt32(ddlCallType.SelectedValue), serviceBook); if (dt != null) { if (Convert.ToInt32(ddlCallType.SelectedValue) == (int)CallType.Docket) { pnlServiceDocket.Visible = true; pnlServiceToner.Visible = false; gvServiceDocket.DataSource = dt; gvServiceDocket.DataBind(); } else if (Convert.ToInt32(ddlCallType.SelectedValue) == (int)CallType.Toner) { pnlServiceDocket.Visible = false; pnlServiceToner.Visible = true; gvServiceToner.DataSource = dt; gvServiceToner.DataBind(); } } if (ddlCallType.SelectedValue != "0") { lblListTitle.Text = ddlCallType.SelectedItem.Text; } else { lblListTitle.Text = ""; } }
private static int Approval_Save(Entity.Service.TonerRequest tonnerRequest, DataTable dtTonnerRequest, bool isLowYield) { int approvalResponse = 0; Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); using (DataTable dtApproval = new DataTable()) { dtApproval.Columns.Add("ApprovalId"); dtApproval.Columns.Add("ServiceBookId"); dtApproval.Columns.Add("ItemId"); dtApproval.Columns.Add("ApprovalStatus"); dtApproval.Columns.Add("IsLowYield"); dtApproval.Columns.Add("CallStatus"); dtApproval.Columns.Add("RespondBy"); dtApproval.Columns.Add("Comment"); dtApproval.Columns.Add("RequisiteQty"); foreach (TonerIdQuantity item in tonnerRequest.SpareIds) { DataRow drApprovalItem = dtApproval.NewRow(); drApprovalItem["ApprovalId"] = 0; drApprovalItem["ServiceBookId"] = dtTonnerRequest.Rows[0]["ServiceBookId"].ToString(); drApprovalItem["ItemId"] = item.TonerId; drApprovalItem["ApprovalStatus"] = (isLowYield) ? (int)ApprovalStatus.None : (int)ApprovalStatus.Approved; drApprovalItem["IsLowYield"] = isLowYield; drApprovalItem["CallStatus"] = (isLowYield) ? (int)CallStatusType.TonerOpenForApproval : (int)CallStatusType.TonerRequestInQueue; drApprovalItem["RespondBy"] = string.Empty; drApprovalItem["Comment"] = (isLowYield) ? "NEED TONER APPROVAL" : "AUTO APPROVED"; drApprovalItem["RequisiteQty"] = item.Quantity; dtApproval.Rows.Add(drApprovalItem); dtApproval.AcceptChanges(); } serviceBook.ApprovalItems = dtApproval; serviceBook.ApprovalItems.AcceptChanges(); approvalResponse = objServiceBook.Service_ServiceBookDetailsApproval_Save(serviceBook); return(approvalResponse); } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (ComplainValidation()) { Business.Service.TonerRequest objTonnerRequest = new Business.Service.TonerRequest(); Entity.Service.TonerRequest tonnerRequest = new Entity.Service.TonerRequest(); Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { tonnerRequest.CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString()); serviceBook.CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString()); } } tonnerRequest.CustomerId = int.Parse(HttpContext.Current.User.Identity.Name.Split('|')[(int)Constants.Customer.ID]);; tonnerRequest.RequestNo = ""; tonnerRequest.RequestDateTime = DateTime.Now; tonnerRequest.isCustomerEntry = true; tonnerRequest.CallStatusId = (int)CallStatusType.TonerRequestInQueue; if (txtA3BWMeterReading.Text.Trim() == string.Empty) { tonnerRequest.A3BWMeterReading = null; } else { tonnerRequest.A3BWMeterReading = int.Parse(txtA3BWMeterReading.Text.Trim()); } if (txtA4BWMeterReading.Text.Trim() == string.Empty) { tonnerRequest.A4BWMeterReading = null; } else { tonnerRequest.A4BWMeterReading = int.Parse(txtA4BWMeterReading.Text.Trim()); } if (txtA3CLMeterReading.Text.Trim() == string.Empty) { tonnerRequest.A3CLMeterReading = null; } else { tonnerRequest.A3CLMeterReading = int.Parse(txtA3CLMeterReading.Text.Trim()); } if (txtA4CLMeterReading.Text.Trim() == string.Empty) { tonnerRequest.A4CLMeterReading = null; } else { tonnerRequest.A4CLMeterReading = int.Parse(txtA4CLMeterReading.Text.Trim()); } tonnerRequest.Remarks = txtRequest.Text.Trim(); tonnerRequest.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name.Split('|')[(int)Constants.Customer.ID]); foreach (GridViewRow toner in gvTonner.Rows) { if (((CheckBox)toner.FindControl("chk1")).Checked) { tonnerRequest.SpareIds.Add(new TonerIdQuantity { TonerId = long.Parse(gvTonner.DataKeys[toner.RowIndex].Values[0].ToString()), Quantity = int.Parse(((TextBox)toner.FindControl("txtRequisiteQty")).Text) }); } } if (txtA3BWMeterReading.Text.Trim() == string.Empty) { serviceBook.A3BWMeterReading = null; } else { serviceBook.A3BWMeterReading = int.Parse(txtA3BWMeterReading.Text.Trim()); } if (txtA4BWMeterReading.Text.Trim() == string.Empty) { serviceBook.A4BWMeterReading = null; } else { serviceBook.A4BWMeterReading = int.Parse(txtA4BWMeterReading.Text.Trim()); } if (txtA3CLMeterReading.Text.Trim() == string.Empty) { serviceBook.A3CLMeterReading = null; } else { serviceBook.A3CLMeterReading = int.Parse(txtA3CLMeterReading.Text.Trim()); } if (txtA4CLMeterReading.Text.Trim() == string.Empty) { serviceBook.A4CLMeterReading = null; } else { serviceBook.A4CLMeterReading = int.Parse(txtA4CLMeterReading.Text.Trim()); } DataTable dtTonnerRequest = objTonnerRequest.Service_TonerRequest_Save(tonnerRequest); bool isTonerLowYield = objTonnerRequest.Service_TonerLowYieldCheck(tonnerRequest); int meterUpdateResponse = objServiceBook.Service_MeterReading_Update(serviceBook); if (dtTonnerRequest.Rows.Count > 0 && meterUpdateResponse > 0) { string message = "Toner request received. Your request no : " + dtTonnerRequest.Rows[0]["TonnerRequestNo"].ToString() + ". "; /* Checking whether machine is in contract or not*/ Business.Service.Contract objContract = new Business.Service.Contract(); int approvalResponse = Approval_Save(tonnerRequest, dtTonnerRequest, isTonerLowYield); if (!objContract.Service_MachineIsInContractCheck(CustomerPurchaseId) || isTonerLowYield) //Out of Contract AND Low Yield { if (approvalResponse > 0) { //Appending low toner warning message += Server.HtmlDecode("<span style='color:red'>Warning: Your request is under verification</span>"); //SentNotification(objServiceBook, dtTonnerRequest); } } ResetControls(dtTonnerRequest); Message.IsSuccess = true; Message.Text = message; } else { Message.IsSuccess = false; Message.Text = "Sorry! we can not receive your request. Please try again."; } Message.Show = true; } }
public int Service_MeterReading_Update(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_MeterReading_Update(serviceBook)); }
public int Service_ServiceBookDetailsApproval_Save(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_ServiceBookDetailsApproval_Save(serviceBook)); }
public int Service_TonerRequest_Approve(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_TonerRequest_Approve(serviceBook)); }
public DataTable Service_ServiceBook_GetAll(int calltype, Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_ServiceBook_GetAll(calltype, serviceBook)); }
public DataSet Service_SpareUsage(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_SpareUsage(serviceBook)); }
public long Service_ServiceBook_Save(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_ServiceBook_Save(serviceBook)); }
public bool Service_ServiceSpareApprovalCheck(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_ServiceSpareApprovalCheck(serviceBook)); }
public int Service_CallTransfer_Save(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_CallTransfer_Save(serviceBook)); }
public DataTable Service_ServiceBookDetailsApproval_GetAll(Entity.Service.ServiceBook serviceBook) { return(DataAccess.Service.ServiceBook.Service_ServiceBookDetailsApproval_GetAll(serviceBook)); }