public void CertifyCount(int?id)
{
#region Certify
svCompany = new CompanyService();
string sqlSelectCertify = "CompCertifyID,CompID,CompName,CertifyName,CertifyImgPath";
string sqlWhereCertify = "IsDelete = 0 AND CompID =" + id;
var certify = svCompany.CountData <view_CompanyCertify>(sqlSelectCertify, sqlWhereCertify);
ViewBag.CertifyCount = certify;
#endregion
}
public ActionResult B2BToday()
{
var svProduct = new ProductService();
var svBuylead = new BuyleadService();
var svCompany = new CompanyService();
var sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
string CountProduct = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And CateLV1=7102";
string Countsoftware = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
sqlWhere = svCompany.CreateWhereAction(CompStatus.HaveProduct);
sqlWhere += svCompany.CreateWhereServiceType(3);
string CountSupplier = svCompany.CountData <b2bCompany>("CompID", sqlWhere).ToString("#,##0");
return(Json(new { ProductAll = CountProduct, SupplierAll = CountSupplier, SoftwareAll = Countsoftware }));
}
public int DefaultWebsite(int id, string page)
{
svCompany = new CompanyService();
string sqlWhere = string.Empty;
string sqlSelect = "CompID,CompName,CompCode,CompLevel,emCompID,LogoImgPath,CompWebsiteTemplate,ViewCount,ProductCount,CompHistory,IsOnline,CompAddrLine1,CompPhone,ProvinceName,CreatedDate";
if (LogonRowFlag == 3)
{
sqlWhere = svCompany.CreateWhereAction(CompStatus.All, id);
}
else
{
sqlWhere = svCompany.CreateWhereAction(CompStatus.Online, id);
}
var countcompany = svCompany.CountData <view_Company>(sqlSelect, sqlWhere);
if (countcompany > 0)
{
AddViewCount(id, "Supplier");
ViewBag.LogonCompID = LogonCompID;
var company = svCompany.SelectData <view_Company>(sqlSelect, sqlWhere).First();
ViewBag.WebCompID = company.CompID;
ViewBag.WebCompName = company.CompName;
ViewBag.CompCode = company.CompCode;
ViewBag.WebCompLevel = company.CompLevel;
ViewBag.WebLogoImgPath = company.LogoImgPath;
ViewBag.Template = company.CompWebsiteTemplate;
ViewBag.WebEmCompID = company.emCompID;
ViewBag.PageAction = page;
ViewBag.title = company.CompName + " | " + company.ProvinceName + " | " + res.Common.lblDomainShortName;
ViewBag.ViewCount = company.ViewCount;
ViewBag.WebCompHistory = company.CompHistory;
ViewBag.IsOnline = company.IsOnline;
ViewBag.MetaDescription = company.CompName + " | " + company.CompAddrLine1 + " | " + company.ProvinceName + " | " + company.CompPhone;
ViewBag.MetaKeyword = ViewBag.title;
ProductCount(ViewBag.WebCompID);
BlogCount(ViewBag.WebCompID);
if (ViewBag.WebCompLevel == 3)
{
OrderCount(ViewBag.WebCompID);
CertifyCount(ViewBag.WebCompID);
JobCount(ViewBag.WebEmCompID);
}
SetStatusWebsite((int)company.CompID, company.CompName);
var SettingMenu = svCompany.SelectData <b2bCompanyMenu>("*", "IsDelete = 0 and CompID = " + id, "ListNo ASC");
if (SettingMenu.Count == 0)
{
SettingMenu = svCompany.SelectData <b2bCompanyMenu>("*", "IsDelete = 0 and IsDefaultMenu = 1 and IsShow = 1", "ListNo ASC");
}
else
{
var where = "IsDelete = 0 and ([IsDefaultMenu] = 1 ";
foreach (var list in SettingMenu)
{
where += " or (FromMenuID = " + list.FromMenuID + " AND CompID = " + id + " AND IsShow = 1)";
}
where += ")";
foreach (var list in SettingMenu)
{
where += "AND CompMenuID != " + list.FromMenuID;
}
SettingMenu = svCompany.SelectData <b2bCompanyMenu>("*", where, "ListNo ASC");
}
ViewBag.SettingMenu = SettingMenu;
}
return(countcompany);
}
public ActionResult B2BToday()
{
var svProduct = new ProductService();
var svBuylead = new BuyleadService();
var svCompany = new CompanyService();
string CountProduct, Countsoftware, CountCentral, CountWest, CountNorth, CountNortheast, CountSouth, CountEast, CountSupplier = "";
var HomeCountProduct = "HomeCountProduct";
var HomeCountsoftware = "HomeCountsoftware";
var HomeCountCentral = "HomeCountCentral";
var HomeCountWest = "HomeCountWest";
var HomeCountNorth = "HomeCountNorth";
var HomeCountNortheast = "HomeCountNortheast";
var HomeCountSouth = "HomeCountSouth";
var HomeCountEast = "HomeCountEast";
var HomeCountSupplier = "HomeCountSupplier";
var sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
if (MemoryCache.Default[HomeCountProduct] != null)
{
CountProduct = (string)MemoryCache.Default[HomeCountProduct];
}
else
{
CountProduct = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountProduct != "" || CountProduct != null)
{
MemoryCache.Default.Add(HomeCountProduct, CountProduct, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountsoftware] != null)
{
Countsoftware = (string)MemoryCache.Default[HomeCountsoftware];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And CateLV1=7102";
Countsoftware = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (Countsoftware != "" || Countsoftware != null)
{
MemoryCache.Default.Add(HomeCountsoftware, Countsoftware, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountCentral] != null)
{
CountCentral = (string)MemoryCache.Default[HomeCountCentral];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=1";
CountCentral = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountCentral != "" || CountCentral != null)
{
MemoryCache.Default.Add(HomeCountCentral, CountCentral, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountWest] != null)
{
CountWest = (string)MemoryCache.Default[HomeCountWest];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=2";
CountWest = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountWest != "" || CountWest != null)
{
MemoryCache.Default.Add(HomeCountWest, CountWest, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountNorth] != null)
{
CountNorth = (string)MemoryCache.Default[HomeCountNorth];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=3";
CountNorth = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountNorth != "" || CountNorth != null)
{
MemoryCache.Default.Add(HomeCountNorth, CountNorth, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountNortheast] != null)
{
CountNortheast = (string)MemoryCache.Default[HomeCountNortheast];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=4";
CountNortheast = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountNortheast != "" || CountNortheast != null)
{
MemoryCache.Default.Add(HomeCountNortheast, CountNortheast, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountSouth] != null)
{
CountSouth = (string)MemoryCache.Default[HomeCountSouth];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=5";
CountSouth = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountSouth != "" || CountSouth != null)
{
MemoryCache.Default.Add(HomeCountSouth, CountSouth, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountEast] != null)
{
CountEast = (string)MemoryCache.Default[HomeCountEast];
}
else
{
sqlWhere = svProduct.CreateWhereAction(ProductAction.FrontEnd);
sqlWhere += " And RegionID=6";
CountEast = svProduct.CountData <view_SearchProduct>("ProductID", sqlWhere).ToString("#,##0");
if (CountEast != "" || CountEast != null)
{
MemoryCache.Default.Add(HomeCountEast, CountEast, DateTime.Now.AddHours(2));
}
}
if (MemoryCache.Default[HomeCountSupplier] != null)
{
CountSupplier = (string)MemoryCache.Default[HomeCountSupplier];
}
else
{
sqlWhere = svCompany.CreateWhereAction(CompStatus.HaveProduct);
sqlWhere += svCompany.CreateWhereServiceType(3);
CountSupplier = svCompany.CountData <b2bCompany>("CompID", sqlWhere).ToString("#,##0");
if (CountSupplier != "" || CountSupplier != null)
{
MemoryCache.Default.Add(HomeCountSupplier, CountSupplier, DateTime.Now.AddHours(2));
}
}
return(Json(new { ProductAll = CountProduct, SupplierAll = CountSupplier, SoftwareAll = Countsoftware, Central = CountCentral, West = CountWest, North = CountNorth, Northeast = CountNortheast, South = CountSouth, East = CountEast }));
}
public ActionResult Contact(int?ToCompID, string ProductID, string type, string BuyleadID)
{
if (RedirectToProduction())
{
return(Redirect(UrlProduction));
}
CommonService svCommon = new CommonService();
#region Company Info
if (ToCompID > 0)
{
svCompany = new CompanyService();
string sqlSelect = "CompID,CompName,ContactEmail,CompPhone";
string sqlWhere = svCompany.CreateWhereAction(CompStatus.Online, ToCompID);
var countcompany = svCompany.CountData <view_Company>(sqlSelect, sqlWhere);
if (countcompany > 0)
{
var company = svCompany.SelectData <view_Company>(sqlSelect, sqlWhere).First();
ViewBag.Company = company;
ViewBag.CompName = company.CompName;
}
else
{
return(Redirect("~/Default/NotFound"));
}
}
#endregion
#region Load Feature
var feature = new List <view_HotFeaProduct>();
if (MemoryCache.Default["LoadFeatureMessage"] != null)
{
feature = (List <view_HotFeaProduct>)MemoryCache.Default["LoadFeatureMessage"];
feature = feature.OrderBy(x => Guid.NewGuid()).ToList();
feature = feature.OrderByDescending(m => m.HotPrice).ToList();
}
else
{
var svHotFeat = new HotFeaProductService();
var SQLSelect_Feat = "";
SQLSelect_Feat = " ProductID,ProductName,CompID,ProductImgPath,ProRowFlag,CompRowFlag,ProvinceName,Price,Ispromotion,PromotionPrice,HotPrice";
feature = svHotFeat.SelectHotProduct <view_HotFeaProduct>(SQLSelect_Feat, "Rowflag = 3 AND Status = 'P' AND ProductID > 0 AND ProRowFlag in(4) AND CompRowFlag in(2,4) AND ProductDelete = 0", "NEWID(),HotPrice DESC", 1, 3);//""
if (svHotFeat.TotalRow > 0)
{
MemoryCache.Default.Add("LoadFeatureMessage", feature, DateTime.Now.AddMinutes(10));
}
}
ViewBag.FeatProducts = feature;
#endregion
#region Product
if (!string.IsNullOrEmpty(ProductID))
{
svProduct = new ProductService();
#region Set Cookie ProductID
Response.Cookies["MsgContactProID"].Value = ProductID;
Response.Cookies["MsgContactProID"].Expires = DateTime.Now.AddHours(1);
#endregion
string[] strProductID = ProductID.Split(',');
string WhereIN = CreateWhereIN(strProductID, "ProductID");
var product = svProduct.SelectData <b2bProduct>("ProductID,ProductName", WhereIN + " AND IsDelete = 0");
ViewBag.ProductID = product;
if (svProduct.TotalRow > 0)
{
ViewBag.Title = "ติดต่อผู้ขายสินค้า " + product.First().ProductName + ", " + ViewBag.CompName + " – B2Bthai.com";
ViewBag.PronameUrl = @Url.ReplaceUrl(product.First().ProductName);
}
ViewBag.chkProductID = 1;
}
else
{
ViewBag.chkProductID = 0;
ViewBag.Title = "ติดต่อบริษัท" + ViewBag.CompName + " – B2Bthai.com";
Response.Cookies["MsgContactProID"].Value = null;
Response.Cookies["MsgContactProID"].Expires = DateTime.Now.AddHours(1);
}
#endregion
#region Buylead
if (!string.IsNullOrEmpty(BuyleadID))
{
svBuylead = new BuyleadService();
#region Set Cookie ProductID
Response.Cookies["MsgContactBuyID"].Value = BuyleadID;
Response.Cookies["MsgContactBuyID"].Expires = DateTime.Now.AddHours(1);
#endregion
string[] strBuyleadID = BuyleadID.Split(',');
string WhereIN = CreateWhereIN(strBuyleadID, "BuyleadID");
var buylead = svBuylead.SelectData <b2bBuylead>("BuyleadID,BuyleadName,BuyleadEmail,BuyleadCompanyName", WhereIN + " AND IsDelete = 0");
ViewBag.BuyleadID = buylead;
if (svBuylead.TotalRow > 0)
{
ViewBag.Title = "ติดต่อผู้ประกาศซื้อสินค้า " + buylead.First().BuyleadName + ", " + buylead.First().BuyleadCompanyName + " – B2Bthai.com";
ViewBag.BuynameUrl = @Url.ReplaceUrl(buylead.First().BuyleadName);
}
ViewBag.chkBuyleadID = 1;
}
else
{
ViewBag.chkBuyleadID = 0;
ViewBag.Title = "ติดต่อบริษัท" + ViewBag.CompName + " – B2Bthai.com";
Response.Cookies["MsgContactBuyID"].Value = null;
Response.Cookies["MsgContactBuyID"].Expires = DateTime.Now.AddHours(1);
}
#endregion
#region check message type
if (type == "SendtoFriend")
{
ViewBag.chkSendToFriend = 1;
ViewBag.Title = "ส่งรายละเอียดให้เพื่อน " + ViewBag.CompName + " – B2Bthai.com";
}
else
{
ViewBag.chkSendToFriend = 0;
}
#endregion
ViewBag.EnumServiceType = svCommon.SelectEnum(CommonService.EnumType.SearchByServiceType);
GetStatusUser();
ViewBag.MetaKeyword = ViewBag.Title;
ViewBag.MetaDescription = ViewBag.Title;
return(View());
}