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 New(web_db._Weighing.TblContractType.KindCotractTypeEnum?Kind = null)
{
ViewBag.Kind = Kind;
var row = new web_CusDB.tblReqContractRow();
var dbweb = new web_db.sardweb_Context();
if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)
{
ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) && a.IsActive == true)
.OrderBy(a => a.Code).ToList();
}
else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) && a.IsActive == true)
.OrderBy(a => a.Code).ToList();
}
ViewBag.listProduct = dbweb.TblProducts.Where(a => a.IsActive).OrderBy(a => a.Ord).ToList();
ViewBag.US_WeightMax = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMax) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightMin = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMin) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightVahed = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightVahed) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value;
var Kinds = dbweb.TblContractTypes.Where(a => a.FkSalmali == dbweb.TblSalMalis.SingleOrDefault(a => a.IsOpen && a.IsOrginal).Id).Select(a => a.KindCotractType).Distinct().ToList();
Kinds.Remove(web_db._Weighing.TblContractType.KindCotractTypeEnum.ABaskul);
ViewBag.kinds = Kinds;
return(View(row));
}
public IActionResult New(web_db._Weighing.TblContractType.KindCotractTypeEnum Kind, web_CusDB.tblReqContractRow model, List <Guid> Product, List <Guid> Packing)
{
var dbweb = new web_db.sardweb_Context();
if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)
{
if (!Product.Any())
{
ModelState.AddModelError("CodeMahsuls", "محصولات انتخاب نشده است");
}
if (!Packing.Any())
{
ModelState.AddModelError("CodeMahsuls", "سبد انتخاب نشده است");
}
}
else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
if (!Packing.Any())
{
ModelState.AddModelError("CodeMahsuls", "سبد انتخاب نشده است");
}
}
if (model.WeightCount < 10)
{
ModelState.AddModelError("WeightCount", "مقدار اشتباه است");
}
if (ModelState.IsValid)
{
var db = new web_CusDB.db_Context();
var row = new web_CusDB.tblReqContract {
Code = (db.tblReqContracts.Max(a => (long?)a.Code) ?? 0) + 1,
DateAdd = DateTime.Now,
DateLast = DateTime.Now,
Id = Guid.NewGuid(),
KindContract = Kind,
tblCusId = User._getuserId().Value,
};
db.tblReqContracts.Add(row);
var p = new List <Guid>();
p.AddRange(Product);
p.AddRange(Packing);
var z = dbweb.TblProducts.Where(a => Product.Contains(a.Id)).Select(a => a.Title).ToList();
z.AddRange(dbweb.TblPackings.Where(a => Packing.Contains(a.Id)).Select(a => a.Title).ToList());
db.tblReqContractRows.Add(new web_CusDB.tblReqContractRow {
CodeMahsuls = p.ToJson(),
Date = row.DateLast,
Id = Guid.NewGuid(),
Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save,
WeightCount = model.WeightCount,
TblReqContractId = row.Id,
Mahsuls = string.Join(',', z)
});
db.SaveChanges();
var dbmain = new web_db.sardweb_Context();
sms sms = new sms()
{
numfrom = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_NumSms).Value,
password = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_PassSms).Value,
username = dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_UserSms).Value,
};
var us = db.TblCustomers.Find(User._getuserId().Value);
sms.sendsmsAsync(us.Mob, (dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_SherkatName) ?? new web_db.TblConf()).Value + @$ "
درخواست شما با کد " + row.Code.ToString() + " ثبت گردید");
return(RedirectToAction("Index"));
}
if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)
{
ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane) && a.IsActive == true)
.OrderBy(a => a.Code).ToList();
}
else if (Kind == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
ViewBag.listPacking = dbweb.TblPackings.AsEnumerable().Where(a => a.ForContractType().Contains(web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad) && a.IsActive == true)
.OrderBy(a => a.Code).ToList();
}
ViewBag.listProduct = dbweb.TblProducts.Where(a => a.IsActive).OrderBy(a => a.Ord).ToList();
ViewBag.US_WeightMax = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMax) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightMin = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightMin) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightVahed = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightVahed) ?? new web_db.TblConf()).Value;
ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value;
ViewBag.Kind = Kind;
var Kinds = dbweb.TblContractTypes.Where(a => a.FkSalmali == dbweb.TblSalMalis.SingleOrDefault(a => a.IsOpen && a.IsOrginal).Id).Select(a => a.KindCotractType).Distinct().ToList();
Kinds.Remove(web_db._Weighing.TblContractType.KindCotractTypeEnum.ABaskul);
ViewBag.kinds = Kinds;
return(View(model));
}
public IActionResult Edit(web_CusDB.tblReqContract model, Guid[] mahsulss)
{
var dbcus = new web_CusDB.db_Context();
var db = new web_db.sardweb_Context();
if (ModelState.IsValid)
{
var row = dbcus.tblReqContracts.Find(model.Id);
var rowcus = dbcus.TblCustomers.SingleOrDefault(a => model.tblCus.CodeMelli == a.CodeMelli);
{ if (rowcus == null)
{
if (row != null)
{
rowcus = dbcus.TblCustomers.Find(row.tblCusId);
}
else
{
rowcus = new web_CusDB.tblCus {
Id = Guid.NewGuid(), dateAdd = DateTime.Now
};
dbcus.TblCustomers.Add(rowcus);
}
}
rowcus.CodeMelli = model.tblCus.CodeMelli;
rowcus.Addras = model.tblCus.Addras;
rowcus.Mob = model.tblCus.Mob;
rowcus.Name = model.tblCus.Name; }
if (row == null)
{
row = new web_CusDB.tblReqContract
{
Id = Guid.NewGuid(),
Code = (dbcus.tblReqContracts.Max(a => (long?)a.Code) ?? 0) + 1,
DateAdd = DateTime.Now,
KindContract = model.KindContract,
};
dbcus.tblReqContracts.Add(row);
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._LasttblReqContractRows.CodeMahsuls = mahsulss.ToJson();
model._LasttblReqContractRows.Mahsuls = string.Join(',', z);
var rowrow = new web_CusDB.tblReqContractRow {
Id = Guid.NewGuid(),
CodeMahsuls = model._LasttblReqContractRows.CodeMahsuls,
Mahsuls = model._LasttblReqContractRows.Mahsuls,
Date = DateTime.Now,
Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save,
WeightCount = model._LasttblReqContractRows.WeightCount,
ResUserId = User._getuserid(),
TblReqContractId = row.Id
};
dbcus.tblReqContractRows.Add(rowrow);
}
row.tblCusId = rowcus.Id;
// 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());
// row.Addras = model.Addras;
// row.Mahsuls = string.Join(',', z);
// row.Weight = model.Weight;
// row.codemeli = model.codemeli;
// row.KindQueu = web_db._queu.TblQueu.QueuEnum.Save;
// row.CodeMahsuls = model.CodeMahsuls;
// row.Name = model.Name;
// row.Txt = model.Txt;
dbcus.SaveChanges();
return(RedirectToAction(nameof(List)));
}
return(View());
}
