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);
}
