public HttpResponseMessage ChangeLead(ChangeLeadbyClientDTO objChangeLead) { HttpResponseMessage message; try { // ClientLeadChangeDataAccessLayer dal = new ClientLeadChangeDataAccessLayer(); var dynObj = new { result = _clientServices.ChangeLeadByClient(objChangeLead) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" }); ErrorLog.CreateErrorMessage(ex, "ClientLeadChange", "ChangeClientLead"); } return(message); }
public bool ChangeLeadByClient(ChangeLeadbyClientDTO objchangelead) { bool res = false; SqlCommand SqlCmd = new SqlCommand("spMovetoClientbyEmployee"); SqlCmd.CommandType = CommandType.StoredProcedure; if (objchangelead != null) { SqlCmd.Parameters.AddWithValue("@ActionBy", objchangelead.ActionBy); SqlCmd.Parameters.AddWithValue("@ToEmployee", objchangelead.EmployeeId); SqlCmd.Parameters.Add(new SqlParameter("@ClientId", SqlDbType.Int)); foreach (var client in objchangelead.ClientId) { if (SqlCmd.Connection != null) { if (SqlCmd.Connection.State == ConnectionState.Closed) { SqlCmd.Connection.Open(); } } SqlCmd.Parameters["@ClientId"].Value = client; int result = new DbLayer().ExecuteNonQuery(SqlCmd); if (result != Int32.MaxValue) { res = true; } else { res = false; } } } return(res); }