public IQueryable <tbl_newscomments> getreplynewscomments(int id = 0, int id01 = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_newscomments.Where(a => (a.newsid == id && a.parentid == id01 && a.comfirmation == true)).OrderByDescending(a => a.id);
return(q);
}
public IQueryable <tbl_news> getslides(int i = 0, int j = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_news.Where(a => a.confirmation == true).OrderByDescending(a => a.id).Skip(j).Take(i);
return(q);
}
public IQueryable <tbl_newstype> getnewstype()
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_newstype;
return(q);
}
public IQueryable <tbl_news> getnewsbasedtype(int i = 0, int j = 0, int k = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_news.Where(a => (a.confirmation == true && a.newtypeid == k)).OrderByDescending(a => a.id).Skip(j).Take(i);
return(q);
}
public int getentityitem(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = from b in db.tbl_listkala97
group b by b.productid into g
select new
{
productid = g.Key,
Totalentity = g.Sum(item => item.kalanumberm),
};
var a = q.Where(k => k.productid == id).SingleOrDefault();
if (a != null)
{
int h = (int)a.Totalentity;
return(h);
}
else
{
int h = 0;
return(h);
}
}
public virtual tbl_ftp getftp(int id)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_ftp.Where(a => a.id == id).SingleOrDefault();
return(q);
}
public IQueryable <tbl_newsimagefiles> getnewsimagefile()
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = db.tbl_newsimagefiles.OrderByDescending(a => a.id);
return(q);
}
public IQueryable <tbl_listkala97> getlastsellrecord(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var lastrecord = db.tbl_listkala97.Where(a => a.productid == id && a.htype == -1).OrderByDescending(a => a.sodoordate);
return(lastrecord);
}
public virtual tbl_listkala getlastbuyrecord(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var lastrecord = db.tbl_listkala97.Where(a => a.productid == id && a.htype == 1).Count() == 0 ? null : db.tbl_listkala.Where(a => a.productid == id && a.htype == 1).OrderByDescending(a => a.sodoordate).FirstOrDefault();
return(lastrecord);
}
public int numberbuy(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var number = db.tbl_listkala97.Where(a => a.productid == id && a.htype == 1).Count();
return(number);
}
public string getlastbuydate(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var lastbuydate = db.tbl_listkala97.Where(a => a.productid == id && a.htype == 1).Count() == 0 ? "" : db.tbl_listkala.Where(a => a.productid == id && a.htype == 1).OrderByDescending(a => a.sodoordate).FirstOrDefault().sodoordate.ToPersianDate();
return(lastbuydate);
}
public string getlastselldesc(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var lastselldesc = db.tbl_listkala97.Where(a => a.productid == id && a.htype == -1).Count() == 0 ? "" : db.tbl_listkala.Where(a => a.productid == id && a.htype == -1).OrderByDescending(a => a.sodoordate).FirstOrDefault().kaladescription;
return(lastselldesc);
}
public decimal getlastsellprice(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
decimal lastsellprice = db.tbl_listkala97.Where(a => a.productid == id && a.htype == -1).Count() == 0 ? 0 : db.tbl_listkala.Where(a => a.productid == id && a.htype == -1).OrderByDescending(a => a.sodoordate).FirstOrDefault().kalacost;
return(lastsellprice);
}
public IQueryable <tbl_products> getproducts(string s = "")
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = from a in db.tbl_products
where (a.name.Contains(s) || a.codename.Contains(s))
select a;
return(q);
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
if (filterContext.HttpContext.Session.GetInt32("userid") == null)
{
if (filterContext.HttpContext.Request.Cookies["userid"] != null)
{
filterContext.HttpContext.Session.SetString("username", filterContext.HttpContext.Request.Cookies["username"]);
filterContext.HttpContext.Session.SetInt32("userid", int.Parse(filterContext.HttpContext.Request.Cookies["userid"]));
int userid = filterContext.HttpContext.Session.GetInt32("userid").Value;
string fname = db.tbl_user.Where(a => a.id == userid).SingleOrDefault().name;
string lname = db.tbl_user.Where(a => a.id == userid).SingleOrDefault().Lname;
string fullname = fname + " " + lname;
filterContext.HttpContext.Session.SetString("fullname", fullname);
}
}
//
int usernameid = 0;
string action = filterContext.RouteData.Values["Action"].ToString();
string controller = filterContext.RouteData.Values["Controller"].ToString();
bool? permission = null;
if (filterContext.HttpContext.Session.GetInt32("userid") != null)
{
usernameid = filterContext.HttpContext.Session.GetInt32("userid").Value;
var q = db.tbl_actionaccessibility.Where(a => a.acction_.action_name.ToLower() == action.ToLower() && a.acction_.controller_.controller_name.ToLower() == (controller.ToLower() + "controller").ToLower() && a.userid == usernameid).FirstOrDefault();
if (q != null)
{
int idd = q.id;
permission = q.permission;
}
else
{
permission = false;
}
}
if (permission == null)
{
filterContext.Result = new ViewResult
{
ViewName = "~/Views/Home/login.cshtml",
};
}
else if (permission == false)
{
filterContext.Result = new ViewResult
{
ViewName = "~/Views/Home/AccessIsDenied.cshtml",
};
}
}
public IQueryable <tbl_sample> getsample(int ID = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = from a in db.tbl_sample
where a.idcategory == ID
select a;
//var w = q.FirstOrDefault().tbl_category.categoryname;
return(q);
}
public static bool thisuserallowtodo(int userid = 0, int accessid = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var record = db.tbl_accesslevels.Where(a => a.accessid == accessid && a.userid == userid && a.accessvalue == true);
if (record.Count() > 0)
{
return(true);
}
else
{
return(false);
}
}
public string getexistproducts(int id = 0)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = from b in db.tbl_listkala97
group b by b.productid into g
select new
{
productid = g.Key,
Totalentity = g.Sum(item => item.kalanumberm),
};
var kalaq = db.tbl_products.Where(l => l.idproduct == id).SingleOrDefault();
var a = q.Where(k => k.productid == id).SingleOrDefault();
if (a != null)
{
int h = (int)a.Totalentity;
if (h >= kalaq.inventory)
{
return("موجود");
}
else if (h < kalaq.inventory && h > 0)
{
return("محدود");
}
else if (h == 0)
{
return("به زودی ");
}
else if (h < 0)
{
return("موجودی منفی");
}
else
{
return("نا مشخص");
}
}
else
{
return("موجود نیست");
}
}
public IQueryable <tbl_sample> getsamplerandom()
{
Random rnd = new Random();
int b = rnd.Next(1, getsample().Count());
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var q = from a in db.tbl_sample
where a.idsample.Equals(b)
select a;
return(q);
}
public static bool statisticssave(string controller, string action, string ip, Nullable <int> userid)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
tbl_statistics t = new tbl_statistics();
t.actionname = action;
t.controllername = controller;
t.enterdate = DateTime.Now;
t.ip = ip;
if (userid != null)
{
t.user_id = userid;
}
db.tbl_statistics.Add(t);
db.SaveChanges();
return(true);
}
public IQueryable getentity()
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
//var q = db.tbl_news.Where(a => a.confirmation == true).OrderByDescending(a => a.id).Skip(j).Take(i);
var q = (from b in db.tbl_listkala97
group b by b.productid into g
select new
{
productid = g.Key,
Totalentity = g.Sum(item => item.kalanumberm),
});
return(q);
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
//
int usernameid = 0;
string action = filterContext.RouteData.Values["Action"].ToString();
string controller = filterContext.RouteData.Values["Controller"].ToString();
bool? permission = null;
if (filterContext.HttpContext.User.Identity.IsAuthenticated)
{
//usernameid = filterContext.HttpContext.Session.GetInt32("userid").Value;
usernameid = int.Parse(filterContext.HttpContext.User.Claims.FirstOrDefault().Value);
var q = db.tbl_actionaccessibility.Where(a => a.acction_.action_name.ToLower() == action.ToLower() && a.acction_.controller_.controller_name.ToLower() == (controller.ToLower() + "controller").ToLower() && a.userid == usernameid).FirstOrDefault();
if (q != null)
{
int idd = q.id;
permission = q.permission;
}
else
{
permission = false;
}
}
if (permission == null)
{
filterContext.Result = new ViewResult
{
ViewName = "~/Views/Home/AccessIsDenied.cshtml",
};
}
else if (permission == false)
{
filterContext.Result = new ViewResult
{
ViewName = "~/Views/Home/AccessIsDenied.cshtml",
};
}
}
public virtual tbl_files getsamplesrandom(int decortype = 0)
{
Random rnd = new Random();
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
var qcabinet = db.tbl_files.Where(a => a.decortypeid == decortype);
int countsample = qcabinet.Count();
int row = rnd.Next(1, countsample);
if (countsample > 1)
{
var q = qcabinet.OrderBy(a => a.id).Skip(row).Take(1).SingleOrDefault();
return(q);
}
else
{
var q = qcabinet.SingleOrDefault();
return(q);
}
}
public sliderepository(_4820_soltaniwebContext db)
{
this.db = db;
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
_4820_soltaniwebContext db = new _4820_soltaniwebContext();
if (filterContext.HttpContext.Session.GetInt32("userid") == null)
{
if (filterContext.HttpContext.Request.Cookies["userid"] != null)
{
filterContext.HttpContext.Session.SetString("username", filterContext.HttpContext.Request.Cookies["username"]);
filterContext.HttpContext.Session.SetInt32("userid", int.Parse(filterContext.HttpContext.Request.Cookies["userid"]));
int userid = filterContext.HttpContext.Session.GetInt32("userid").Value;
string fname = db.tbl_user.Where(a => a.id == userid).SingleOrDefault().name;
string lname = db.tbl_user.Where(a => a.id == userid).SingleOrDefault().Lname;
string fullname = fname + " " + lname;
filterContext.HttpContext.Session.SetString("fullname", fullname);
}
}
tbl_statistics t = new tbl_statistics();
//t.actionname = (string)routingValues["action"];
t.actionname = filterContext.RouteData.Values["Action"].ToString();
t.controllername = filterContext.RouteData.Values["Controller"].ToString();
t.enterdate = DateTime.Now;
t.ip = filterContext.HttpContext.Connection.RemoteIpAddress.ToString();
if (filterContext.HttpContext.Session.GetInt32("userid") == null)
{
t.user_id = null;
}
else
{
t.user_id = filterContext.HttpContext.Session.GetInt32("userid");
}
//var myparams = filterContext.ActionParameters;
var myparams = filterContext.ActionArguments;
string parameters = "";
int x = 0;
int count = 0;
count = myparams.Count();
foreach (var item in myparams)
{
if (count == 1 || x == count - 1)
{
if (item.Value == null)
{
parameters = parameters + item.Key + "=null";
}
else
{
parameters = parameters + item.Key + "=" + item.Value.ToString();
}
}
else
{
if (item.Value == null)
{
parameters = parameters + item.Key + "=null" + "&";
}
else
{
parameters = parameters + item.Key + "=" + item.Value.ToString() + "&";
}
}
x += 1;
}
t.parameter = parameters;
t.fullurl = "www.soltaniwoodproducts.com/" + t.controllername + "/" + t.actionname + "?" + parameters;
db.tbl_statistics.Add(t);
db.SaveChanges();
}
