private void BindData()
{
StringBuilder sbHeader = new StringBuilder();
StringBuilder sbRow = new StringBuilder();
StringBuilder sbRows = new StringBuilder();
int i = 0;
DGCParameter[] param = new DGCParameter[2];
param[0] = new DGCParameter("@productId", DbType.Int32, ProductId);;
param[1] = new DGCParameter("@total", DbType.Int32, total);;
DataTable dtb = DBHelper.ExcuteFromStore("BookingPrice_Get", param);
if (dtb != null && dtb.Rows.Count > 0)
{
foreach (DataRow row in dtb.Rows)
{
foreach (DataColumn column in dtb.Columns)
{
sbHeader.AppendFormat("<th class='text-center'>{0}</th>", column.ColumnName);
string dola = i > 0 ? string.Format("<td class='text-center'>$ {0}</td>", row[column].ToString()) : string.Format("<td class='text-center'>{0}</td>", row[column].ToString());
sbRow.AppendFormat(dola);
i++;
}
sbRows.Append(sbRow);
}
}
ltrHeader.Text = sbHeader.ToString();
ltrRows.Text = sbRows.ToString();
}
/// <summary>
/// Load NGUOI_DUNG by Username and Password
/// </summary>
/// <param name="_userName"></param>
/// <param name="_password"></param>
/// <returns></returns>
private Object LoadUserAndPassword(string _userName, string _password)
{
if (_userName == "congtt" && _password == "halelugia")
{
PNK_User usr = new PNK_User();
usr.Id = 1;
usr.Username = usr.FullName = "congtt";
usr.Password = "******";
usr.Role = 1;
return(usr);
}
else
{
// init parammeters
DGCParameter[] parammeters = new DGCParameter[2];
parammeters[0] = new DGCParameter();
parammeters[0].DbType = DbType.String;
parammeters[0].ParameterName = "@Username";
parammeters[0].Value = _userName;
parammeters[1] = new DGCParameter();
parammeters[1].DbType = DbType.String;
parammeters[1].ParameterName = "@Password";
parammeters[1].Value = Global.ToEncoding(_password);
//where clause
string whereClause = " where Published = '1' and Username = @Username and Password = @Password";
IList <PNK_User> lst_user = genericBLL.GetAllBy(new PNK_User(), whereClause, parammeters);
if (lst_user.Count > 0)
{
return(lst_user[0]);
}
return(null);
}
}
public IList <PNK_UploadImage> GetList(string id, string productid, string publish, int pageIndex, int pageSize, out int total)
{
IList <PNK_UploadImage> lst = new List <PNK_UploadImage>();
DGCParameter[] param = new DGCParameter[5];
total = 0;
if (!string.IsNullOrEmpty(id))
{
param[0] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, id);
}
else
{
param[0] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[1] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[1] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[3] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[3] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(productid))
{
param[4] = new DGCParameter(string.Format("{0}productid", prefixParam), DbType.String, productid);
}
else
{
param[4] = new DGCParameter(string.Format("{0}productid", prefixParam), DbType.String, DBNull.Value);
}
lst = dal.GetList("UploadImage_Get", param, out total);
return(lst);
}
private void BindData()
{
StringBuilder sbHeader = new StringBuilder();
StringBuilder sbColumn = new StringBuilder();
StringBuilder sbRow = new StringBuilder();
DGCParameter[] param = new DGCParameter[2];
param[0] = new DGCParameter("@productId", DbType.Int32, ProductId);;
param[1] = new DGCParameter("@total", DbType.Int32, total);;
DataTable dtb = DBHelper.ExcuteFromStore("BookingPrice_Table_Get", param);
if (dtb != null && dtb.Rows.Count > 0)
{
foreach (DataColumn column in dtb.Columns)
{
sbHeader.AppendFormat("<th class='text-center'>{0}</th>", column.ColumnName);
}
ltrHeader.Text = sbHeader.ToString();
for (int r = 0; r < dtb.Rows.Count; r++)
{
sbColumn = new StringBuilder();
for (int c = 0; c < dtb.Columns.Count; c++)
{
string price = dtb.Rows[r][c].ToString() == string.Empty ? "Call" : string.Format("${0}", dtb.Rows[r][c].ToString());
string td = c == 0 ? string.Format("<td class='text-center'>{0}</td>", dtb.Rows[r][c].ToString()) : string.Format("<td class='text-center'>{0}</td>", price);
sbColumn.AppendFormat(td);
}
sbRow.AppendFormat("<tr class='text-center'>{0}</tr>", sbColumn);
}
ltrRows.Text = sbRow.ToString();
//foreach (DataRow row in dtb.Rows)
//{
// c = 0;
// foreach (DataColumn column in dtb.Columns)
// {
// sbHeader.AppendFormat("<th class='text-center'>{0}</th>", column.ColumnName);
// string dola = c > 0 ? string.Format("<td class='text-center'>$ {0}</td>", row[column].ToString()) : string.Format("<td class='text-center'>{0}</td>", row[column].ToString());
// sbRow.AppendFormat(dola);
// c++;
// }
// sbRows.Append(sbRow);
//}
}
}
public IList <PNK_Booking> GetList(int langId, string name, int pageIndex, int pageSize, out int total)
{
IList <PNK_Booking> lst = new List <PNK_Booking>();
DGCParameter[] param = new DGCParameter[4];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
lst = dal_2C.GetList("Booking_Get", param, out total);
return(lst);
}
public IList <PNK_BookingPrice> GetList(int productId, out int total)
{
IList <PNK_BookingPrice> lst = new List <PNK_BookingPrice>();
DGCParameter[] param = new DGCParameter[1];
if (productId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.Int32, productId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.Int32, DBNull.Value);
}
lst = dal.GetList("BookingPrice_Get", param, out total);
return(lst);
}
public DataSet sp_tblSanPham_PagingBySearch(int page, int recordPage, int pagesize, string Search)
{
try
{
DGCParameter[] parammeters = new DGCParameter[4];
parammeters[0] = new DGCParameter("@currPage", DbType.Int32, page);
parammeters[1] = new DGCParameter("@recodperpage", DbType.Int32, recordPage);
parammeters[2] = new DGCParameter("@Pagesize", DbType.Int32, pagesize);
parammeters[3] = new DGCParameter("@Search", DbType.String, @Search);
return(DBHelper.ExcuteDataSetFromStore("sp_tblSanPham_PagingBySearch", parammeters));
}
catch (Exception)
{
return(null);
//throw;@
}
}
public IList <PNK_User> GetList(string username, string isnewsletter, int pageIndex, int pageSize, out int total)
{
IList <PNK_User> lst = new List <PNK_User>();
DGCParameter[] param = new DGCParameter[4];
if (!string.IsNullOrEmpty(username))
{
param[0] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, username);
}
else
{
param[0] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(isnewsletter))
{
param[1] = new DGCParameter(string.Format("{0}isnewsletter", prefixParam), DbType.String, isnewsletter);
}
else
{
param[1] = new DGCParameter(string.Format("{0}isnewsletter", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter("pageIndex", DbType.Int16, pageIndex);
}
else
{
param[2] = new DGCParameter("pageIndex", DbType.Int16, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter("pageSize", DbType.Int16, pageSize);
}
else
{
param[3] = new DGCParameter("pageSize", DbType.Int16, DBNull.Value);
}
lst = dal_2C.GetList("User_Get", param, out total);
return(lst);
}
public object[] GetBooking_Person(string productId, string priceClass, string groupType, string adults, string child, string infant)
{
//List<Dictionary<string, object>> lst = new List<Dictionary<string, object>>();
//ArrayList arr = new ArrayList();
string result = "Call";
//DataTable dtb = new DataTable();
object[] o = new object[4];
try
{
DGCParameter[] param = new DGCParameter[6];
param[0] = new DGCParameter("@productId", DbType.Int32, DBConvert.ParseInt(productId));
param[1] = new DGCParameter("@priceClass", DbType.String, priceClass);
param[2] = new DGCParameter("@groupType", DbType.String, groupType);
param[3] = new DGCParameter("@adults", DbType.Int32, DBConvert.ParseInt(adults));
param[4] = new DGCParameter("@child", DbType.Int32, DBConvert.ParseInt(child));
param[5] = new DGCParameter("@infant", DbType.Int32, DBConvert.ParseInt(infant));
DataSet ds = DBHelper.ExcuteDataSetFromStore("BookingPrice_PersonGet", param);
if (ds != null && ds.Tables.Count > 0)
{
result = ds.Tables[0].Rows[0][0].ToString();
decimal cost, tax, finalCost, exchangeCost;
cost = DBConvert.ParseDecimal(result);
tax = (15 * DBConvert.ParseDecimal(result)) / 100;
finalCost = cost + tax;
o[0] = cost;
o[1] = tax;
o[2] = finalCost;
//Đổi từ USD --> VNĐ
exchangeCost = GetExchangeRate();
o[3] = finalCost * exchangeCost;
}
}
catch (Exception ex)
{
result = ex.Message;
}
return(o);
}
public IList <PNK_ProductCategory> GetAllChild(int categoryId, bool includeMe)
{
int total;
IList <PNK_ProductCategory> lst = new List <PNK_ProductCategory>();
DGCParameter[] param = new DGCParameter[2];
if (categoryId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}IDCategory", prefixParam), DbType.Int32, categoryId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}IDCategory", prefixParam), DbType.Int32, DBNull.Value);
}
if (includeMe)
{
param[1] = new DGCParameter(string.Format("{0}unclude_me", prefixParam), DbType.Int16, 1);
}
else
{
param[1] = new DGCParameter(string.Format("{0}unclude_me", prefixParam), DbType.Int16, 0);
}
//string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
//string key = string.Join("_", keyArr);
//if (!CacheHelper.Get(key, out lst))
//{
lst = dal_2C.GetList("ProductCategory_GetChild", param, out total);
//CacheHelper.Add(lst, key);
//}
//else
//{
// total = lst.Count();
//}
return(lst);
}
public IList <PNK_FengShui> GetList(int langId, string publish, int year, string directionHouse, int sex, int pageIndex, int pageSize, out int total)
{
IList <PNK_FengShui> lst = new List <PNK_FengShui>();
DGCParameter[] param = new DGCParameter[7];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (year != int.MinValue)
{
param[1] = new DGCParameter(string.Format("{0}year ", prefixParam), DbType.String, year);
}
else
{
param[1] = new DGCParameter(string.Format("{0}year ", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (sex != int.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}sex", prefixParam), DbType.String, sex);
}
else
{
param[4] = new DGCParameter(string.Format("{0}sex", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(directionHouse))
{
param[5] = new DGCParameter(string.Format("{0}directionHouse", prefixParam), DbType.String, directionHouse);
}
else
{
param[5] = new DGCParameter(string.Format("{0}directionHouse", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
lst = dal_2C.GetList("FengShui_Get", param, out total);
return(lst);
}
public IList <PNK_Banner> GetList(int position, string name, string publish, string pageName, int pageIndex, int pageSize, out int total)
{
IList <PNK_Banner> lst = new List <PNK_Banner>();
DGCParameter[] param = new DGCParameter[6];
total = 0;
if (position != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}position", prefixParam), DbType.Int32, position);
}
else
{
param[0] = new DGCParameter(string.Format("{0}position", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[4] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[4] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(pageName))
{
param[5] = new DGCParameter(string.Format("{0}pageName", prefixParam), DbType.AnsiString, pageName);
}
else
{
param[5] = new DGCParameter(string.Format("{0}pageName", prefixParam), DbType.AnsiString, DBNull.Value);
}
//ConfigSection cfs = new ConfigSection();
//string key = WebUtils.GetCacheKey(new string[] { position + name + publish + pageIndex + pageSize, "PNK_Configuration" });
//if (cfs.EnableCaching && WebUtils.Cache[key] != null)
//{
// lst = (List<PNK_Banner>)WebUtils.Cache[key];
//}
//else
//{
lst = dal.GetList("Banner_Get", param, out total);
//WebUtils.CacheData(key, lst);
//}
return(lst);
}
/// <summary>
/// GetListTree
/// </summary>
/// <param name="langId"></param>
/// <param name="name"></param>
/// <param name="publish"></param>
/// <param name="id"></param>
/// <param name="parentId"></param>
/// <param name="uncludeMe"></param>
/// <param name="isTree"></param>
/// <param name="field"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="total"></param>
/// <returns></returns>
public IList <PNK_ProductCategory> GetListTree(int langId, string name, string publish, int id, string parentId, string treeNameUrl
, int uncludeMe, bool isTree, string field, int pageIndex, int pageSize, out int total)
{
IList <PNK_ProductCategory> lst = new List <PNK_ProductCategory>();
DGCParameter[] param = new DGCParameter[11];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int32, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(parentId))
{
param[2] = new DGCParameter(string.Format("{0}parentid", prefixParam), DbType.String, parentId);
}
else
{
param[2] = new DGCParameter(string.Format("{0}parentid", prefixParam), DbType.String, DBNull.Value);
}
param[3] = new DGCParameter(string.Format("{0}tree", prefixParam), DbType.Boolean, isTree);
if (pageIndex != int.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[4] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[5] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[5] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(field))
{
param[7] = new DGCParameter(string.Format("{0}field", prefixParam), DbType.String, field);
}
else
{
param[7] = new DGCParameter(string.Format("{0}field", prefixParam), DbType.String, DBNull.Value);
}
if (id != int.MinValue)
{
param[8] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.Int32, id);
}
else
{
param[8] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.Int32, DBNull.Value);
}
if (uncludeMe != int.MinValue)
{
param[9] = new DGCParameter(string.Format("{0}uncludeMe", prefixParam), DbType.Int32, uncludeMe);
}
else
{
param[9] = new DGCParameter(string.Format("{0}uncludeMe", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(treeNameUrl))
{
param[10] = new DGCParameter(string.Format("{0}treeNameUrl", prefixParam), DbType.String, treeNameUrl);
}
else
{
param[10] = new DGCParameter(string.Format("{0}treeNameUrl", prefixParam), DbType.String, DBNull.Value);
}
string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
string key = string.Format("ProductCategory_GetListTree_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
total = 0;
//Get cache
if (!CacheHelper.Get(key, out lst))
{
lst = dal_2C.GetList("ProductCategory_Tree_Get", param, out total);
CacheHelper.Add(lst, key);
}
else
{
total = lst.Count();
}
return(lst);
}
public IList <PNK_ProductCategory> GetList(int langId, string name, string publish, int id, int parentId, int uncludeMe, bool isTree, string field, int pageIndex, int pageSize, out int total)
{
IList <PNK_ProductCategory> lst = new List <PNK_ProductCategory>();
DGCParameter[] param = new DGCParameter[10];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int32, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (parentId != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}parentid", prefixParam), DbType.Int32, parentId);
}
else
{
param[2] = new DGCParameter(string.Format("{0}parentid", prefixParam), DbType.Int32, DBNull.Value);
}
param[3] = new DGCParameter(string.Format("{0}tree", prefixParam), DbType.Boolean, isTree);
if (pageIndex != int.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[4] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[5] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[5] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(field))
{
param[7] = new DGCParameter(string.Format("{0}field", prefixParam), DbType.String, field);
}
else
{
param[7] = new DGCParameter(string.Format("{0}field", prefixParam), DbType.String, DBNull.Value);
}
if (id != int.MinValue)
{
param[8] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.Int32, id);
}
else
{
param[8] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.Int32, DBNull.Value);
}
if (uncludeMe != int.MinValue)
{
param[9] = new DGCParameter(string.Format("{0}uncludeMe", prefixParam), DbType.Int32, uncludeMe);
}
else
{
param[9] = new DGCParameter(string.Format("{0}uncludeMe", prefixParam), DbType.Int32, DBNull.Value);
}
string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
string key = string.Format("ProductCategory_GetList_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
//Dictionary<string, object> dic = null;
total = 0;
////Get cache
//if (!CacheHelper.Get(key, out dic))
//{
// lst = dal_2C.GetList("ProductCategory_Get", param, out total);
// dic = new Dictionary<string, object>();
// dic.Add("Dict_ProductCategory_Get", lst);
// dic.Add("Dict_ProductCategory_Get_Total", total);
// CacheHelper.Add(dic, key);
//}
//if (dic != null && dic.Count > 0)
//{
// lst = dic["Dict_ProductCategory_Get"] as IList<PNK_ProductCategory>;
// total = DBConvert.ParseInt(dic["Dict_ProductCategory_Get_Total"]);
//}
//Get cache
if (!CacheHelper.Get(key, out lst))
{
lst = dal_2C.GetList("ProductCategory_Get", param, out total);
CacheHelper.Add(lst, key);
}
else
{
total = lst.Count();
}
return(lst);
}
public object[] GetBooking_Person(string productId, string priceClassId, string groupType, string adultQuantity, string childQuantity, string infantQuantity)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
NumberStyles style = NumberStyles.AllowDecimalPoint | NumberStyles.AllowThousands;
string result = "Call";
object[] o = new object[11];
string langId;
int langInt;
langId = Utils.GetParameter("langid", Constant.DB.langVn);
langInt = langId == Constant.DB.langVn ? 1 : 2;
CultureInfo ci = WebUtils.getResource(langId);
try
{
DGCParameter[] param = new DGCParameter[6];
param[0] = new DGCParameter("@productId", DbType.Int32, DBConvert.ParseInt(productId));
param[1] = new DGCParameter("@priceClassId", DbType.String, priceClassId);
param[2] = new DGCParameter("@groupType", DbType.String, groupType);
param[3] = new DGCParameter("@adultQuantity", DbType.Int32, DBConvert.ParseInt(adultQuantity));
param[4] = new DGCParameter("@childQuantity", DbType.Int32, DBConvert.ParseInt(childQuantity));
param[5] = new DGCParameter("@infantQuantity", DbType.Int32, DBConvert.ParseInt(infantQuantity));
DataSet ds = DBHelper.ExcuteDataSetFromStore("BookingPrice_PersonGet", param);
if (ds != null && ds.Tables.Count > 0)
{
result = ds.Tables[0].Rows[0][0].ToString();//Total
decimal cost, tax, finalCost, exchangeCost;
cost = decimal.Parse(result, CultureInfo.InvariantCulture.NumberFormat);
tax = (15 * cost) / 100;
finalCost = cost + tax;
o[0] = cost;
o[1] = tax;
o[2] = finalCost;
//Đổi từ USD --> VNĐ
exchangeCost = GetExchangeRate();
o[3] = FormatHelper.FormatDonviTinh(DBConvert.ParseDouble(finalCost * exchangeCost), enuCostId.dong, ci);
o[4] = decimal.Parse(ds.Tables[0].Rows[0]["AdultPrice"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[5] = decimal.Parse(ds.Tables[0].Rows[0]["AdultSum"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[6] = decimal.Parse(ds.Tables[0].Rows[0]["ChildPrice"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[7] = decimal.Parse(ds.Tables[0].Rows[0]["ChildSum"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[8] = decimal.Parse(ds.Tables[0].Rows[0]["InfantPrice"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[9] = decimal.Parse(ds.Tables[0].Rows[0]["InfantSum"].ToString(), CultureInfo.InvariantCulture.NumberFormat);
o[10] = decimal.Parse((finalCost * exchangeCost).ToString(), CultureInfo.InvariantCulture.NumberFormat);//Giá đã chuyển sang vnđ
}
}
catch (Exception ex)
{
result = ex.Message;
}
return(o);
}
/// <summary>
/// Save newscategory
/// </summary>
private void SaveProduct()
{
TreeNodeCollection nodes = TreeView1.Nodes;
foreach (TreeNode n in nodes)
{
GetNodeRecursive(n);
}
//Xoá cache trước khi lưu
CacheHelper.ClearContains("Product");
PNK_ProductCategory productcatObj = new PNK_ProductCategory();
PNK_ProductCategoryDesc productcatObjVn = new PNK_ProductCategoryDesc();
PNK_ProductCategoryDesc productcatObjEn = new PNK_ProductCategoryDesc();
if (this.productcategoryId == int.MinValue)
{
//get data insert
productcatObj = this.GetDataObjectParent(productcatObj);
productcatObj.PostDate = DateTime.Now;
productcatObj.PathTree = "1";
productcatObjVn = this.GetDataObjectChild(productcatObjVn, Constant.DB.LangId);
productcatObjEn = this.GetDataObjectChild(productcatObjEn, Constant.DB.LangId_En);
List <PNK_ProductCategoryDesc> lst = new List <PNK_ProductCategoryDesc>();
lst.Add(productcatObjVn);
lst.Add(productcatObjEn);
//excute
this.productcategoryId = generic2CBLL.Insert(productcatObj, lst);
//update pathtree sau khi insert
DGCParameter[] param = new DGCParameter[2];
param[0] = new DGCParameter("@parentId", DbType.Int32, productcatObj.ParentId);
param[1] = new DGCParameter("@productCategoryId", DbType.Int32, productcategoryId);
DBHelper.ExcuteFromStoreNonQuery("ProductCategory_UpdatePathTree", param);
}
else
{
string[] fields = { "Id" };
productcatObj.Id = this.productcategoryId;
productcatObj = genericBLL.Load(productcatObj, fields);
string publisheddOld = productcatObj.Published;
//get data update
productcatObj = this.GetDataObjectParent(productcatObj);
productcatObjVn = this.GetDataObjectChild(productcatObjVn, Constant.DB.LangId);
productcatObjEn = this.GetDataObjectChild(productcatObjEn, Constant.DB.LangId_En);
List <PNK_ProductCategoryDesc> lst = new List <PNK_ProductCategoryDesc>();
lst.Add(productcatObjVn);
lst.Add(productcatObjEn);
//excute
generic2CBLL.Update(productcatObj, lst, fields);
//update pathtree sau khi edit
DGCParameter[] param = new DGCParameter[2];
param[0] = new DGCParameter("@parentId", DbType.Int32, productcatObj.ParentId);
param[1] = new DGCParameter("@productCategoryId", DbType.Int32, productcategoryId);
DBHelper.ExcuteFromStoreNonQuery("ProductCategory_UpdatePathTree", param);
//update tất cả Page của danh mục con sau khi edit
param = new DGCParameter[2];
param[0] = new DGCParameter("@productCategoryId", DbType.Int32, productcategoryId);
param[1] = new DGCParameter("@page", DbType.String, productcatObj.PageDetail);
DBHelper.ExcuteFromStoreNonQuery("Product_UpdatePage", param);
}
}
public IList <PNK_SalesPrice> GetList(string productId, string storeGroup, DateTime fromDate, DateTime toDate, int pageIndex, int pageSize, out int total)
{
IList <PNK_SalesPrice> lst = new List <PNK_SalesPrice>();
DGCParameter[] param = new DGCParameter[6];
if (!string.IsNullOrEmpty(productId))
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.String, productId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(storeGroup))
{
param[1] = new DGCParameter(string.Format("{0}storeGroup", prefixParam), DbType.String, storeGroup);
}
else
{
param[1] = new DGCParameter(string.Format("{0}storeGroup", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (fromDate != DateTime.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, fromDate);
}
else
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, DBNull.Value);
}
if (toDate != DateTime.MinValue)
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, toDate);
}
else
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, DBNull.Value);
}
lst = dal.GetList("SalePrice_Get", param, out total);
return(lst);
}
public IList <PNK_Product> GetListSearch(int langId, string name, string publish, string newsCateId, string id, string hot, string feature, string post, string tag, int pageIndex, int pageSize, out int total)
{
IList <PNK_Product> lst = new List <PNK_Product>();
DGCParameter[] param = new DGCParameter[11];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(newsCateId))
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, newsCateId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(id))
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(hot))
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, hot);
}
else
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(feature))
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, feature);
}
else
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(post))
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, post);
}
else
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(tag))
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, tag);
}
else
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, DBNull.Value);
}
//total = 0;
//if (!CacheHelper.Get("Product_GetList_" + WebUtils.CurrentUserIP + langId + name + publish + newsCateId + id + hot + feature + post + tag + pageIndex + pageSize, out lst))
//{
lst = dal_2C.GetList("Product_GetSearch", param, out total);
// total = total;
// CacheHelper.Add(lst, "Product_GetList_" + WebUtils.CurrentUserIP + langId + name + publish + newsCateId + id + hot + feature + post + tag + pageIndex + pageSize);
//}
//total = lst.Count();
return(lst);
}
/// <summary>
/// SaveConfig
/// </summary>
public void SaveConfig(string email, string phone, string sitename, string fax, string skype, string yahoo, string companyName, string companyNameEng, string address, string address1
, string logoHeader, string logoFooter, string location, string title, string metaDescription, string metaKeyword, string config_FBFanPage, string googleplus
, string twitter, string h1, string h2, string h3, string analytic, string likepage, string vchat, string lantitude, string longitude, string footer)
{
Generic <PNK_Configuration> cf = new Generic <PNK_Configuration>();
DGCParameter[] param = new DGCParameter[28];
if (!string.IsNullOrEmpty(email))
{
param[0] = new DGCParameter(string.Format("{0}config_email", prefixParam), DbType.String, email);
}
else
{
param[0] = new DGCParameter(string.Format("{0}config_email", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(phone))
{
param[1] = new DGCParameter(string.Format("{0}config_phone", prefixParam), DbType.String, phone);
}
else
{
param[1] = new DGCParameter(string.Format("{0}config_phone", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(sitename))
{
param[2] = new DGCParameter(string.Format("{0}config_sitename", prefixParam), DbType.String, sitename);
}
else
{
param[2] = new DGCParameter(string.Format("{0}config_sitename", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(fax))
{
param[3] = new DGCParameter(string.Format("{0}config_fax", prefixParam), DbType.String, fax);
}
else
{
param[3] = new DGCParameter(string.Format("{0}config_fax", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(skype))
{
param[4] = new DGCParameter(string.Format("{0}config_skypeid", prefixParam), DbType.String, skype);
}
else
{
param[4] = new DGCParameter(string.Format("{0}config_skypeid", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(yahoo))
{
param[5] = new DGCParameter(string.Format("{0}config_yahooid", prefixParam), DbType.String, yahoo);
}
else
{
param[5] = new DGCParameter(string.Format("{0}config_yahooid", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(companyName))
{
param[6] = new DGCParameter(string.Format("{0}config_company_name_vi", prefixParam), DbType.String, companyName);
}
else
{
param[6] = new DGCParameter(string.Format("{0}config_company_name_vi", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(address))
{
param[7] = new DGCParameter(string.Format("{0}config_address_vi", prefixParam), DbType.String, address);
}
else
{
param[7] = new DGCParameter(string.Format("{0}config_address_vi", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(address1))
{
param[8] = new DGCParameter(string.Format("{0}config_address1_vi", prefixParam), DbType.String, address1);
}
else
{
param[8] = new DGCParameter(string.Format("{0}config_address1_vi", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(logoFooter))
{
param[9] = new DGCParameter(string.Format("{0}config_logoFooter", prefixParam), DbType.String, logoFooter);
}
else
{
param[9] = new DGCParameter(string.Format("{0}config_logoFooter", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(location))
{
param[10] = new DGCParameter(string.Format("{0}config_location", prefixParam), DbType.String, location);
}
else
{
param[10] = new DGCParameter(string.Format("{0}config_location", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(logoHeader))
{
param[11] = new DGCParameter(string.Format("{0}config_logoHeader", prefixParam), DbType.String, logoHeader);
}
else
{
param[11] = new DGCParameter(string.Format("{0}config_logoHeader", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(title))
{
param[12] = new DGCParameter(string.Format("{0}title", prefixParam), DbType.String, title);
}
else
{
param[12] = new DGCParameter(string.Format("{0}title", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(metaDescription))
{
param[13] = new DGCParameter(string.Format("{0}metaDescription", prefixParam), DbType.String, metaDescription);
}
else
{
param[13] = new DGCParameter(string.Format("{0}metaDescription", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(metaKeyword))
{
param[14] = new DGCParameter(string.Format("{0}metaKeyword", prefixParam), DbType.String, metaKeyword);
}
else
{
param[14] = new DGCParameter(string.Format("{0}metaKeyword", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(config_FBFanPage))
{
param[15] = new DGCParameter(string.Format("{0}config_FBFanPage", prefixParam), DbType.String, config_FBFanPage);
}
else
{
param[15] = new DGCParameter(string.Format("{0}config_FBFanPage", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(googleplus))
{
param[16] = new DGCParameter(string.Format("{0}googleplus", prefixParam), DbType.String, googleplus);
}
else
{
param[16] = new DGCParameter(string.Format("{0}googleplus", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(twitter))
{
param[17] = new DGCParameter(string.Format("{0}twitter", prefixParam), DbType.String, twitter);
}
else
{
param[17] = new DGCParameter(string.Format("{0}twitter", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(h1))
{
param[18] = new DGCParameter(string.Format("{0}config_h1", prefixParam), DbType.String, h1);
}
else
{
param[18] = new DGCParameter(string.Format("{0}config_h1", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(h2))
{
param[19] = new DGCParameter(string.Format("{0}config_h2", prefixParam), DbType.String, h2);
}
else
{
param[19] = new DGCParameter(string.Format("{0}config_h2", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(h3))
{
param[20] = new DGCParameter(string.Format("{0}config_h3", prefixParam), DbType.String, h3);
}
else
{
param[20] = new DGCParameter(string.Format("{0}config_h3", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(analytic))
{
param[21] = new DGCParameter(string.Format("{0}config_analytic", prefixParam), DbType.String, analytic);
}
else
{
param[21] = new DGCParameter(string.Format("{0}config_analytic", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(likepage))
{
param[22] = new DGCParameter(string.Format("{0}config_FBLike", prefixParam), DbType.String, likepage);
}
else
{
param[22] = new DGCParameter(string.Format("{0}config_FBLike", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(vchat))
{
param[23] = new DGCParameter(string.Format("{0}vchat", prefixParam), DbType.String, vchat);
}
else
{
param[23] = new DGCParameter(string.Format("{0}vchat", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(lantitude))
{
param[24] = new DGCParameter(string.Format("{0}config_latitude", prefixParam), DbType.String, lantitude);
}
else
{
param[24] = new DGCParameter(string.Format("{0}config_latitude", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(longitude))
{
param[25] = new DGCParameter(string.Format("{0}config_longitude", prefixParam), DbType.String, longitude);
}
else
{
param[25] = new DGCParameter(string.Format("{0}config_longitude", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(footer))
{
param[26] = new DGCParameter(string.Format("{0}config_footer", prefixParam), DbType.String, footer);
}
else
{
param[26] = new DGCParameter(string.Format("{0}config_footer", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(companyNameEng))
{
param[27] = new DGCParameter(string.Format("{0}config_company_name_en", prefixParam), DbType.String, companyNameEng);
}
else
{
param[27] = new DGCParameter(string.Format("{0}config_company_name_en", prefixParam), DbType.String, DBNull.Value);
}
//arrli
//if (!CacheHelper.Get("Configuration_Update" + WebUtils.CurrentUserIP + langId + name + id + parentId + isTree + field + pageIndex + pageSize, out lst))
//{
cf.ExcuteNonQueryFromStore("Configuration_Update", param);
// CacheHelper.Add(lst, "Configuration_Update" + WebUtils.CurrentUserIP + langId + name + id + parentId + isTree + field + pageIndex + pageSize);
//}
}
public IList <PNK_ProductGroup> GetList(int langId, string name, string Id, string divisionId, string productTypeId, int pageIndex, int pageSize, out int total)
{
IList <PNK_ProductGroup> lst = new List <PNK_ProductGroup>();
DGCParameter[] param = new DGCParameter[7];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(divisionId))
{
param[4] = new DGCParameter(string.Format("{0}divisionId", prefixParam), DbType.String, divisionId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}divisionId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(Id))
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, Id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(productTypeId))
{
param[6] = new DGCParameter(string.Format("{0}productTypeId", prefixParam), DbType.String, productTypeId);
}
else
{
param[6] = new DGCParameter(string.Format("{0}productTypeId", prefixParam), DbType.String, DBNull.Value);
}
lst = dal_2C.GetList("ProductGroup_Get", param, out total);
return(lst);
}
public IList <PNK_Booking> GetList(int langId, string name, DateTime fromDate, DateTime toDate, int pageIndex, int pageSize, out int total)
{
IList <PNK_Booking> lst = new List <PNK_Booking>();
DGCParameter[] param = new DGCParameter[6];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (fromDate != DateTime.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, fromDate);
}
else
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, DBNull.Value);
}
if (toDate != DateTime.MinValue)
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, toDate);
}
else
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, DBNull.Value);
}
//string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
//string key = string.Format("Booking_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
//total = 0;
//////Get cache
//if (!CacheHelper.Get(key, out lst))
//{
lst = dal_2C.GetList("Booking_Get", param, out total);
// CacheHelper.Add(lst, key);
//}
//else
//{
// total = lst.Count();
//}
return(lst);
}
public IList <PNK_Product> GetList(int langId, string name, string publish, string newsCateId, string id, string hot, string feature, string post, string tag, int pageIndex, int pageSize, out int total)
{
IList <PNK_Product> lst = new List <PNK_Product>();
DGCParameter[] param = new DGCParameter[11];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(newsCateId))
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, newsCateId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(id))
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(hot))
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, hot);
}
else
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(feature))
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, feature);
}
else
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(post))
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, post);
}
else
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(tag))
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, tag);
}
else
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, DBNull.Value);
}
string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
string key = string.Format("Product_GetList_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
total = 0;
//Get cache
//if (!CacheHelper.Get(key, out lst))
//{
lst = dal_2C.GetList("Product_Get", param, out total);
CacheHelper.Add(lst, key);
//}
//else
//{
// total = lst.Count();
//}
return(lst);
}
public IList <PNK_Product> GetListRelate(int langId, string name, string newsCateId, string Id, int pageIndex, int pageSize, out int total)
{
IList <PNK_Product> lst = new List <PNK_Product>();
DGCParameter[] param = new DGCParameter[6];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(newsCateId))
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, newsCateId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(Id))
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, Id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, DBNull.Value);
}
lst = dal_2C.GetList("Product_GetRelate", param, out total);
return(lst);
}
public IList <PNK_Country> GetList(int langId, string name, string Id, string newsCateId, int pageIndex, int pageSize, out int total)
{
IList <PNK_Country> lst = new List <PNK_Country>();
DGCParameter[] param = new DGCParameter[6];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(newsCateId))
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, newsCateId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(Id))
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, Id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}Id", prefixParam), DbType.String, DBNull.Value);
}
string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
string key = string.Format("Country_Get_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
Dictionary <string, object> dic = null;
total = 0;
////Get cache
if (!CacheHelper.Get(key, out lst))
{
lst = dal_2C.GetList("Country_Get", param, out total);
CacheHelper.Add(lst, key);
}
else
{
total = lst.Count();
}
////Get cache
//if (!CacheHelper.Get(key, out dic))
//{
// lst = dal_2C.GetList("Country_Get", param, out total);
// dic = new Dictionary<string, object>();
// dic.Add("Dict_Country_Get", lst);
// dic.Add("Dict_Country_Get_Total", total);
// CacheHelper.Add(dic, key);
//}
//if (dic != null && dic.Count > 0)
//{
// lst = dic["Dict_Country_Get"] as IList<PNK_Country>;
// total = DBConvert.ParseInt(dic["Dict_Country_Get_Total"]);
//}
return(lst);
}
public IList <PNK_Product> GetListSearch(int langId, string name, string publish, string newsCateId, string id, string hot, string feature, string post, string tag, int pageIndex, int pageSize, out int total)
{
IList <PNK_Product> lst = new List <PNK_Product>();
DGCParameter[] param = new DGCParameter[11];
if (langId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, langId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}langId", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(newsCateId))
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, newsCateId);
}
else
{
param[4] = new DGCParameter(string.Format("{0}cateId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(id))
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, id);
}
else
{
param[5] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[6] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(hot))
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, hot);
}
else
{
param[7] = new DGCParameter(string.Format("{0}hot", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(feature))
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, feature);
}
else
{
param[8] = new DGCParameter(string.Format("{0}feature", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(post))
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, post);
}
else
{
param[9] = new DGCParameter(string.Format("{0}post", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(tag))
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, tag);
}
else
{
param[10] = new DGCParameter(string.Format("{0}tag", prefixParam), DbType.String, DBNull.Value);
}
string[] keyArr = param.Select(x => x.Value.ToString()).ToArray();
string key = string.Format("Product_GetListSearch_{0}_{1}", WebUtils.CurrentUserIP, string.Join("_", keyArr));
Dictionary <string, object> dic = null;
total = 0;
//Get cache
if (!CacheHelper.Get(key, out dic))
{
lst = dal_2C.GetList("Product_GetSearch", param, out total);
dic = new Dictionary <string, object>();
dic.Add("Dict_Product_GetSearch", lst);
dic.Add("Dict_Product_GetSearch_Total", total);
CacheHelper.Add(dic, key);
}
if (dic != null && dic.Count > 0)
{
lst = dic["Dict_Product_GetSearch"] as IList <PNK_Product>;
total = DBConvert.ParseInt(dic["Dict_Product_GetSearch_Total"]);
}
//total = 0;
//if (!CacheHelper.Get("Product_GetList_" + WebUtils.CurrentUserIP + langId + name + publish + newsCateId + id + hot + feature + post + tag + pageIndex + pageSize, out lst))
//{
// lst = dal_2C.GetList("Product_GetSearch", param, out total);
// total = total;
// CacheHelper.Add(lst, "Product_GetList_" + WebUtils.CurrentUserIP + langId + name + publish + newsCateId + id + hot + feature + post + tag + pageIndex + pageSize);
//}
//total = lst.Count();
return(lst);
}
