public List <AgentCharactersticsModel> SaveAgentCharacterstics(AgentCharactersticsModel model) { List <AgentCharactersticsModel> agentCharactersticsList = new List <AgentCharactersticsModel>(); try { _sqlConnService.OpenConnection(); SqlCommand cmd = new SqlCommand("SP_SaveAgentCharacterstics", _sqlConnService.CreateConnection()); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", model.ID); cmd.Parameters.AddWithValue("@Code", model.Code); cmd.Parameters.AddWithValue("@Name_" + model.CurrentCulture, model.Name); cmd.Parameters.AddWithValue("@IsActive", model.IsActive); cmd.Parameters.AddWithValue("@CreatedBy", model.CurrentUserID); cmd.Parameters.AddWithValue("@CultureId", model.CurrentCulture); int a = cmd.ExecuteNonQuery(); _sqlConnService.CloseConnection(); } catch (Exception ex) { IErrorLogService errorLog = new ErrorLogService(); string message = ex.InnerException != null ? ex.InnerException.InnerException.Message : ex.Message; errorLog.SetErrorLog(model.CurrentUserID, "AgentCharacterstics", message); throw new Exception(ex.Message); } BaseViewModel md = new BaseViewModel(); md.CurrentUserID = model.CurrentUserID; md.CurrentCulture = model.CurrentCulture; return(GetAllAgentCharactersticsList(md)); }
public HttpResponseMessage Delete(AgentCharactersticsModel model) { try { if (this.ModelState.IsValid) { var companyAgentCharactersticsList = _agentCharactersticsService.DeleteAgentCharacterstics(model); if (companyAgentCharactersticsList != null) { return(Request.CreateResponse(HttpStatusCode.OK, companyAgentCharactersticsList)); } else { string message = "Not deleted successfully"; return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message)); } } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex)); } }
public List <AgentCharactersticsModel> GetAllAgentCharactersticsList(BaseViewModel model) { List <AgentCharactersticsModel> agentCharactersticsList = new List <AgentCharactersticsModel>(); AgentCharactersticsModel agentCharactersticsModel; try { _sqlConnService.OpenConnection(); SqlCommand command = new SqlCommand("SP_GetAllAgentCharacterstics", _sqlConnService.CreateConnection()); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CultureId", model.CurrentCulture); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { agentCharactersticsModel = new AgentCharactersticsModel(); agentCharactersticsModel.ID = Guid.Parse(reader["ID"].ToString()); agentCharactersticsModel.Code = reader["Code"].ToString(); agentCharactersticsModel.Name = reader["Name"].ToString(); agentCharactersticsModel.IsActive = Convert.ToBoolean(reader["IsActive"].ToString()); agentCharactersticsModel.CreatedDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); agentCharactersticsModel.CreatedBy = Convert.ToInt32(reader["CreatedBy"].ToString()); agentCharactersticsModel.UpdatedDate = Convert.ToDateTime(reader["UpdatedDate"].ToString()); agentCharactersticsModel.UpdatedBy = Convert.ToInt32(reader["UpdatedBy"].ToString()); agentCharactersticsModel.CurrentUserID = model.CurrentUserID; agentCharactersticsModel.CurrentCulture = model.CurrentCulture; agentCharactersticsList.Add(agentCharactersticsModel); } _sqlConnService.CloseConnection(); } catch (Exception ex) { IErrorLogService errorLog = new ErrorLogService(); string message = ex.InnerException != null ? ex.InnerException.InnerException.Message : ex.Message; errorLog.SetErrorLog(model.CurrentUserID, "AgentCharacterstics", message); throw new Exception(ex.Message); } return(agentCharactersticsList); }