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