public static DataTable Service_Docket_Save(Entity.Service.Docket docket)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_Service_Docket_Save";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DocketId", docket.DocketId);
cmd.Parameters.AddWithValue("@CustomerPurchaseId", docket.CustomerPurchaseId);
cmd.Parameters.AddWithValue("@DocketDateTime", docket.DocketDateTime);
cmd.Parameters.AddWithValue("@DocketType", docket.DocketType);
cmd.Parameters.AddWithValue("@Problem", docket.Problem);
cmd.Parameters.AddWithValue("@IsCustomerEntry", docket.isCustomerEntry);
cmd.Parameters.AddWithValue("@CallStatusId", docket.CallStatusId);
cmd.Parameters.AddWithValue("@CreatedBy", docket.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
protected void LoadDocket()
{
Business.Service.Docket objDocket = new Business.Service.Docket();
Entity.Service.Docket docket = new Entity.Service.Docket();
docket.DocketNo = txtDocketNo.Text.Trim();
docket.CustomerName = txtCustomerName.Text.Trim();
docket.ProductId = int.Parse(ddlProduct.SelectedValue);
docket.DocketFromDateTime = (txtFromDocketDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtFromDocketDate.Text);
docket.DocketToDateTime = (txtToDocketDate.Text == "") ? DateTime.MinValue : Convert.ToDateTime(txtToDocketDate.Text);
docket.CallStatusId = int.Parse(ddlCallStatus.SelectedValue);
docket.DocketType = ddlDocketType.SelectedValue;
if (HttpContext.Current.User.IsInRole(Entity.HR.Utility.CUSTOMER_LIST_SHOW_ALL))
{
docket.AssignEngineer = 0;
}
else
{
docket.AssignEngineer = int.Parse(HttpContext.Current.User.Identity.Name);
}
DataTable dt = objDocket.Service_Docket_GetAll(docket);
if (dt != null)
{
gvDocket.DataSource = dt;
gvDocket.DataBind();
}
}
public static DataTable Service_Docket_GetAllByCallStatusIds(Entity.Service.Docket docket)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.AddWithValue("@CallStatusId", docket.CallStatusIds);
if (docket.AssignEngineer == 0)
{
cmd.Parameters.AddWithValue("@AssignEngineer", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@AssignEngineer", docket.AssignEngineer);
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Service_Docket_GetAllByCallStatusIds";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
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 = int.Parse(HttpContext.Current.User.Identity.Name.Split('|')[(int)Constants.Customer.ID]);
docket.DocketNo = "";
docket.DocketDateTime = System.DateTime.Now;
docket.isCustomerEntry = true;
docket.CallStatusId = 1;
docket.DocketType = "CM";
docket.Problem = txtProblem.Text.Trim();
docket.CreatedBy = Convert.ToInt32(HttpContext.Current.User.Identity.Name.Split('|')[(int)Constants.Customer.ID]);
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 = "";
Message.IsSuccess = true;
Message.Text = "Docket received. Your Docket No : " + dt.Rows[0]["DocketNo"].ToString();
}
else
{
Message.IsSuccess = false;
Message.Text = "Sorry! we can not receive your docket. Please refresh this page and try again.";
}
Message.Show = true;
}
}
protected void LoadDocket()
{
Business.Service.Docket objDocket = new Business.Service.Docket();
Entity.Service.Docket docket = new Entity.Service.Docket();
docket.CustomerId = int.Parse(HttpContext.Current.User.Identity.Name.Split('|')[(int)Constants.Customer.ID]);
DataTable dt = objDocket.Service_Docket_GetAll(docket);
if (dt != null && dt.Rows.Count > 0)
{
gvDocket.DataSource = dt.AsEnumerable().Take(5).CopyToDataTable();
}
else
{
gvDocket.DataSource = null;
}
gvDocket.DataBind();
}
private void CreateDocket()
{
Business.Service.Docket objDocket = new Business.Service.Docket();
Entity.Service.Docket docket = new Entity.Service.Docket()
{
CustomerPurchaseId = CustomerPurchaseId,
CustomerId = CustomerMasterId,
DocketNo = "",
DocketDateTime = DateTime.Now,
isCustomerEntry = false,
CallStatusId = 1,
Problem = string.Format("PM CALL GENERATED FOR AMCV {0}", AmcvId),
DocketType = "PM",
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..";
Message.Show = true;
return;
}
DataTable dt = objDocket.Service_Docket_Save(docket);
if (dt != null && dt.Rows.Count > 0)
{
Message.IsSuccess = true;
Message.Text = "Docket received. Your Docket No : " + dt.Rows[0]["DocketNo"].ToString();
}
else
{
Message.IsSuccess = false;
Message.Text = "Sorry! we can not receive your docket. Please refresh this page and try again.";
}
Message.Show = true;
}
public static Entity.Service.Docket Service_Docket_GetByDocketId(int docketid)
{
Entity.Service.Docket docket = new Entity.Service.Docket();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Parameters.AddWithValue("@DocketId", docketid);
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Service_Docket_GetByDocketId";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr.HasRows)
{
docket.DocketId = docketid;
docket.DocketNo = dr["DocketNo"].ToString();
docket.CustomerId = (dr["CustomerId_FK"] == DBNull.Value) ? 0 : int.Parse(dr["CustomerId_FK"].ToString());
docket.ProductId = int.Parse(dr["ProductId_FK"].ToString());
docket.DocketDateTime = Convert.ToDateTime(dr["DocketDateTime"].ToString());
docket.Problem = dr["Problem"].ToString();
docket.isCustomerEntry = bool.Parse(dr["IsCustomerEntry"].ToString());
docket.CallStatusId = (dr["CallStatusId"] == DBNull.Value) ? 0 : int.Parse(dr["CallStatusId"].ToString());
}
}
con.Close();
}
}
return(docket);
}
public static DataTable Service_Docket_GetAll(Entity.Service.Docket docket)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
if (docket.DocketId == 0)
{
cmd.Parameters.AddWithValue("@DocketId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DocketId", docket.DocketId);
}
if (docket.DocketNo == "")
{
cmd.Parameters.AddWithValue("@DocketNo", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DocketNo", docket.DocketNo);
}
if (string.IsNullOrEmpty(docket.CustomerName))
{
cmd.Parameters.AddWithValue("@CustomerName", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CustomerName", docket.CustomerName);
}
if (docket.ProductId == 0)
{
cmd.Parameters.AddWithValue("@ProductId_FK", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ProductId_FK", docket.ProductId);
}
if (docket.DocketFromDateTime == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@DocketFromDateTime", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DocketFromDateTime", docket.DocketFromDateTime);
}
if (docket.DocketToDateTime == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@DocketToDateTime", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DocketToDateTime", docket.DocketToDateTime);
}
if (docket.CallStatusId == 0)
{
cmd.Parameters.AddWithValue("@CallStatusId", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@CallStatusId", docket.CallStatusId);
}
if (docket.DocketType == "")
{
cmd.Parameters.AddWithValue("@DocketType", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@DocketType", docket.DocketType);
}
if (docket.AssignEngineer == 0)
{
cmd.Parameters.AddWithValue("@AssignEngineer", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@AssignEngineer", docket.AssignEngineer);
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_Service_Docket_GetAll";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
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;
}
}
public DataTable Service_Docket_GetAllByCallStatusIds(Entity.Service.Docket docket)
{
return(DataAccess.Service.Docket.Service_Docket_GetAllByCallStatusIds(docket));
}
public DataTable Service_Docket_GetAll(Entity.Service.Docket docket)
{
return(DataAccess.Service.Docket.Service_Docket_GetAll(docket));
}
