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)); }