public IActionResult Confirm(Guid id, web_CusDB.tblReqContractRow.ResEnum kind)
{
var dbcus = new web_CusDB.db_Context();
var db = new web_db.sardweb_Context();
ViewBag.kind = kind;
var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows).Include(a => a.tblCus).SingleOrDefault(a => a.Id == id);
x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First();
ViewBag.ash = web_CusDB.tblCus.checkCodeCusMain(x.tblCus);
// var x = db.TblQueus.Find(id);
// if ((x.WeightConfirm??0)==0)
// {
// x.WeightConfirm = x.Weight;
// }
//var shname= _mySettings.GetValue<string>("txtPortagesms");
ViewBag.Txtsms = @$ "وضعیت درخواست شما به ({kind.ToKPvalusAttr().Description}) تغییر کرد.
کد درخواست: {x.Code}
";
return(View(x._LasttblReqContractRows));
}
public IActionResult Confirm(web_CusDB.tblReqContractRow model, bool sms,
string Txtsms, Guid[] mahsulss, web_CusDB.tblReqContractRow.ResEnum kind)
{
var dbcus = new web_CusDB.db_Context();
var db = new web_db.sardweb_Context();
var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows)
.Include(a => a.tblCus).SingleOrDefault(a => a.Id == model.Id);
x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First();
var z = db.TblProducts.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList();
z.AddRange(db.TblPackings.Where(a => mahsulss.Contains(a.Id)).Select(a => a.Title).ToList());
model.CodeMahsuls = mahsulss.ToJson();
model.Mahsuls = string.Join(',', z);
dbcus.tblReqContractRows.Add(new web_CusDB.tblReqContractRow
{
Id = Guid.NewGuid(),
CodeMahsuls = model.CodeMahsuls,
Mahsuls = model.Mahsuls,
Date = DateTime.Now,
ResDate = DateTime.Now,
ResTxt = model.ResTxt,
ResUserId = User._getuserid(),
TblReqContractId = x.Id,
Vaziat = kind,
WeightCount = model.WeightCount
});
//var row = db.tbl.Find(id);
//row.WeightConfirm = WeightConfirm;
//row.KindQueu = kind;
//row.TxtReq = TxtReq;
if (sms && Txtsms.IsEmpty() == false && Txtsms.Length > 5)
{
Models.cl._listSmsForSend.Add(new Models.cl.SmsForSend
{
number = x.tblCus.Mob,
txt = Txtsms
});
}
dbcus.SaveChanges();
return(RedirectToAction(nameof(List)));
}
public IActionResult List(web_db._Weighing.TblContractType.KindCotractTypeEnum kindcontract = web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, web_CusDB.tblReqContractRow.ResEnum id = web_CusDB.tblReqContractRow.ResEnum.Save)
{
ViewBag.kindcontract = kindcontract;
ViewBag.id = id;
var dbcus = new web_CusDB.db_Context();
{
var xx = dbcus.tblReqContracts.Include(s => s.tblReqContractRows).Where(a => a.tblReqContractRows.Any() == false);
if (xx.Any())
{
dbcus.tblReqContracts.RemoveRange(xx);
dbcus.SaveChanges();
}
}
var x = dbcus.tblReqContracts.Include(a => a.tblReqContractRows).OrderBy(a => a.DateLast).Include(a => a.tblCus)
.Where(a => a.KindContract == kindcontract && a.tblReqContractRows.
OrderByDescending(s => s.Date).First().Vaziat == id).ToList();
foreach (var item in x)
{
item._LasttblReqContractRows = item.tblReqContractRows.OrderByDescending(a => a.Date).First();
}
return(View(x));
}
