public static ItemClassAttribute AddItem(ItemClassAttribute model) { String result = String.Empty; using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblItemClassAttribute_Add", CreateSqlParameter(model))) { while (reader.Read()) { result = (String)reader[0]; } } return(GetItemByID(result)); }
private static SqlParameter[] CreateSqlParameter(ItemClassAttribute model) { return(new SqlParameter[] { new SqlParameter("@AttID", model.AttID), new SqlParameter("@ClassCode", model.ClassCode), new SqlParameter("@AttName", model.AttName), new SqlParameter("@AttDesc", model.AttDesc), new SqlParameter("@Active", model.Active), new SqlParameter("@CreatedUser", model.CreatedUser), new SqlParameter("@CreatedDate", model.CreatedDate), }); }
public static ItemClassAttribute GetItemByID(String attID) { ItemClassAttribute item = new ItemClassAttribute(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@AttID", attID); using (var reader = SqlHelper.ExecuteReader("tblItemClassAttribute_GetByID", sqlParams)) { while (reader.Read()) { item = GetItemFromReader(reader); } } return(item); }
public static ItemClassAttributeCollection GetAllItem() { ItemClassAttributeCollection collection = new ItemClassAttributeCollection(); using (var reader = SqlHelper.ExecuteReader("tblItemClassAttribute_GetAll", null)) { while (reader.Read()) { ItemClassAttribute obj = new ItemClassAttribute(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
private static ItemClassAttribute GetItemFromReader(IDataReader dataReader) { ItemClassAttribute objItem = new ItemClassAttribute(); objItem.AttID = SqlHelper.GetString(dataReader, "AttID"); objItem.ClassCode = SqlHelper.GetString(dataReader, "ClassCode"); objItem.AttName = SqlHelper.GetString(dataReader, "AttName"); objItem.AttDesc = SqlHelper.GetString(dataReader, "AttDesc"); objItem.Active = SqlHelper.GetBoolean(dataReader, "Active"); objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser"); objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate"); return(objItem); }