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 = ""; } }
protected void chk_CheckedChanged(object sender, EventArgs e) { CheckBox chk = (CheckBox)sender; GridViewRow gv = (GridViewRow)chk.NamingContainer; foreach (GridViewRow gvr in gvPurchase.Rows) { if (gvr != gv) { ((CheckBox)gvr.FindControl("chk")).Checked = false; } } if (chk.Checked) { //ContractTypeId = int.Parse(gvPurchase.DataKeys[gv.RowIndex].Values[1].ToString()); ModelName = gv.Cells[3].Text; MachineId = gv.Cells[4].Text; Business.Service.TonerRequest ObjBl = new Business.Service.TonerRequest(); DataTable dt = ObjBl.Service_Toner_GetAllByCustomerId(Int64.Parse(gvPurchase.DataKeys[gv.RowIndex].Values[0].ToString())); if (dt != null) { gvTonner.DataSource = dt; gvTonner.DataBind(); } Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); DataSet dsLastMeterReading = objServiceBook.Service_GetLastMeterReadingByCustomerPurchaseId(Int64.Parse(gvPurchase.DataKeys[gv.RowIndex].Values[0].ToString())); lblA3BWLastMeterReading.Text = dsLastMeterReading.Tables[0].Rows[0]["A3BWLastMeterReading"].ToString(); lblA3ClLastMeterReading.Text = dsLastMeterReading.Tables[0].Rows[0]["A3CLLastMeterReading"].ToString(); lblA4BWLastMeterReading.Text = dsLastMeterReading.Tables[0].Rows[0]["A4BWLastMeterReading"].ToString(); lblA4ClLastMeterReading.Text = dsLastMeterReading.Tables[0].Rows[0]["A4CLLastMeterReading"].ToString(); } else { ContractTypeId = 0; gvTonner.DataBind(); } }
private void Service_SpareUsage(int pageIndex, int pageSize) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook() { CustomerName = txtCustomerName.Text.Trim(), RequestNo = txtCallNo.Text.Trim(), ItemId = int.Parse(ddlItem.SelectedValue), EmployeeId_FK = int.Parse(ddlEmployee.SelectedValue), FromDate = (string.IsNullOrEmpty(txtFromLogRequestDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtFromLogRequestDate.Text.Trim()), ToDate = (string.IsNullOrEmpty(txtToLogRequestDate.Text.Trim())) ? DateTime.MinValue : Convert.ToDateTime(txtToLogRequestDate.Text.Trim()), PageIndex = pageIndex, PageSize = pageSize }; DataSet ds = objServiceBook.Service_SpareUsage(serviceBook); gvSpareUsage.DataSource = ds.Tables[0]; gvSpareUsage.VirtualItemCount = (ds.Tables[1].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[1].Rows[0]["TotalCount"].ToString()) : 10; gvSpareUsage.DataBind(); }
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); } }
private void Service_Challan_GetByTonerRequestNo(string requestNo) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); DataSet ds = new DataSet(); ds = objServiceBook.Service_Challan_GetByTonerRequestNo(requestNo); if (ds != null) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { tdConsigneeName.InnerHtml = ds.Tables[0].Rows[0]["CustomerName"].ToString(); tdRemarks.InnerHtml = ds.Tables[0].Rows[0]["Remarks"].ToString(); } if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { tdDescription.InnerHtml = ds.Tables[1].Rows[0]["SpareName"].ToString(); } } PrintDateTime.InnerHtml = System.DateTime.Now.ToString("dd/MMM/yyyy HH:MM tt"); }
private void Service_ServiceCallAttendance_GetAll() { try { Business.Service.ServiceBook objService = new Business.Service.ServiceBook(); Entity.Service.ServiceCallAttendance serviceCallAttendance = new Entity.Service.ServiceCallAttendance(); serviceCallAttendance.RequestNo = (string.IsNullOrEmpty(txtDocketNo.Text.Trim()) ? string.Empty : txtDocketNo.Text.Trim()); serviceCallAttendance.MachineId = (string.IsNullOrEmpty(txtMachineId.Text.Trim()) ? string.Empty : txtMachineId.Text.Trim()); serviceCallAttendance.EmployeeId = Convert.ToInt32(ddlEngineer.SelectedValue); //serviceCallAttendance.FromDate = (string.IsNullOrEmpty(txtFromInDate.Text.Trim()) ? DateTime.MinValue : Convert.ToDateTime(txtFromInDate.Text.Trim())); //serviceCallAttendance.ToDate = (string.IsNullOrEmpty(txtToInDate.Text.Trim()) ? DateTime.MinValue : Convert.ToDateTime(txtToInDate.Text.Trim())); DataSet dsCallAttendance = objService.Service_ServiceCallAttendance_GetAll(serviceCallAttendance); gvCallAttendance.DataSource = dsCallAttendance.Tables[0]; gvCallAttendance.DataBind(); } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
protected void gvCallAttendance_RowCommand(object sender, GridViewCommandEventArgs e) { try { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); if (e.CommandName == "E") { Entity.Service.ServiceCallAttendance serviceCallAttendance = new Entity.Service.ServiceCallAttendance(); GridViewRow gvCallAttendanceRow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); TextBox txtInDate = (TextBox)gvCallAttendanceRow.FindControl("txtInDate"); DropDownList ddlInTimeHH = (DropDownList)gvCallAttendanceRow.FindControl("ddlInTimeHH"); DropDownList ddlInTimeMM = (DropDownList)gvCallAttendanceRow.FindControl("ddlInTimeMM"); DropDownList ddlInTimeTT = (DropDownList)gvCallAttendanceRow.FindControl("ddlInTimeTT"); TextBox txtOutDate = (TextBox)gvCallAttendanceRow.FindControl("txtOutDate"); DropDownList ddlOutTimeHH = (DropDownList)gvCallAttendanceRow.FindControl("ddlOutTimeHH"); DropDownList ddlOutTimeMM = (DropDownList)gvCallAttendanceRow.FindControl("ddlOutTimeMM"); DropDownList ddlOutTimeTT = (DropDownList)gvCallAttendanceRow.FindControl("ddlOutTimeTT"); DropDownList ddlDocketCallStatus = (DropDownList)gvCallAttendanceRow.FindControl("ddlDocketCallStatus"); serviceCallAttendance.ServiceCallAttendanceId = int.Parse(e.CommandArgument.ToString()); serviceCallAttendance.CallStatusId = int.Parse(ddlDocketCallStatus.SelectedValue); serviceCallAttendance.InTime = Convert.ToDateTime(txtInDate.Text + " " + ddlInTimeHH.SelectedValue + ":" + ddlInTimeMM.SelectedValue + ":00" + " " + ddlInTimeTT.SelectedValue); if (!string.IsNullOrEmpty(txtOutDate.Text.Trim()) && ddlOutTimeHH.SelectedIndex != 0 && ddlOutTimeMM.SelectedIndex != 0) { serviceCallAttendance.OutTime = (Request.QueryString["action"] != null && Request.QueryString["action"].Equals("callin")) ? DateTime.MinValue : Convert.ToDateTime(txtOutDate.Text + " " + ddlOutTimeHH.SelectedValue + ":" + ddlOutTimeMM.SelectedValue + ":00" + " " + ddlOutTimeTT.SelectedValue); } int response = objServiceBook.Service_CallAttendance_Edit(serviceCallAttendance); if (response > 0) { ClearControls(); Message.IsSuccess = true; Message.Text = "Call attendance record is updated."; } else { Message.IsSuccess = false; Message.Text = "Sorry! Call attendance record is not updated."; } Message.Show = true; } else if (e.CommandName == "D") { int response = objServiceBook.Service_CallAttendance_Delete(int.Parse(e.CommandArgument.ToString())); if (response > 0) { Service_ServiceCallAttendance_GetAll(); Message.IsSuccess = true; Message.Text = "Call attendance record is deleted."; } else { Message.IsSuccess = false; Message.Text = "Sorry! Call attendance record is not deleted."; } Message.Show = true; } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
public int Service_Amcv_Calculate_Save(long customerPurchaseId) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); return(objServiceBook.Service_Amcv_Calculate_Save(customerPurchaseId, DateTime.Now)); }
public DataTable GetCustomerPurchaseForPMCall() { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); return(objServiceBook.Service_GetCustomerPurchaseForPMCall(DateTime.Now)); }
protected void RepeaterInventory_ItemCommand(object source, RepeaterCommandEventArgs e) { try { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); if (e.CommandName == "Add") { Message.Show = false; string assetId = e.CommandArgument.ToString().Split('|')[0]; string itemId = e.CommandArgument.ToString().Split('|')[1]; string stockLocationId = e.CommandArgument.ToString().Split('|')[2]; if (objServiceBook.Service_GetServiceBookDetailsApprovalStatus(Business.Common.Context.ServiceBookId, Convert.ToInt64(itemId)) == Entity.Service.ApprovalStatus.Rejected) { Message.IsSuccess = false; Message.Text = "Invalid request. Not able to add since it is already rejected."; Message.Show = true; } else if (Business.Common.Context.SelectedSaleAssets != null && Business.Common.Context.SelectedSaleAssets.Rows.Count > 0 && Business.Common.Context.SelectedSaleAssets.AsEnumerable().Where(p => p["ItemId"].ToString() == itemId).Any() && Business.Common.Context.SelectedSaleAssets.AsEnumerable().Count(p => p["ItemId"].ToString() == itemId) >= _Quantity) { Message.IsSuccess = false; Message.Text = "Max limit of selection is reached."; Message.Show = true; } else { if (Business.Common.Context.SelectedSaleAssets.Rows.Count == 0) { Business.Common.Context.SelectedSaleAssets = new DataTable(); Business.Common.Context.SelectedSaleAssets.Columns.Add("AssetId"); Business.Common.Context.SelectedSaleAssets.Columns.Add("ItemId"); Business.Common.Context.SelectedSaleAssets.Columns.Add("ItemName"); Business.Common.Context.SelectedSaleAssets.Columns.Add("ItemType"); Business.Common.Context.SelectedSaleAssets.Columns.Add("Finalized"); Business.Common.Context.SelectedSaleAssets.Columns.Add("StockLocationId"); } DataRow dr = Business.Common.Context.SelectedSaleAssets.NewRow(); dr["AssetId"] = assetId; dr["ItemId"] = itemId; dr["ItemName"] = _ItemName; dr["ItemType"] = (int)_ItemType; dr["Finalized"] = "False"; dr["StockLocationId"] = stockLocationId; Business.Common.Context.SelectedSaleAssets.Rows.Add(dr); LoadItemFromStore(); LoadSelectedSaleAssets(); } } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } }
private void SentNotification(Business.Service.ServiceBook objServiceBook, DataTable dtTonnerRequest) { //Checking whether low tonner request, if yes then send notification mail using (DataSet ds = objServiceBook.Service_Tonner_GetByTonnerRequestId(TonnerRequestId)) { string A3BWCurrentMeterReading = "", A3CLCurrentMeterReading = "", A4CLCurrentMeterReading = "", A4BWCurrentMeterReading = "", A3BWLastMeterReading = "", A3CLLastMeterReading = "", A4CLLastMeterReading = "", A4BWLastMeterReading = "", TonnerName = "", Yield = "", TonnerRequestNo = ""; if (ds != null) { TonnerRequestNo = dtTonnerRequest.Rows[0]["TonnerRequestNo"].ToString(); TonnerName = (ds.Tables[0].Rows[0]["SpareName"] == DBNull.Value) ? "" : ds.Tables[0].Rows[0]["SpareName"].ToString(); Yield = (ds.Tables[0].Rows[0]["Yield"] == DBNull.Value) ? "" : ds.Tables[0].Rows[0]["Yield"].ToString(); A3BWCurrentMeterReading = (ds.Tables[0].Rows[0]["A3BWCurrentMeterReading"] == DBNull.Value) ? "0" : ds.Tables[0].Rows[0]["A3BWCurrentMeterReading"].ToString(); A3CLCurrentMeterReading = (ds.Tables[0].Rows[0]["A3CLCurrentMeterReading"] == DBNull.Value) ? "0" : ds.Tables[0].Rows[0]["A3CLCurrentMeterReading"].ToString(); A4CLCurrentMeterReading = (ds.Tables[0].Rows[0]["A4CLCurrentMeterReading"] == DBNull.Value) ? "0" : ds.Tables[0].Rows[0]["A4CLCurrentMeterReading"].ToString(); A4BWCurrentMeterReading = (ds.Tables[0].Rows[0]["A4BWCurrentMeterReading"] == DBNull.Value) ? "0" : ds.Tables[0].Rows[0]["A4BWCurrentMeterReading"].ToString(); A3BWLastMeterReading = (ds.Tables[1].Rows.Count == 0 || ds.Tables[1].Rows[0]["A3BWLastMeterReading"] == DBNull.Value) ? "0" : ds.Tables[1].Rows[0]["A3BWLastMeterReading"].ToString(); A4BWLastMeterReading = (ds.Tables[1].Rows.Count == 0 || ds.Tables[1].Rows[0]["A4BWLastMeterReading"] == DBNull.Value) ? "0" : ds.Tables[1].Rows[0]["A4BWLastMeterReading"].ToString(); A3CLLastMeterReading = (ds.Tables[1].Rows.Count == 0 || ds.Tables[1].Rows[0]["A3CLLastMeterReading"] == DBNull.Value) ? "0" : ds.Tables[1].Rows[0]["A3CLLastMeterReading"].ToString(); A4CLLastMeterReading = (ds.Tables[1].Rows.Count == 0 || ds.Tables[1].Rows[0]["A4CLLastMeterReading"] == DBNull.Value) ? "0" : ds.Tables[1].Rows[0]["A4CLLastMeterReading"].ToString(); } //Mail body StringBuilder sb = new StringBuilder(); sb.Append("<div style='width: 99%; font-family: Cambria, Georgia, serif; color: #565656; margin:10px'>"); sb.Append("<center><img src='http://aegiscrm.in/images/Aegis_CRM_Logo.png' alt='AEGIS CRM' />"); sb.Append("<h2>Aegis Customer Relationship Management Notification</h2><br /></center>"); sb.Append("Date:- " + DateTime.Now.ToString("dd/MM/yyyy") + "<br /><br />"); sb.Append("Dear Aegis CRM Admin,<br />"); sb.Append("A customer/employee has made a low tonner request and waiting for approval.<br /><br />"); sb.Append("<b><u>Low Toner Request Details</u>:<br /><br />"); sb.Append("Toner Request No - " + TonnerRequestNo + "<br />"); sb.Append("Customer Name - " + CustomerName + "<br />"); sb.Append("Request Date and Time - " + System.DateTime.Now.ToString("dd/MM/yyyy hh:mm tt") + "<br />"); sb.Append("A3 B/W Current Meter Reading - " + A3BWCurrentMeterReading + "<br />"); sb.Append("A3 CL Current Meter Reading - " + A3CLCurrentMeterReading + "<br />"); sb.Append("A4 B/W Current Meter Reading - " + A4BWCurrentMeterReading + "<br />"); sb.Append("A4 CL Current Meter Reading - " + A4CLCurrentMeterReading + "<br />"); sb.Append("A3 B/W Last Toner Reading - " + A3BWLastMeterReading + "<br />"); sb.Append("A3 CL Last Toner Reading - " + A3CLLastMeterReading + "<br />"); sb.Append("A4 B/W Last Toner Reading - " + A4BWLastMeterReading + "<br />"); sb.Append("A4 CL Last Toner Reading - " + A4CLLastMeterReading + "<br />"); sb.Append("Model Name - " + ModelName + "<br />"); sb.Append("Machine ID - " + MachineId + "<br />"); sb.Append("Toner Name - " + TonnerName + "<br />"); sb.Append("Toner Yield- " + Yield + "</b><br /><br />"); sb.Append("Click to login into portal <a href='http://aegiscrm.in'>aegiscrm.in</a><br /><br />"); sb.Append("<hr />"); sb.Append("<center tyle='color:#C68E17'>*** This is a system generated mail. Please do not reply. ***</center>"); sb.Append("</div>"); //string fromMail = "", toMail = "", password = "", subject = ""; //fromMail = "*****@*****.**"; //password = "******"; //toMail = "*****@*****.**"; //subject = "Low Toner Request Notification"; //Business.Common.MailFunctionality.SendMail_HostingRaja(fromMail, toMail, password, subject, sb.ToString()); } }
protected bool ComplainValidation() { bool flag = false; bool isTonerSelected = false; if (gvTonner.Rows.Count > 0) { foreach (GridViewRow toner in gvTonner.Rows) { CheckBox chkToner = (CheckBox)toner.FindControl("chk1"); if (chkToner.Checked) { isTonerSelected = true; break; } } } if (!isTonerSelected) { Message.Text = "Please select toner"; Message.Show = true; return(false); } foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { flag = true; } } foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString()); Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); /* Checking whether any one open tonner request exists or not*/ if (bool.Parse(((objServiceBook.Service_CheckIfAnyOpenTonnerRequest(CustomerPurchaseId).Rows[0]["Flag"].ToString()) == "1") ? "True" : "False")) { Message.IsSuccess = false; Message.Text = "A Toner Request is under approval. You can not request more than one."; Message.Show = true; return(false); } /* Checking whether machine is in contract or not*/ //Business.Service.Contract objContract = new Business.Service.Contract(); //DataTable dt = new DataTable(); //dt = objContract.Service_MachineIsInContractCheck(CustomerPurchaseId); //if (dt != null) //{ // if (dt.Rows.Count > 0) // { // if (!bool.Parse((dt.Rows[0]["Flag"].ToString() == "1") ? "True" : "False")) // { // Message.IsSuccess = false; // Message.Text = "Out of Contract! Please call Customer Help Desk."; // Message.Show = true; // return false; // } // } //} } } if (txtA3BWMeterReading.Text.Trim() == string.Empty) { flag = false; } if (txtA3CLMeterReading.Text.Trim() == string.Empty) { flag = false; } if (txtA4BWMeterReading.Text.Trim() == string.Empty) { flag = false; } if (txtA4CLMeterReading.Text.Trim() == string.Empty) { flag = false; } if (flag == false) { Message.IsSuccess = false; Message.Text = "Please enter/select all mendatory fields..."; Message.Show = true; } return(flag); }
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; } }
protected bool ComplainValidation() { bool flag = false; foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { flag = true; } } if (ddlTimeHH.SelectedIndex == 0) { Message.IsSuccess = false; Message.Text = "Please select In Time HH"; Message.Show = true; return(false); } else if (ddlTimeMM.SelectedIndex == 0) { Message.IsSuccess = false; Message.Text = "Please select In Time MM"; Message.Show = true; return(false); } foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString()); Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); /* Checking whether any one docket exists or not*/ if (bool.Parse(((objServiceBook.Service_CheckIfAnyOpenDocket(CustomerPurchaseId).Rows[0]["Flag"].ToString()) == "1") ? "True" : "False")) { Message.IsSuccess = false; Message.Text = "Already a Docket is in queue. You can not docket more than one."; Message.Show = true; return(false); } } } if (txtProblem.Text.Trim() != string.Empty)// && txtCurrentMeterReading.Text.Trim() != string.Empty) { flag = true; } else { flag = false; } if (flag == false) { Message.IsSuccess = false; Message.Text = "Please enter/select all mendatory fields..."; Message.Show = true; } return(flag); }
private void Csr_Save(string docketNo) { Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); DataSet ds = objServiceBook.Service_CSR_GetByDocketNo(docketNo); Entity.Service.CsrJson csrJson = new Entity.Service.CsrJson(); Entity.Service.Csr csr = new Entity.Service.Csr(); if (ds != null) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { csrJson.ProductName = ds.Tables[0].Rows[0]["ProductName"].ToString(); csrJson.MachineId = ds.Tables[0].Rows[0]["MachineId"].ToString(); csrJson.DocketNo = ds.Tables[0].Rows[0]["DocketNo"].ToString(); csrJson.CustomerCode = ds.Tables[0].Rows[0]["CustomerCode"].ToString(); csrJson.CustomerName = ds.Tables[0].Rows[0]["CustomerName"].ToString(); csrJson.CustomerAddress = ds.Tables[0].Rows[0]["Address"].ToString(); csrJson.ProductSerialNo = ds.Tables[0].Rows[0]["ProductSerialNo"].ToString(); csrJson.DocketDate = ds.Tables[0].Rows[0]["DocketDate"].ToString(); csrJson.DocketTime = ds.Tables[0].Rows[0]["DocketTime"].ToString(); csrJson.DocketType = ds.Tables[0].Rows[0]["DocketType"].ToString(); csrJson.Problem = ds.Tables[0].Rows[0]["Problem"].ToString(); csrJson.ActionTaken = ds.Tables[0].Rows[0]["ActionTaken"].ToString(); csrJson.Diagnosis = ds.Tables[0].Rows[0]["Diagonosis"].ToString(); csrJson.Signature = ds.Tables[0].Rows[0]["Signature"].ToString(); csrJson.Stamp = ds.Tables[0].Rows[0]["Stamp"].ToString(); /* Checking whether machine is in contract or not*/ Business.Service.Contract objContract = new Business.Service.Contract(); if (objContract.Service_MachineIsInContractCheck(Convert.ToInt32(ds.Tables[0].Rows[0]["CustomerPurchaseId"].ToString()))) { csrJson.IsInContract = true; } else { csrJson.IsInContract = false; } } if (ds.Tables[3] != null && ds.Tables[3].Rows.Count > 0) { csrJson.A3BWMeterReading = ds.Tables[3].Rows[0]["A3BWMeterReading"].ToString(); csrJson.A3CLMeterReading = ds.Tables[3].Rows[0]["A3CLMeterReading"].ToString(); csrJson.A4BWMeterReading = ds.Tables[3].Rows[0]["A4BWMeterReading"].ToString(); csrJson.A4CLMeterReading = ds.Tables[3].Rows[0]["A4CLMeterReading"].ToString(); } if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { List <Entity.Service.CallAttendance> callAttendances = new List <Entity.Service.CallAttendance>(); foreach (DataRow dataRow in ds.Tables[1].Rows) { callAttendances.Add(new Entity.Service.CallAttendance() { EmployeeName = dataRow["EmployeeName"].ToString(), InDate = dataRow["InDate"].ToString(), InTime = dataRow["InTime"].ToString(), OutDate = dataRow["OutDate"].ToString(), OutTime = dataRow["OutTime"].ToString(), ProblemStatus = dataRow["ProblemStatus"].ToString() }); } csrJson.callAttendances = new List <Entity.Service.CallAttendance>(); csrJson.callAttendances = callAttendances; } if (ds.Tables[2] != null && ds.Tables[2].Rows.Count > 0) { List <Entity.Service.SpareUsed> sparesUsed = new List <Entity.Service.SpareUsed>(); foreach (DataRow dataRow in ds.Tables[2].Rows) { sparesUsed.Add(new Entity.Service.SpareUsed() { SpareName = dataRow["SpareName"].ToString() }); } csrJson.sparesUsed = new List <Entity.Service.SpareUsed>(); csrJson.sparesUsed = sparesUsed; } csr.CsrContent = JsonConvert.SerializeObject(csrJson); csr.ServiceBookId = Convert.ToInt64(ds.Tables[0].Rows[0]["ServiceBookId"].ToString()); csr.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name); } objServiceBook.Service_CsrSave(csr); }
private void ContractSave() { Business.Service.Contract objContract = new Business.Service.Contract(); Entity.Service.Contract contract = new Entity.Service.Contract(); contract.CreatedBy = int.Parse(HttpContext.Current.User.Identity.Name); contract.ContractId = 0; contract.CustomerId = CustomerMasterId; contract.ContractTypeId = int.Parse(ddlContractType.SelectedValue); contract.ContractStartDate = (!String.IsNullOrEmpty(txtContractStartDate.Text.Trim())) ? Convert.ToDateTime(txtContractStartDate.Text.Trim()) : DateTime.MinValue; contract.ContractEndDate = (!String.IsNullOrEmpty(txtContractEndDate.Text.Trim())) ? Convert.ToDateTime(txtContractEndDate.Text.Trim()) : DateTime.MinValue; using (DataTable dtContractDetails = new DataTable()) { dtContractDetails.Columns.Add("CustomerPurchaseId"); dtContractDetails.Columns.Add("A3BWStartMeter"); dtContractDetails.Columns.Add("A4BWStartMeter"); dtContractDetails.Columns.Add("A3CLStartMeter"); dtContractDetails.Columns.Add("A4CLStartMeter"); dtContractDetails.Columns.Add("A3BWPages"); dtContractDetails.Columns.Add("A4BWPages"); dtContractDetails.Columns.Add("A3CLPages"); dtContractDetails.Columns.Add("A4CLPages"); dtContractDetails.Columns.Add("A3BWRate"); dtContractDetails.Columns.Add("A4BWRate"); dtContractDetails.Columns.Add("A3CLRate"); dtContractDetails.Columns.Add("A4CLRate"); foreach (GridViewRow gvr in gvCustomerPurchaseListForContract.Rows) { if (((CheckBox)gvr.FindControl("chkSelect")).Checked) { dtContractDetails.Rows.Add(); dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["CustomerPurchaseId"] = gvCustomerPurchaseListForContract.DataKeys[gvr.RowIndex].Values[0].ToString(); dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3BWStartMeter"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3BWStartMeter")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3BWStartMeter")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4BWStartMeter"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4BWStartMeter")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4BWStartMeter")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3CLStartMeter"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3CLStartMeter")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3CLStartMeter")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4CLStartMeter"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4CLStartMeter")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4CLStartMeter")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3BWPages"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3BWPage")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3BWPage")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4BWPages"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4BWPage")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4BWPage")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3CLPages"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3CLPage")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3CLPage")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4CLPages"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4CLPage")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4CLPage")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3BWRate"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3BWRate")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3BWRate")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4BWRate"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4BWRate")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4BWRate")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3CLRate"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA3CLRate")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA3CLRate")).Text.Trim() : ""; dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4CLRate"] = (!String.IsNullOrEmpty(((TextBox)gvr.FindControl("txtA4CLRate")).Text.Trim())) ? ((TextBox)gvr.FindControl("txtA4CLRate")).Text.Trim() : ""; dtContractDetails.AcceptChanges(); //updating last meter reading in Customer Purchase Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook(); serviceBook.CustomerPurchaseId = Convert.ToInt32(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["CustomerPurchaseId"]); serviceBook.A3BWMeterReading = string.IsNullOrEmpty(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3BWStartMeter"].ToString()) ? 0 : Convert.ToInt32(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3BWStartMeter"]); serviceBook.A4BWMeterReading = string.IsNullOrEmpty(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4BWStartMeter"].ToString()) ? 0 : Convert.ToInt32(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4BWStartMeter"]); serviceBook.A3CLMeterReading = string.IsNullOrEmpty(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3CLStartMeter"].ToString()) ? 0 : Convert.ToInt32(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A3CLStartMeter"]); serviceBook.A4CLMeterReading = string.IsNullOrEmpty(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4CLStartMeter"].ToString()) ? 0 : Convert.ToInt32(dtContractDetails.Rows[dtContractDetails.Rows.Count - 1]["A4CLStartMeter"]); int response = 0; response = objServiceBook.Service_MeterReading_Update(serviceBook); if (response == 0) { Message1.IsSuccess = false; Message1.Text = "Current meter reading unable to update! Please add new entry or contact admin."; Message1.Show = true; ModalPopupExtender2.Show(); return; } } } if (dtContractDetails.Rows.Count > 0) { contract.ContractDetails = dtContractDetails; } else { Message1.IsSuccess = false; Message1.Text = "Please select atleast 1 machine."; Message1.Show = true; ModalPopupExtender2.Show(); return; } } int retVal = objContract.Save(contract); if (retVal > 0) { LoadContractList(); ClearControlForContract(); Message1.IsSuccess = true; Message1.Text = "Data saved."; Message1.Show = true; ModalPopupExtender2.Show(); } else { Message1.IsSuccess = false; Message1.Text = "Data not saved"; Message1.Show = true; ModalPopupExtender2.Show(); } }
protected bool ComplainValidation() { bool retValue = false; bool isTonerSelected = false; if (gvTonner.Rows.Count > 0) { foreach (GridViewRow toner in gvTonner.Rows) { CheckBox chkToner = (CheckBox)toner.FindControl("chk1"); if (chkToner.Checked) { isTonerSelected = true; break; } } } if (!isTonerSelected) { Message.Text = "Please select toner"; Message.Show = true; return(false); } foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { retValue = true; } } foreach (GridViewRow gvr in gvPurchase.Rows) { if (((CheckBox)gvr.FindControl("chk")).Checked) { CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString()); Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook(); /* Checking whether any one open tonner request exists or not*/ if (bool.Parse(((objServiceBook.Service_CheckIfAnyOpenTonnerRequest(CustomerPurchaseId).Rows[0]["Flag"].ToString()) == "1") ? "True" : "False")) { Message.IsSuccess = false; Message.Text = "A toner Request is under approval. You can not request more than one."; Message.Show = true; return(false); } /* Checking whether machine is in contract or not*/ //Business.Service.Contract objContract = new Business.Service.Contract(); //DataTable dt = new DataTable(); //dt = objContract.Service_MachineIsInContractCheck(CustomerPurchaseId); //if (dt != null) //{ // if (dt.Rows.Count > 0) // { // if (bool.Parse((dt.Rows[0]["Flag"].ToString() == "1") ? "True" : "False")) //True for Out of Contract // { // Message.IsSuccess = false; // Message.Text = "Out of contract! Please call customer help desk."; // Message.Show = true; // return false; // } // } //} } } if (txtA3BWMeterReading.Text.Trim() == string.Empty && txtA3CLMeterReading.Text.Trim() == string.Empty && txtA4BWMeterReading.Text.Trim() == string.Empty && txtA4CLMeterReading.Text.Trim() == string.Empty) { retValue = false; Message.Text = "Please enter atleast one current meter reading."; } if (!string.IsNullOrEmpty(txtA3BWMeterReading.Text.Trim()) && Convert.ToInt64(lblA3BWLastMeterReading.Text.Trim()) > Convert.ToInt64(txtA3BWMeterReading.Text.Trim())) { retValue = false; Message.Text = "A3 B/W current meter readings cannot less than last meter readings."; } if (!string.IsNullOrEmpty(txtA4BWMeterReading.Text.Trim()) && Convert.ToInt64(lblA4BWLastMeterReading.Text.Trim()) > Convert.ToInt64(txtA4BWMeterReading.Text.Trim())) { retValue = false; Message.Text = "A4 B/W current meter readings cannot less than last meter readings."; } if (!string.IsNullOrEmpty(txtA3CLMeterReading.Text.Trim()) && Convert.ToInt64(lblA3ClLastMeterReading.Text.Trim()) > Convert.ToInt64(txtA3CLMeterReading.Text.Trim())) { retValue = false; Message.Text = "A3 CL current meter readings cannot less than last meter readings."; } if (!string.IsNullOrEmpty(txtA4CLMeterReading.Text.Trim()) && Convert.ToInt64(lblA4ClLastMeterReading.Text.Trim()) > Convert.ToInt64(txtA4CLMeterReading.Text.Trim())) { retValue = false; Message.Text = "A4 CL current meter readings cannot less than last meter readings."; } if (retValue == false) { Message.IsSuccess = false; Message.Show = true; } return(retValue); }