public static ItemEventMapping AddItem(ItemEventMapping model)
{
String result = String.Empty;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "tblItemEventMapping_Add", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (String)reader[0];
}
}
return(GetItemByID(result));
}
private static SqlParameter[] CreateSqlParameter(ItemEventMapping model)
{
return(new SqlParameter[]
{
new SqlParameter("@ItemCode", model.ItemCode),
new SqlParameter("@EventCode", model.EventCode),
new SqlParameter("@ItemName", model.ItemName),
new SqlParameter("@EventName", model.EventName),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@Noted", model.Noted),
});
}
public static ItemEventMapping GetItemByID(String itemCode)
{
ItemEventMapping item = new ItemEventMapping();
var sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@ItemCode", itemCode);
using (var reader = SqlHelper.ExecuteReader("tblItemEventMapping_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
public static ItemEventMappingCollection GetAllItem()
{
ItemEventMappingCollection collection = new ItemEventMappingCollection();
using (var reader = SqlHelper.ExecuteReader("tblItemEventMapping_GetAll", null))
{
while (reader.Read())
{
ItemEventMapping obj = new ItemEventMapping();
obj = GetItemFromReader(reader);
collection.Add(obj);
}
}
return(collection);
}
private static ItemEventMapping GetItemFromReader(IDataReader dataReader)
{
ItemEventMapping objItem = new ItemEventMapping();
objItem.ItemCode = SqlHelper.GetString(dataReader, "ItemCode");
objItem.EventCode = SqlHelper.GetString(dataReader, "EventCode");
objItem.ItemName = SqlHelper.GetString(dataReader, "ItemName");
objItem.EventName = SqlHelper.GetString(dataReader, "EventName");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.Noted = SqlHelper.GetString(dataReader, "Noted");
return(objItem);
}
