public static bool IsHasStock(product_typedetail pTD, int num, DateTime startday, DateTime endday)
{
int days = new TimeSpan(endday.Ticks - startday.Ticks).Days;
for (int i = 0; i < days; i++)
{
DateTime tmpDay = startday.AddDays(i);
if (!pTD.product_typedetail_everydaystock.Any(s => s.stock_date == tmpDay && s.stock >= num))
{
return(false);
}
}
return(true);
}
public ActionResult Edit(int id)
{
using (dbcon db = new dbcon())
{
var ptype_models = db.product_typedetail.Where(p => p.rowid == id).FirstOrDefault();
if (ptype_models == null)
{
product_typedetail new_model = new product_typedetail();
return(View(new_model));
}
var models = db.product_typedetail.Where(m => m.ptype_no == ptype_models.ptype_no).FirstOrDefault();
return(View(models));
}
}
public ActionResult Pdescription(product_typedetail product_Typedetail)
{
bool status = false;
using (dbcon db = new dbcon())
{
var model = db.product_typedetail.Where(m => m.rowid == product_Typedetail.rowid).FirstOrDefault();
if (model != null)
{
model.ptype_dep = product_Typedetail.ptype_dep;
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public ActionResult Edit(product_typedetail models)
{
bool status = false;
if (ModelState.IsValid)
{
using (dbcon db = new dbcon())
{
if (models.rowid > 0)
{
//Edit
var product_typedetail = db.product_typedetail.Where(m => m.ptype_no == models.ptype_no).FirstOrDefault();
if (product_typedetail != null)
{
product_typedetail.pno = Shop.Pno;
product_typedetail.parea_name = models.parea_name;
product_typedetail.ptype_no = models.ptype_no;
product_typedetail.ptype_name = models.ptype_name;
product_typedetail.ptype_price = models.ptype_price;
product_typedetail.remark = models.remark;
}
}
else
{
//Save
models.pno = Shop.Pno;
db.product_typedetail.Add(models);
}
db.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public static string GetProductTypeDetailImpPath(product_typedetail ptd)
{
return("../../Content/images/product/" + ptd.pno + "/product_type_detail/" + ptd.ptype_no + "/" + ptd.ptype_no + ".jpg");
}
