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