private static T_COM_Master_Location GetItemFromReader(IDataReader dataReader) { T_COM_Master_Location objItem = new T_COM_Master_Location(); objItem.LocationID = SqlHelper.GetInt(dataReader, "LocationID"); objItem.LocationName = SqlHelper.GetString(dataReader, "LocationName"); objItem.LocationShortName = SqlHelper.GetString(dataReader, "LocationShortName"); objItem.Address_EN = SqlHelper.GetString(dataReader, "Address_EN"); objItem.Address_VN = SqlHelper.GetString(dataReader, "Address_VN"); objItem.EntityID = SqlHelper.GetInt(dataReader, "EntityID"); objItem.CreatedBy = SqlHelper.GetInt(dataReader, "CreatedBy"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); objItem.ModifiedBy = SqlHelper.GetInt(dataReader, "ModifiedBy"); objItem.ModifiedDate = SqlHelper.GetDateTime(dataReader, "ModifiedDate"); objItem.IsActive = SqlHelper.GetBoolean(dataReader, "IsActive"); if (SqlHelper.ColumnExists(dataReader, "TotalRecord")) { objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord"); } return(objItem); }
public static T_COM_Master_Location UpdateItem(T_COM_Master_Location model) { int result = 0; using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, CommandType.StoredProcedure, "T_COM_Master_Location_Update", CreateSqlParameter(model))) { while (reader.Read()) { result = (int)reader[0]; } } return(GetItemByID(result)); }
public static T_COM_Master_LocationCollection Search(SearchFilter SearchKey) { T_COM_Master_LocationCollection collection = new T_COM_Master_LocationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Location_Search", SearchFilterManager.SqlSearchParamNoCompany(SearchKey))) { while (reader.Read()) { T_COM_Master_Location obj = new T_COM_Master_Location(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_LocationCollection GetAllItem() { T_COM_Master_LocationCollection collection = new T_COM_Master_LocationCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Location_GetAll", null)) { while (reader.Read()) { T_COM_Master_Location obj = new T_COM_Master_Location(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static T_COM_Master_Location GetItemByID(int LocationID) { T_COM_Master_Location item = new T_COM_Master_Location(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@LocationID", LocationID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Location_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
private static SqlParameter[] CreateSqlParameter(T_COM_Master_Location model) { return(new SqlParameter[] { new SqlParameter("@LocationID", model.LocationID), new SqlParameter("@LocationName", model.LocationName), new SqlParameter("@LocationShortName", model.LocationShortName), new SqlParameter("@Address_EN", model.Address_EN), new SqlParameter("@Address_VN", model.Address_VN), new SqlParameter("@EntityID", model.EntityID), new SqlParameter("@CreatedBy", model.CreatedBy), new SqlParameter("@CreatedDate", model.CreatedDate), new SqlParameter("@ModifiedBy", model.ModifiedBy), new SqlParameter("@ModifiedDate", model.ModifiedDate), new SqlParameter("@IsActive", model.IsActive), }); }
public static T_COM_Master_LocationCollection GetAllItemByEnity(int EntityID) { T_COM_Master_LocationCollection collection = new T_COM_Master_LocationCollection(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@EntityID", EntityID); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "T_COM_Master_Location_GetAllByEntityID", sqlParams)) { while (reader.Read()) { T_COM_Master_Location obj = new T_COM_Master_Location(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }