public static DBgl_CountryCollection GetAllItem()
{
string key = SETTINGS_ALL_KEY;
object obj2 = dtpCache.Get(key);
if ((obj2 != null))
{
return((DBgl_CountryCollection)obj2);
}
DBgl_CountryCollection ItemCollection = new DBgl_CountryCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Country_GetAll");
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_Country item = GetItemFromReader(dataReader);
ItemCollection.Add(item);
}
}
dtpCache.Max(key, ItemCollection);
return(ItemCollection);
}
public static DBgl_Country GetItemByID(Int32 CountryID)
{
string key = String.Format(SETTINGS_ID_KEY, CountryID);
object obj2 = dtpCache.Get(key);
if (obj2 != null)
{
return((DBgl_Country)obj2);
}
DBgl_Country item = null;
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Country_GetByID");
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, CountryID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
item = GetItemFromReader(dataReader);
}
}
dtpCache.Max(key, item);
return(item);
}
public static DBgl_Country UpdateItem(int CountryID, string CountryName, bool isPublished, int Orders, string ImgUrl, string Description, string Code)
{
DBgl_Country item = null;
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Country_Update");
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, CountryID);
db.AddInParameter(dbCommand, "CountryName", DbType.String, CountryName);
db.AddInParameter(dbCommand, "isPublished", DbType.Boolean, isPublished);
db.AddInParameter(dbCommand, "Orders", DbType.Int32, Orders);
db.AddInParameter(dbCommand, "ImgUrl", DbType.String, ImgUrl);
db.AddInParameter(dbCommand, "Description", DbType.String, Description);
db.AddInParameter(dbCommand, "Code", DbType.String, Code);
if (db.ExecuteNonQuery(dbCommand) > 0)
{
item = GetItemByID(CountryID);
}
if (item != null)
{
RemoveCache(item);
}
return(item);
}
public static int DeleteItem(int ItemId)
{
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Country_Delete");
db.AddInParameter(dbCommand, "CountryID", DbType.Int32, ItemId);
DBgl_Country item = GetItemByID(ItemId);
if (item != null)
{
RemoveCache(item);
}
return(db.ExecuteNonQuery(dbCommand));
}
private static DBgl_Country GetItemFromReader(IDataReader dataReader)
{
DBgl_Country objItem = new DBgl_Country();
objItem.CountryID = SqlHelper.GetInt(dataReader, "CountryID");
objItem.CountryName = SqlHelper.GetString(dataReader, "CountryName");
objItem.isPublished = SqlHelper.GetBoolean(dataReader, "isPublished");
objItem.Orders = SqlHelper.GetInt(dataReader, "Orders");
objItem.ImgUrl = SqlHelper.GetString(dataReader, "ImgUrl");
objItem.Description = SqlHelper.GetString(dataReader, "Description");
objItem.Code = SqlHelper.GetString(dataReader, "Code");
return(objItem);
}
public static DBgl_CountryCollection GetItemPagging(int page, int rec, string strSearch, out int TotalRecords)
{
TotalRecords = 0;
DBgl_CountryCollection ItemCollection = new DBgl_CountryCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_Country_Paging");
db.AddInParameter(dbCommand, "Page", DbType.Int32, page);
db.AddInParameter(dbCommand, "RecsPerPage", DbType.Int32, rec);
db.AddInParameter(dbCommand, "SearchValue", DbType.String, strSearch);
db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_Country item = GetItemFromReader(dataReader);
ItemCollection.Add(item);
}
}
TotalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords"));
return(ItemCollection);
}
private static void RemoveCache(DBgl_Country objItem)
{
dtpCache.RemoveByPattern(SETTINGS_ALL_KEY);
dtpCache.RemoveByPattern(string.Format(SETTINGS_ID_KEY, objItem.CountryID));
}