public IActionResult Edit(Guid?id, web_db._Weighing.TblContractType.KindCotractTypeEnum?kindcontract = null)
{
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 == id);
if (x == null)
{
try
{
x = new web_CusDB.tblReqContract()
{
KindContract = kindcontract.Value
};
}
catch
{
return(RedirectToAction(nameof(List)));
}
}
else
{
x._LasttblReqContractRows = x.tblReqContractRows.OrderByDescending(a => a.Date).First();
x._Contract = db.TblContracts.Find(x.ContractId);
}
return(View(x));
}
public IActionResult SyncCusSystem()
{
{
using (var dbCus = new web_CusDB.db_Context())
{
using (var db = new web_db.sardweb_Context())
{
long code = (dbCus.tblReqContracts.Max(a => (long?)a.Code) ?? 0);
foreach (var item in db.TblQueus.Where(a => (a.KindQueu == web_db._queu.TblQueu.QueuEnum.Save) || (a.KindQueu == web_db._queu.TblQueu.QueuEnum.IsActive)).Take(100))
{
code++;
var con = dbCus.tblReqContracts.Find(item.Id);
if (con == null)
{
var cus = dbCus.TblCustomers.SingleOrDefault(a => a.Mob == item.mob && a.CodeMelli == item.codemeli);
if (cus == null)
{
cus = new web_CusDB.tblCus
{
CodeMelli = item.codemeli,
dateAdd = item.date,
Addras = item.Addras,
Id = Guid.NewGuid(),
Mob = item.mob,
Name = item.Name,
};
dbCus.TblCustomers.Add(cus);
}
con = new web_CusDB.tblReqContract
{
Code = (code),
DateAdd = item.date,
ContractId = item.ContractID,
KindContract = web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane,
Id = item.Id,
IsEdit = false,
tblCusId = cus.Id,
DateLast = DateTime.Now,
};
dbCus.tblReqContracts.Add(con);
dbCus.tblReqContractRows.Add(new web_CusDB.tblReqContractRow
{
CodeMahsuls = item.CodeMahsuls,
Date = item.date,
Id = Guid.NewGuid(),
Vaziat = web_CusDB.tblReqContractRow.ResEnum.Save,
WeightCount = item.Weight ?? 0,
TblReqContractId = con.Id,
Mahsuls = item.Mahsuls,
});
// db.Remove(item);
}
}
db.SaveChanges();
dbCus.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
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());
}
