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);
}
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;
}
}
