protected void LoadContractExpiringList(int pageIndex, int pageSize)
{
Entity.Service.Contract contract = new Entity.Service.Contract();
Business.Service.Contract objContract = new Business.Service.Contract();
contract.PageIndex = pageIndex;
contract.PageSize = pageSize;
contract.MachineId = "";
contract.FromDate = DateTime.MinValue;
contract.ToDate = DateTime.MinValue;
if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL))
{
contract.AssignEngineer = 0;
}
else
{
contract.AssignEngineer = int.Parse(HttpContext.Current.User.Identity.Name);
}
DataSet ds = objContract.Service_ContractExpiringList(contract);
Business.Common.Context.ContractExpiringList = ds;
gvExpiringSoonAsync.DataSource = ds.Tables[0];
gvExpiringSoonAsync.VirtualItemCount = (ds.Tables[1].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[1].Rows[0]["TotalCount"].ToString()) : 10;
gvExpiringSoonAsync.DataBind();
}
protected bool ComplainValidation()
{
bool flag = 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 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);
}
/* Checking whether machine is in contract or not*/
Business.Service.Contract objContract = new Business.Service.Contract();
if (!objContract.Service_MachineIsInContractCheck(CustomerPurchaseId))
{
Message.IsSuccess = false;
Message.Text = "Out of Contract! Please call Customer Help Desk.";
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);
}
protected void LoadGetAllContractStatus()
{
Entity.Service.Contract contract = new Entity.Service.Contract();
Business.Service.Contract objContract = new Business.Service.Contract();
contract.MachineId = txtMachineId.Text.Trim();
contract.FromDate = (txtFromContractDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtFromContractDate.Text.Trim());
contract.ToDate = (txtToContractDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtToContractDate.Text.Trim());
contract.ProductSerialNo = txtProductSerialNo.Text.Trim();
if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL))
{
contract.AssignEngineer = 0;
}
else
{
contract.AssignEngineer = int.Parse(HttpContext.Current.User.Identity.Name);
}
DataSet ds = objContract.Service_GetAllContractStatus(contract);
DataTable dtExport = new DataTable();
if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.None).ToString())
{
dtExport = null;
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.Expiring).ToString())
{
dtExport = ds.Tables[0];
string csv = dtExport.ExportCSV();
DownloadCsv(csv);
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.Expired).ToString())
{
dtExport = ds.Tables[1];
string csv = dtExport.ExportCSV();
DownloadCsv(csv);
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.InContract).ToString())
{
dtExport = ds.Tables[2];
string csv = dtExport.ExportCSV();
DownloadCsv(csv);
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.NeverContracted).ToString())
{
dtExport = ds.Tables[3];
string csv = dtExport.ExportCSV();
DownloadCsv(csv);
}
else
{
dtExport = null;
}
}
protected void LoadContractStatusList(int pageIndex, int pageSize)
{
Entity.Service.Contract contract = new Entity.Service.Contract();
Business.Service.Contract objContract = new Business.Service.Contract();
contract.PageIndex = pageIndex;
contract.PageSize = pageSize;
contract.MachineId = txtMachineId.Text.Trim();
contract.FromDate = (txtFromContractDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtFromContractDate.Text.Trim());
contract.ToDate = (txtToContractDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtToContractDate.Text.Trim());
contract.ProductSerialNo = txtProductSerialNo.Text.Trim();
if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL))
{
contract.AssignEngineer = 0;
}
else
{
contract.AssignEngineer = int.Parse(HttpContext.Current.User.Identity.Name);
}
DataSet ds = objContract.Service_ContractStatusList(contract);
if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.None).ToString())
{
gvContractStatusList.DataSource = null;
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.Expiring).ToString())
{
gvContractStatusList.DataSource = ds.Tables[0];
gvContractStatusList.VirtualItemCount = (ds.Tables[4].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[4].Rows[0]["TotalCount"].ToString()) : 15;
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.Expired).ToString())
{
gvContractStatusList.DataSource = ds.Tables[1];
gvContractStatusList.VirtualItemCount = (ds.Tables[5].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[5].Rows[0]["TotalCount"].ToString()) : 15;
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.InContract).ToString())
{
gvContractStatusList.DataSource = ds.Tables[2];
gvContractStatusList.VirtualItemCount = (ds.Tables[6].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[6].Rows[0]["TotalCount"].ToString()) : 15;
}
else if (ddlContractStatus.SelectedValue == ((int)ContractStatusType.NeverContracted).ToString())
{
gvContractStatusList.DataSource = ds.Tables[3];
gvContractStatusList.VirtualItemCount = (ds.Tables[7].Rows.Count > 0) ? Convert.ToInt32(ds.Tables[7].Rows[0]["TotalCount"].ToString()) : 15;
}
else
{
gvContractStatusList.DataSource = null;
}
gvContractStatusList.DataBind();
}
private void LoadContractList()
{
Business.Service.Contract objContract = new Business.Service.Contract();
DataTable dt = objContract.GetAll(CustomerMasterId);
if (dt.Rows.Count > 0)
{
gvContractList.DataSource = dt;
}
else
{
gvContractList.DataSource = null;
}
gvContractList.DataBind();
}
protected void LoadPieChart()
{
Business.Service.Contract objContract = new Business.Service.Contract();
int assignEngineer = 0;
if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL))
{
assignEngineer = 0;
}
else
{
assignEngineer = int.Parse(HttpContext.Current.User.Identity.Name);
}
DataTable dt = objContract.Services_ContractStatus(assignEngineer);
ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "script", "PieData(" + dt.Rows[0]["ExperingSoon"].ToString() + "," + dt.Rows[0]["Expired"].ToString() + "," + dt.Rows[0]["InContract"].ToString() + "," + dt.Rows[0]["NeverContracted"].ToString() + ")", true);
}
protected void gvContractList_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
ClearControlForContract();
if (e.CommandName == "View")
{
//CustomerMasterId = int.Parse(e.CommandArgument.ToString());
LoadContractDetail(int.Parse(e.CommandArgument.ToString()));
}
else if (e.CommandName == "Del")
{
Business.Service.Contract objContract = new Business.Service.Contract();
int i = objContract.Delete(int.Parse(e.CommandArgument.ToString()));
if (i > 0)
{
//LoadCustomerPurchaseList();
LoadContractList();
ClearControlForContract();
Message1.IsSuccess = true;
Message1.Text = "Data deleted.";
}
else
{
Message1.IsSuccess = false;
Message1.Text = "Data not deleted.";
}
Message1.Show = true;
}
ModalPopupExtender2.Show();
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
private void LoadContractDetail(int contractId)
{
Business.Service.Contract objContract = new Business.Service.Contract();
DataSet ds = objContract.GetById(contractId);
if (ds != null)
{
ddlContractType.SelectedValue = ds.Tables[0].Rows[0]["ContractType"].ToString();
txtContractStartDate.Text = (ds.Tables[0].Rows[0]["ContractStartDate"] != DBNull.Value) ? Convert.ToDateTime(ds.Tables[0].Rows[0]["ContractStartDate"].ToString()).ToString("dd/MMM/yyyy") : "";
txtContractEndDate.Text = (ds.Tables[0].Rows[0]["ContractEndDate"] != DBNull.Value) ? Convert.ToDateTime(ds.Tables[0].Rows[0]["ContractEndDate"].ToString()).ToString("dd/MMM/yyyy") : "";
foreach (GridViewRow gvr in gvCustomerPurchaseListForContract.Rows)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
if (gvCustomerPurchaseListForContract.DataKeys[gvr.RowIndex].Values[0].ToString() == dr["CustomerPurchaseId"].ToString())
{
((CheckBox)gvr.FindControl("chkSelect")).Checked = true;
((TextBox)gvr.FindControl("txtA3BWStartMeter")).Text = (dr["A3BWStartMeter"] != DBNull.Value) ? dr["A3BWStartMeter"].ToString() : "";
((TextBox)gvr.FindControl("txtA4BWStartMeter")).Text = (dr["A4BWStartMeter"] != DBNull.Value) ? dr["A4BWStartMeter"].ToString() : "";
((TextBox)gvr.FindControl("txtA3CLStartMeter")).Text = (dr["A3CLStartMeter"] != DBNull.Value) ? dr["A3CLStartMeter"].ToString() : "";
((TextBox)gvr.FindControl("txtA4CLStartMeter")).Text = (dr["A4CLStartMeter"] != DBNull.Value) ? dr["A4CLStartMeter"].ToString() : "";
((TextBox)gvr.FindControl("txtA3BWPage")).Text = (dr["A3BWPages"] != DBNull.Value) ? dr["A3BWPages"].ToString() : "";
((TextBox)gvr.FindControl("txtA4BWPage")).Text = (dr["A4BWPages"] != DBNull.Value) ? dr["A4BWPages"].ToString() : "";
((TextBox)gvr.FindControl("txtA3CLPage")).Text = (dr["A3CLPages"] != DBNull.Value) ? dr["A3CLPages"].ToString() : "";
((TextBox)gvr.FindControl("txtA4CLPage")).Text = (dr["A4CLPages"] != DBNull.Value) ? dr["A4CLPages"].ToString() : "";
((TextBox)gvr.FindControl("txtA3BWRate")).Text = (dr["A3BWRate"] != DBNull.Value) ? dr["A3BWRate"].ToString() : "";
((TextBox)gvr.FindControl("txtA4BWRate")).Text = (dr["A4BWRate"] != DBNull.Value) ? dr["A4BWRate"].ToString() : "";
((TextBox)gvr.FindControl("txtA3CLRate")).Text = (dr["A3CLRate"] != DBNull.Value) ? dr["A3CLRate"].ToString() : "";
((TextBox)gvr.FindControl("txtA4CLRate")).Text = (dr["A4CLRate"] != DBNull.Value) ? dr["A4CLRate"].ToString() : "";
}
}
}
TabContainer2.ActiveTabIndex = 0;
}
}
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();
}
}
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);
}
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 void btnSubmit_Click(object sender, EventArgs e)
{
if (ComplainValidation())
{
Business.Service.Docket objDocket = new Business.Service.Docket();
Entity.Service.Docket docket = new Entity.Service.Docket();
foreach (GridViewRow gvr in gvPurchase.Rows)
{
if (((CheckBox)gvr.FindControl("chk")).Checked)
{
docket.CustomerPurchaseId = int.Parse(gvPurchase.DataKeys[gvr.RowIndex].Values[0].ToString());
}
}
docket.CustomerId = CustomerMasterId;
docket.DocketNo = "";
docket.DocketDateTime = Convert.ToDateTime(txtDocketDate.Text.Trim() + " " + ddlTimeHH.SelectedValue + ":" + ddlTimeMM.SelectedValue + ":00" + " " + ddlTimeTT.SelectedValue);
docket.isCustomerEntry = false;
docket.CallStatusId = 1;
docket.Problem = txtProblem.Text.Trim();
docket.DocketType = ddlDocketType.SelectedValue;
docket.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
if (docket.CustomerPurchaseId == 0)
{
Message.IsSuccess = false;
Message.Text = "Sorry! we can not receive your docket. Please refresh this page and try again..";
return;
}
DataTable dt = objDocket.Service_Docket_Save(docket);
if (dt != null && dt.Rows.Count > 0)
{
LoadDocket();
LoadCustomerPurchaseList();
txtProblem.Text = "";
txtDocketDate.Text = DateTime.Now.ToString("dd MMM yyyy");
/* Checking whether machine is in contract or not*/
Business.Service.Contract objContract = new Business.Service.Contract();
if (!objContract.Service_MachineIsInContractCheck(CustomerPurchaseId))
{
Message.IsSuccess = true;
Message.Text = "Docket received. Machine is out of contract!";
}
else
{
//updating last meter reading in Customer Purchase
//Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook();
//int i = objServiceBook.Service_MeterReading_Update(CustomerPurchaseId, int.Parse(txtCurrentMeterReading.Text.Trim()));
//if (i > 0)
//{
Message.IsSuccess = true;
Message.Text = "Docket received. Your Docket No : " + dt.Rows[0]["DocketNo"].ToString();
//}
//else
//{
// Message.IsSuccess = false;
// Message.Text = "Current meter reading unable to update! Please contact system administrator immediately.";
//}
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Sorry! we can not receive your docket. Please refresh this page and try again.";
}
Message.Show = true;
}
}
