public ResponseEthnicGroup Get() { ResponseEthnicGroup ans = null; try { if (ValidateSecurityAPI()) { ans = EthnicModel.GetAll(); } else { ans = new ResponseEthnicGroup() { IsSuccessful = false, ResponseMessage = AppManagement.MSG_API_Validation_Failure }; } } catch (Exception ex) { ans = new ResponseEthnicGroup() { IsSuccessful = false, ResponseMessage = AppManagement.MSG_GenericExceptionError }; } return(ans); }
public List <EthnicModel> GetAll() { List <EthnicModel> ethnicModels = new List <EthnicModel>(); using (conn = JBCertConnection.Instance) { string queryString = "Select * From [dbo].[tblDantoc] Where [IsDeleted] = 0"; conn.Open(); SqlCommand sqlCommand = new SqlCommand(queryString, conn); sqlCommand.CommandType = CommandType.Text; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); try { while (sqlDataReader.Read()) { EthnicModel ethnicModel = new EthnicModel(); ethnicModel.Id = int.Parse(sqlDataReader["Id"].ToString()); ethnicModel.EthnicName = sqlDataReader["TenDantoc"].ToString(); ethnicModel.Note = sqlDataReader["Ghichu"].ToString(); ethnicModel.IsDeleted = false; ethnicModels.Add(ethnicModel); } } catch (Exception ex) { throw ex; } finally { sqlDataReader.Close(); conn.Close(); } } return(ethnicModels); }