protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (ValidateCallTransfer())
{
Business.Service.ServiceBook objServiceBook = new Business.Service.ServiceBook();
Entity.Service.ServiceBook serviceBook = new Entity.Service.ServiceBook();
serviceBook.EmployeeId_FK = EmployeeId;
serviceBook.CallId = Business.Common.Context.CallId;
serviceBook.CallType = (int)Business.Common.Context.CallType;
serviceBook.Remarks = txtTransferReason.Text.Trim();
serviceBook.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
int response = objServiceBook.Service_CallTransfer_Save(serviceBook);
if (response > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertUser", "refreshAndClose();", true);
}
else
{
Message.IsSuccess = false;
Message.Text = "Sorry! cannot tranfer call. Please refresh this page and try again..";
}
}
}
catch (Exception ex)
{
Message.IsSuccess = false;
Message.Text = ex.Message;
ex.WriteException();
}
Message.Show = true;
}
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 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();
}
}
