public HttpResponseMessage MoveCustomer(CustomertoMove objCustomer)
{
HttpResponseMessage message;
try
{
// CustomerDataAccessLayer dal = new CustomerDataAccessLayer();
var dynObj = new { result = _Customer.MoveCustomer(objCustomer) };
message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
ErrorLog.CreateErrorMessage(ex, "Customer", "MoveCustomer");
}
return(message);
}
public bool MoveCustomer(CustomertoMove objCustomer)
{
bool res = false;
CustomerDetailDTO cus = new CustomerDetailDTO();
SqlCommand SqlCmd = new SqlCommand("MoveToCustomer");
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ClientId", (objCustomer.ClientId == 0) ? null : objCustomer.ClientId);
SqlCmd.Parameters.AddWithValue("@CustomerId", (objCustomer.CustomerId == 0) ? null : objCustomer.CustomerId);
SqlCmd.Parameters.AddWithValue("@DateofCommencement", objCustomer.DateOfCommencement);
SqlCmd.Parameters.AddWithValue("@AgreementSigned", objCustomer.AgreementSigned);
SqlCmd.Parameters.AddWithValue("@TypeofContract", objCustomer.TypeofContract);
SqlCmd.Parameters.AddWithValue("@FromDate", objCustomer.FromDate);
SqlCmd.Parameters.AddWithValue("@ToDate", objCustomer.ToDate);
SqlCmd.Parameters.AddWithValue("@ClientType", objCustomer.ClientType);
SqlCmd.Parameters.AddWithValue("@ActionBy", objCustomer.CreatedBy);
cus = _unitOfWork.DbLayer.GetEntityList <CustomerDetailDTO>(SqlCmd).FirstOrDefault();
if (cus != null)
{
SqlCommand sqlCmd1 = new SqlCommand("spInsertCustomerManagementDetail");
sqlCmd1.CommandType = CommandType.StoredProcedure;
sqlCmd1.Parameters.AddWithValue("@CustomerId", cus.Customer);
sqlCmd1.Parameters.AddWithValue("@CreatedBy", objCustomer.CreatedBy);
sqlCmd1.Parameters.Add(new SqlParameter("@Department", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@ContactPersonName", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@ContactNumber", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@Address", SqlDbType.VarChar));
foreach (var detail in objCustomer.ClientDetail)
{
if (sqlCmd1.Connection != null)
{
if (sqlCmd1.Connection.State == ConnectionState.Closed)
{
sqlCmd1.Connection.Open();
}
}
sqlCmd1.Parameters["@Department"].Value = (detail.Department == null) ? null : detail.Department;
sqlCmd1.Parameters["@ContactPersonName"].Value = (detail.ContactPersonName == null) ? null : detail.ContactPersonName;
sqlCmd1.Parameters["@ContactNumber"].Value = (detail.ContactNumber == null) ? null : detail.ContactNumber;
sqlCmd1.Parameters["@Email"].Value = (detail.Email == null) ? null : detail.Email;
sqlCmd1.Parameters["@Address"].Value = (detail.Address == null) ? null : detail.Address;
int queryRes = _unitOfWork.DbLayer.ExecuteNonQuery(sqlCmd1);
if (queryRes != Int32.MaxValue)
{
res = true;
}
else
{
// this part needed error handling code.
res = false;
}
}
}
if (cus.ContractId != null || cus.ContractId != 0)
{
SqlCommand sqlCmd1 = new SqlCommand("spInsertShiftMapping");
sqlCmd1.CommandType = CommandType.StoredProcedure;
sqlCmd1.Parameters.AddWithValue("@ContractId", cus.ContractId);
sqlCmd1.Parameters.AddWithValue("@CreatedBy", objCustomer.CreatedBy);
sqlCmd1.Parameters.Add(new SqlParameter("@ShiftId", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@StartTime", SqlDbType.VarChar));
sqlCmd1.Parameters.Add(new SqlParameter("@EndTime", SqlDbType.VarChar));
foreach (var shift in objCustomer.ShiftMapping)
{
if (sqlCmd1.Connection != null)
{
if (sqlCmd1.Connection.State == ConnectionState.Closed)
{
sqlCmd1.Connection.Open();
}
}
sqlCmd1.Parameters["@ShiftId"].Value = shift.ShiftId;
sqlCmd1.Parameters["@StartTime"].Value = shift.StartTime;
sqlCmd1.Parameters["@EndTime"].Value = shift.EndTime;
int queryRes = _unitOfWork.DbLayer.ExecuteNonQuery(sqlCmd1);
if (queryRes != Int32.MaxValue)
{
res = true;
}
else
{
// this part needed error handling code.
res = false;
}
}
}
return(res);
}
