public void LoadRandomCompany()
{
var svCompany = new CompanyService();
var sqlWhere = "IsDelete = 0 AND (( CompRowFlag IN (2,4) ) AND ProductCount > 0 ) AND LogoImgPath != '' AND CompLevel = 3 AND CompImgPath != ''";
var data = new List <view_CompMember>();
var comp = new view_CompMember();
if (MemoryCache.Default["CompMember"] != null)
{
data = (List <view_CompMember>)MemoryCache.Default["CompMember"];
var rand = new Random();
comp = data[rand.Next(data.Count)];
}
else
{
data = svCompany.SelectData <view_CompMember>(
@" CompID,CompName,LogoImgPath,CompLevel,CompPhone,ProductCount,
ContactFirstName,ContactLastName,BizTypeID,BizTypeName,BizTypeOther,ProvinceName",
sqlWhere,
" NEWID()", 1, 10);
if (data != null && svCompany.TotalRow > 0)
{
MemoryCache.Default.Add("CompMember", data, DateTime.Now.AddHours(4));
var rand = new Random();
comp = data[rand.Next(data.Count)];
}
;
}
ViewBag.Company = comp;
}
public ActionResult productowner(int productid)
{
EncryptManager encrypt = new EncryptManager();
var svProduct = new ProductService();
var svMember = new MemberService();
var product = svProduct.SelectData <b2bProduct>(" * ", "productid = " + productid);
if (product != null && product.Count > 0)
{
var comp = svMember.SelectData <view_CompMember>(" * ", " compid = " + product[0].CompID);
var model = new view_CompMember();
model = comp[0];
model.Password = encrypt.DecryptData(comp[0].Password);
return(Json(new {
productid = product[0].ProductID,
productname = product[0].ProductName,
compid = model.CompID,
memberid = model.MemberID,
name = model.CompName,
email = model.Email,
user = model.UserName,
password = model.Password
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { compid = 0, memberid = 0, name = "", email = "", password = "" }, JsonRequestBehavior.AllowGet));
}
}
public view_CompMember GetCompMemberByCompID(int CompID)
{
var comp = new view_CompMember();
var data = SelectData <view_CompMember>(" * ", "CompID = " + CompID);
if (data != null && TotalRow > 0)
{
comp = data.First();
EncryptManager encrypt = new EncryptManager();
comp.Password = encrypt.DecryptData(comp.Password);
}
return(comp);
}
public ActionResult checkpassword(int compid)
{
EncryptManager encrypt = new EncryptManager();
var svMember = new MemberService();
var data = svMember.SelectData <view_CompMember>("MemberID,UserName,Password,CompName,Email,CompID", "CompID = " + compid, null);
if (data != null && data.Count > 0)
{
var model = new view_CompMember();
model = data[0];
model.Password = encrypt.DecryptData(data[0].Password);
return(Json(new {
compid = model.CompID,
memberid = model.MemberID,
name = model.CompName,
email = model.Email,
user = model.UserName,
password = model.Password
}, JsonRequestBehavior.AllowGet));
}
return(Json(new { compid = 0, memberid = 0, name = "", email = "", password = "" }, JsonRequestBehavior.AllowGet));
}
