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