public HttpResponseMessage CreateBDMAppointmentDetail(BDMAppointmentDetailInsertDTO objAppointmentDetail) { HttpResponseMessage message; try { // // BDMAppointmentDetailDAL dal = new BDMAppointmentDetailDAL(); var dynObj = new { result = _obj.InsertBDMAppointmentDetail(objAppointmentDetail) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" }); ErrorLog.CreateErrorMessage(ex, "BDMAppoinmentDetail", "CreateBDMAppointmentDetail"); } return(message); }
public bool InsertBDMAppointmentDetail(BDMAppointmentDetailInsertDTO objAppointmentDetail) { bool res = false; BDMAppointmentGetIdDTO bdm = new BDMAppointmentGetIdDTO(); SqlCommand SqlCmd = new SqlCommand("spInsertBDMAppoinmentDetail"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@EmployeeId", objAppointmentDetail.EmployeeId); SqlCmd.Parameters.AddWithValue("@ClientName", objAppointmentDetail.ClientName); SqlCmd.Parameters.AddWithValue("@ClientAddress", objAppointmentDetail.ClientAddress); SqlCmd.Parameters.AddWithValue("@ClientContactNo", objAppointmentDetail.ClientContactNo); SqlCmd.Parameters.AddWithValue("@ContactPerson", objAppointmentDetail.ContactPerson); SqlCmd.Parameters.AddWithValue("@Designation", objAppointmentDetail.Designation); SqlCmd.Parameters.AddWithValue("@Mobile", objAppointmentDetail.Mobile); SqlCmd.Parameters.AddWithValue("@Email", objAppointmentDetail.Email); SqlCmd.Parameters.AddWithValue("@ReferBy", (objAppointmentDetail.ReferBy == null) ? "" : objAppointmentDetail.ReferBy); SqlCmd.Parameters.AddWithValue("@State", objAppointmentDetail.State); SqlCmd.Parameters.AddWithValue("@City", objAppointmentDetail.City); SqlCmd.Parameters.AddWithValue("@ExistCompetitors", objAppointmentDetail.ExistCompetitors); SqlCmd.Parameters.AddWithValue("@CreatedBy", objAppointmentDetail.CreatedBy); bdm = _unitOfWork.DbLayer.GetEntityList <BDMAppointmentGetIdDTO>(SqlCmd).FirstOrDefault(); if (bdm != null) { SqlCommand sqlCmd1 = new SqlCommand("spInsertRequirementDetails"); sqlCmd1.CommandType = CommandType.StoredProcedure; sqlCmd1.Parameters.AddWithValue("@ClientId", bdm.ClientId); sqlCmd1.Parameters.AddWithValue("@CreatedBy", objAppointmentDetail.CreatedBy); sqlCmd1.Parameters.Add(new SqlParameter("@Designation", SqlDbType.Int)); sqlCmd1.Parameters.Add(new SqlParameter("@Service", SqlDbType.Int)); sqlCmd1.Parameters.Add(new SqlParameter("@RatePerEmployee", SqlDbType.Int)); sqlCmd1.Parameters.Add(new SqlParameter("@EmployeeCount", SqlDbType.Int)); foreach (var requirement in objAppointmentDetail.RequirementDetail) { if (sqlCmd1.Connection != null) { if (sqlCmd1.Connection.State == ConnectionState.Closed) { sqlCmd1.Connection.Open(); } } sqlCmd1.Parameters["@Designation"].Value = requirement.Designation; sqlCmd1.Parameters["@Service"].Value = requirement.Service; sqlCmd1.Parameters["@RatePerEmployee"].Value = requirement.RatePerEmployee; sqlCmd1.Parameters["@EmployeeCount"].Value = requirement.EmployeeCount; int queryRes = _unitOfWork.DbLayer.ExecuteNonQuery(sqlCmd1); if (queryRes != Int32.MaxValue) { res = true; } else { // this part needed error handling code. res = false; } } if (objAppointmentDetail.ExistCompetitors) { SqlCommand sqlCmd2 = new SqlCommand("spInsertCompetitors"); sqlCmd2.CommandType = CommandType.StoredProcedure; sqlCmd2.Parameters.AddWithValue("@ClientId", bdm.ClientId); sqlCmd2.Parameters.AddWithValue("@CreatedBy", objAppointmentDetail.CreatedBy); sqlCmd2.Parameters.Add(new SqlParameter("@Name", SqlDbType.VarChar)); sqlCmd2.Parameters.Add(new SqlParameter("@Designation", SqlDbType.VarChar)); sqlCmd2.Parameters.Add(new SqlParameter("@Service", SqlDbType.VarChar)); sqlCmd2.Parameters.Add(new SqlParameter("@RatePerEmployee", SqlDbType.Int)); sqlCmd2.Parameters.Add(new SqlParameter("@EmployeeCount", SqlDbType.Int)); foreach (var competitor in objAppointmentDetail.Competitor) { if (sqlCmd2.Connection != null) { if (sqlCmd2.Connection.State == ConnectionState.Closed) { sqlCmd2.Connection.Open(); } } sqlCmd2.Parameters["@Name"].Value = competitor.Name; sqlCmd2.Parameters["@Designation"].Value = competitor.Designation; sqlCmd2.Parameters["@Service"].Value = competitor.Service; sqlCmd2.Parameters["@RatePerEmployee"].Value = competitor.RatePerEmployee; sqlCmd2.Parameters["@EmployeeCount"].Value = competitor.EmployeeCount; int queryRes = _unitOfWork.DbLayer.ExecuteNonQuery(sqlCmd2); if (queryRes != Int32.MaxValue) { res = true; } else { // this part needed error handling code. res = false; } } } res = true; } return(res); }