public List <CompanyBusinessSpecialityModel> SaveCompanyBusinessSpeciality(CompanyBusinessSpecialityModel model) { List <CompanyBusinessSpecialityModel> companyBusinessSpecialityList = new List <CompanyBusinessSpecialityModel>(); try { _sqlConnService.OpenConnection(); SqlCommand cmd = new SqlCommand("SP_SaveCompanyBusinessSpeciality", _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(); if (a > 0) { companyBusinessSpecialityList = GetAllCompanyBusinessSpecialityList(model); } } catch (Exception ex) { IErrorLogService errorLog = new ErrorLogService(); string message = ex.InnerException != null ? ex.InnerException.InnerException.Message : ex.Message; errorLog.SetErrorLog(model.CurrentUserID, "CompanyBusinessSpeciality", message); throw new Exception(ex.Message); } return(companyBusinessSpecialityList); }
public HttpResponseMessage Delete(CompanyBusinessSpecialityModel model) { try { if (this.ModelState.IsValid) { var companyBusinessSpecialityList = _companyBusinessSpecialityService.DeleteCompanyBusinessSpeciality(model); if (companyBusinessSpecialityList != null) { return(Request.CreateResponse(HttpStatusCode.OK, companyBusinessSpecialityList)); } 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 HttpResponseMessage GetBusinessSpecialityModels(CompanyBusinessSpecialityModel model) { try { if (this.ModelState.IsValid) { var companyBusinessSpecialityList = _companyBusinessSpecialityService.GetAllCompanyBusinessSpecialityList(model); if (companyBusinessSpecialityList != null) { return(Request.CreateResponse(HttpStatusCode.OK, companyBusinessSpecialityList)); } else { string message = "Error in getting Data"; return(Request.CreateErrorResponse(HttpStatusCode.Forbidden, message)); } } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.InnerException.Message)); } }
public List <CompanyBusinessSpecialityModel> GetAllCompanyBusinessSpecialityList(CompanyBusinessSpecialityModel model) { List <CompanyBusinessSpecialityModel> companyBusinessSpecialityList = new List <CompanyBusinessSpecialityModel>(); CompanyBusinessSpecialityModel companyBusinessSpecialityModel; try { _sqlConnService.OpenConnection(); SqlCommand command = new SqlCommand("SP_GetAllCompanyBusinessSpeciality", _sqlConnService.CreateConnection()); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CultureId", model.CurrentCulture); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { companyBusinessSpecialityModel = new CompanyBusinessSpecialityModel(); companyBusinessSpecialityModel.ID = Guid.Parse(reader["ID"].ToString()); companyBusinessSpecialityModel.Code = reader["Code"].ToString(); companyBusinessSpecialityModel.Name = reader["Name"].ToString(); companyBusinessSpecialityModel.IsActive = Convert.ToBoolean(reader["IsActive"].ToString()); companyBusinessSpecialityModel.CreatedDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); companyBusinessSpecialityModel.CreatedBy = Convert.ToInt32(reader["CreatedBy"].ToString()); companyBusinessSpecialityModel.UpdatedDate = Convert.ToDateTime(reader["UpdatedDate"].ToString()); companyBusinessSpecialityModel.UpdatedBy = Convert.ToInt32(reader["UpdatedBy"].ToString()); companyBusinessSpecialityModel.CurrentUserID = model.CurrentUserID; companyBusinessSpecialityModel.CurrentCulture = model.CurrentCulture; companyBusinessSpecialityList.Add(companyBusinessSpecialityModel); } _sqlConnService.CloseConnection(); } catch (Exception ex) { IErrorLogService errorLog = new ErrorLogService(); string message = ex.InnerException != null ? ex.InnerException.InnerException.Message : ex.Message; errorLog.SetErrorLog(model.CurrentUserID, "CompanyBusinessSpeciality", message); throw new Exception(ex.Message); } return(companyBusinessSpecialityList); }