public static bool IsPermitOK(web_db._Weighing.TblPortage por, web_db.sardweb_Context db)
{
if (por.KindCode == (int)portage.kindPortage.kindPortageEnum.In)
{
long? countForIn;
decimal?weightForIn;
cl.GetMojavez(por.FkCustomer, por.FkContracttype, db, true, out countForIn, out weightForIn);
countForIn -= por.PackingCount;
weightForIn -= por.WeightNet;
if (countForIn < 0 || weightForIn < 0)
{
return(false);
}
}
if (por.KindCode == (int)portage.kindPortage.kindPortageEnum.Out)
{
long? countForOut;
decimal?weightForOut;
cl.GetMojavez(por.FkCustomer, por.FkContracttype, db, false, out countForOut, out weightForOut);
countForOut += por.PackingCount;
weightForOut += por.WeightNet;
if (countForOut < 0 || weightForOut < 0)
{
return(false);
}
}
return(true);
}
public store(web_db._Weighing.TblStoreLog n, web_db.sardweb_Context db)
{
var contract = db.TblContracts.Find(n.FkContract) ?? new web_db._Weighing.TblContract();
var contracttype = db.TblContractTypes.Find(n.FkContractType);
var loc3 = db.TblLocations.SingleOrDefault(z => z.Id == n.FkLocation3);
var loc2 = db.TblLocations.SingleOrDefault(z => z.Id == n.FkLocation2);
var loc1 = db.TblLocations.SingleOrDefault(z => z.Id == n.FkLocation1);
this.id = n.Id;
this.fklocation1 = n.FkLocation1;
this.fklocation2 = n.FkLocation2;
this.fklocation3 = n.FkLocation3;
this.fkcontract = n.FkContract;
this.fkPacking = n.FkPacking;
this.fkProdoct = n.FkProduct;
this.count = n.Count;
this.Weight = n.Weight;
this.countin = n.CountIn;
this.Weightin = n.WeightIn;
this.countout = n.CountOut;
this.Weightout = n.WeightOut;
this.location = (loc3 ?? loc2 ?? loc1 ?? new web_db._Weighing.TblLocation()).CodeFull;
this.contracttype = contracttype.Title;
this.customer = (db.TblCustomers.Find(contract.FkCustomer) ?? new web_db.TblCustomer()).Title;
this.contract = contract.Code;
this.Packing = (db.TblPackings.SingleOrDefault(z => z.Id == n.FkPacking) ?? new web_db._Weighing.TblPacking()).Title;
this.Prodoct = (db.TblProducts.SingleOrDefault(z => z.Id == n.FkProduct) ?? new web_db._Weighing.TblProduct()).Title;
}
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 Rows(web_db._Weighing.TblPortageRow row, web_db.sardweb_Context db)
{
var por = db.TblPortages.Find(row.FkPortage);
var con = db.TblContracts.Find(row.FkContract) ?? new web_db._Weighing.TblContract();
var contype = db.TblContractTypes.Find(por.FkContracttype);
var cus = db.TblCustomers.Find(row.FkPortageNavigation.FkCustomer) ?? new web_db.TblCustomer();
Contract = cus.Title;
Contractcode = con.Code;
ContractType = contype.Title;
ContractTypecode = contype.Code;
Count = row.Count;
date = por.Date1;
datestr = por.Date1.ToPersianDate();
IdPort = row.FkPortage;
IdRow = row.Id;
Location = row.CodeLocation;
Packing = row.FkPacking.HasValue ? (web_sard.Models.cl._ListPacking.Single(a => a.Id == row.FkPacking).Title) : "";
Product = row.FkProduct.HasValue ? (web_sard.Models.cl._ListProduct.Single(a => a.Id == row.FkProduct).Title) : "";
UserAdd = db.TblUsers.Find(row.FkUser).Title;
Weight = row.WeightOne ?? 0;
Portagekindcode = por.KindCode;
Portagekindstr = por.KindTitle;
residcode = por.Code;
Car = por.CarMashin + " " + por.CarShMashin + " (" + por.CarRanande + por.CarTell + ")";
}
public IActionResult contractAc(Guid id)
{
var db = new web_db.sardweb_Context();
var kiloview = true; // Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString());
var x = from n in db.TblPortageRows.Include(a => a.FkContractNavigation).Include(a => a.TblPortageRowInjuries).ThenInclude(a => a.FkInjuryNavigation) //.ThenInclude(a=>a.FkCustomerNavigation)
where n.FkContract == id
orderby n.Date descending
select
new web_sard.Models.tbls.portage.store
{
date = n.Date,
contract = n.FkContractNavigation.Code,
// contracttype=n.FkContractNavigation.contr
count = n.Count,
countin = n.Count > 0 ? (long?)n.Count : null,
countout = n.Count < 0 ? (long?)n.Count : null,
// customer=n.FkContractNavigation.FkCustomerNavigation.Title,
fklocation1 = n.FkLocation1,
fklocation2 = n.FkLocation2,
fklocation3 = n.FkLocation3,
fkPacking = n.FkPacking,
fkProdoct = n.FkProduct,
location = n.CodeLocation,
Packing = (db.TblPackings.SingleOrDefault(a => a.Id == n.FkPacking) ?? new web_db._Weighing.TblPacking()).Title,
Prodoct = (db.TblProducts.SingleOrDefault(a => a.Id == n.FkProduct) ?? new web_db._Weighing.TblProduct()).Title,
Weight = kiloview ? ((decimal?)n.WeightOne * n.Count) : null,
Weightin = kiloview ? (n.Count > 0 ? ((decimal?)n.WeightOne * n.Count) : null) : null,
Weightout = kiloview ? (n.Count < 0 ? ((decimal?)n.WeightOne * n.Count) : null) : null,
txt = string.Join(",", n.TblPortageRowInjuries.Select(a => a.FkInjuryNavigation.Title)) + " " + n.Txt
};
return(View(x.AsEnumerable()));
}
public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db)
{
var portage = db.TblPortages.Find(id);
var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype);
#region rem PortageRows
foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id))
{
db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id));
db.TblPortageRows.Remove(item);
}
#endregion
#region rem images
var dbdoc = new web_dbDocument.db_Context();
dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id));
db.TblPortages.Remove(portage);
#endregion
db.SaveChanges();
dbdoc.SaveChanges();
return(true);
}
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 SyncDoc()
{
{
using (var dbdoc = new web_dbDocument.db_Context())
{
using (var db = new web_db.sardweb_Context())
{
foreach (var item in db.TblDocuments.Take(100))
{
dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument
{
Date = item.Date,
FkP = item.FkP,
FkPortage = item.FkPortage,
fkuser = item.fkuser,
Format = item.Format,
Id = item.Id,
Image = item.Image,
Kind = item.Kind
});
db.Remove(item);
}
db.SaveChanges();
dbdoc.SaveChanges();
}
}
}
return(RedirectToAction("Index"));
}
public static void GetMojavez(Guid custumer, Guid contracttype, web_db.sardweb_Context db, bool inn, out long?countFor, out decimal?weightFor)
{
var x = db.TblContracts.Where(a => a.FkCustomer == custumer && a.FkContractType == contracttype);
var contype = db.TblContractTypes.Find(contracttype);
if (contype.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
var conf = contype.ConfigASabad();
if (inn)
{
countFor = (x.Sum(a => a.CountMaxIn) ?? 0).gadrmotlagh();
countFor -= (x.Sum(a => a.SumInCount) ?? 0).gadrmotlagh();
weightFor = null;
}
else
{
var v1 = x.Sum(a => a.CountMaxOut ?? 0).gadrmotlagh();
var v2 = (x.Sum(a => a.SumOutCount) ?? 0).gadrmotlagh();
countFor = v1;
countFor -= v2;
weightFor = null;
}
return;
}
countFor = null;
weightFor = null;
}
public locationchart(web_db.sardweb_Context db, web_db._Weighing.TblLocation row)
{
this.code = row.Code;
this.id = row.Id;
this.title = row.Title;
this.wight = row.Wight;
this.childs = db.TblLocations.Where(a => a.FkP == row.Id).OrderBy(a => a.Code).Select(a => new locationchart(db, a)).ToList();
this.CodeFull = row.CodeFull;
}
public mandeHesabclass(IEnumerable <web_db._Weighing.TblPortageRow> x, web_db.sardweb_Context db, bool c = false)
{
if (x.Any() == false)
{
return;
}
var contrtt = x.Select(a => a.FkContract).Distinct();
var contr = db.TblContracts.Where(a => contrtt.Contains(a.Id));
var ContractType = db.TblContractTypes.Single(a => a.Id == contr.First().FkContractType);
}
/// <summary>
/// Initializes a new instance of the <see cref="user"/> class.
/// </summary>
/// <param name="model">The model<see cref="web_db.TblUser"/>.</param>
/// <param name="db">The db<see cref="web_db.sardweb_Context"/>.</param>
public user(web_db.TblUser model, web_db.sardweb_Context db)
{
Id = model.Id;
Mob = model.Mob;
Password = model.Password;
Roles = model.Roles.Split(",");
Title = model.Title;
Username = model.Username;
this.isActive = model.IsActive;
Permis = db.TblUserPermis.Where(a => a.FkUser == model.Id).ToArray();
}
public IActionResult Index()
{
var db = new web_db.sardweb_Context();
ViewBag.htmlmain = (db.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_htmlmain) ?? new web_db.TblConf()).Value;
ViewBag.cars = db.TblPortages.Include(a => a.FkContracttypeNavigation).Where(a => a.IsDel == false && a.Date1.Date == DateTime.Now.Date).ToList();
ViewBag.carEntezar = (long)(db.TblPortages.Where(a => a.Date2.HasValue && a.IsEnd).OrderByDescending(a => a.Date1).Take(100).AsEnumerable().Select(a => a.Date2.Value - a.Date1).Average(a => a.Ticks));
return(View());
}
public static void _refstoreOne(web_db.sardweb_Context db, Guid fkportage)
{
var x = db.TblPortageRows.Where(a => a.FkPortage == fkportage);
var por = db.TblPortages.Find(fkportage);
var contype = web_sard.Models.cl._ListContractType(por.FkSalmali).Single(a => a.Id == por.FkContracttype);
por.WeightNet = (por.Weight1 - por.Weight2).gadrmotlagh();
if (Models.tbls.portage.kindPortage.listkindcontract.Single(a => a.code == por.KindCode).Manfi)
{
por.WeightNet = -por.WeightNet;
}
por.PackingCount = x.Sum(a => a.Count);
por.PackingOfWeight = (double?)(por.WeightNet / por.PackingCount).gadrmotlagh();
por.OtcodeResid = "";
db.TblPortageMoneys.RemoveRange(db.TblPortageMoneys.Where(a => a.FkPortage == por.Id));
decimal ss = 0;
foreach (var item in x)
{
var sc = Models.cl.getWeightScale(item.FkProduct, item.FkPacking);
item.WeightOne = sc * por.PackingOfWeight;
if (item.WeightOne.HasValue)
{
ss += (decimal)item.WeightOne * item.Count;
}
}
foreach (var item in x)
{
if (item.WeightOne.HasValue)
{
item.WeightOne = item.WeightOne * (double)(por.WeightNet / ss);
}
}
db.SaveChanges();
_refstoreTow(db, fkportage);
}
public PortageRow(web_db._Weighing.TblPortageRow row, web_db.sardweb_Context db, bool portage)
{
this.Code = row.Code;
this.Count = row.Count.gadrmotlagh();
this.WeightOne = row.WeightOne;
this.Date = row.Date;
this.FkPacking = row.FkPacking;
this.FkProduct = row.FkProduct;
this.Packing = (web_sard.Models.cl._ListPacking.SingleOrDefault(a => a.Id == row.FkPacking) ?? new web_db._Weighing.TblPacking()).Title;
this.Product = (web_sard.Models.cl._ListProduct.SingleOrDefault(a => a.Id == row.FkProduct) ?? new web_db._Weighing.TblProduct()).Title;
this.Id = row.Id;
this.FkContract = row.FkContract;
this.CodeContract = (db.TblContracts.Find(row.FkContract) ?? new web_db._Weighing.TblContract()).Code;
this.Txt = row.Txt;
this.IsNimPalet = row.IsNimPalet;
this.ListInjurys = db.TblPortageRowInjuries.Where(a => a.FkPortageRow == row.Id).Select(a => a.FkInjury).ToArray();
this.ListInjurysTbl = (from n in db.TblPortageRowInjuries.Include(a => a.FkInjuryNavigation)
where n.FkPortageRow == row.Id
let inj = n.FkInjuryNavigation
select new alltbl {
code = inj.Ord, key = inj.Id, title = inj.Title
}).ToList();
this.CodeLocation = row.CodeLocation;
if (this.CodeLocation.IsEmpty() == false)
{
var z = this.CodeLocation.Split("-");
if (z.Count() > 0)
{
L1 = Convert.ToInt32(z[0]);
}
if (z.Count() > 1)
{
L2 = Convert.ToInt32(z[1]);
}
if (z.Count() > 2)
{
L3 = Convert.ToInt32(z[2]);
}
}
UserAddStr = db.TblUsers.Find(row.FkUser).Title;
this.fkportage = row.FkPortage;
tblportage = new portage();
if (this.fkportage.HasValue && portage)
{
tblportage = new portage(db.TblPortages.Find(this.fkportage), db);
}
}
public Product(web_db._Weighing.TblProduct row, web_db.sardweb_Context db, int salmali)
{
this.id = row.Id;
this.isActive = row.IsActive;
this.title = row.Title;
this.code = row.Code;
this.OtcodeKala = row.OtcodeKala;
this.OtcodeKalaAcc = row.OtcodeKalaAcc;
this.OtcodeVahedShomaresh = row.OtcodeVahedShomaresh;
{
InContract = db.TblContracts.Include(a => a.TblContractProducts).Where(a => a.FkSalmali == salmali && a.TblContractProducts.Any(S => S.FkProduct == this.id)).Sum(a => a.WeightMaxIn) ?? 0;
OutContract = db.TblContracts.Include(a => a.TblContractProducts).Where(a => a.FkSalmali == salmali && a.TblContractProducts.Any(S => S.FkProduct == this.id)).Sum(a => a.WeightMaxOut) ?? 0;
}
}
public static bool RemoveFullContract(Guid id, web_db.sardweb_Context db)
{
try
{
db.TblContractPackings.RemoveRange(db.TblContractPackings.Where(a => a.FkContract == id));
db.TblContractProducts.RemoveRange(db.TblContractProducts.Where(a => a.FkContract == id));
db.TblContracts.Remove(db.TblContracts.Find(id));
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
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 customerAcc(web_db.TblCustomer row, web_db.sardweb_Context db)
{
this.Code = row.Code;
this.Id = row.Id;
this.IdOtherSystem = row.IdOtherSystem;
this.Mob = row.Mob;
this.NationalCode = row.NationalCode;
this.Title = row.Title;
this.codesContract = (row.TblContracts ?? (ICollection <web_db._Weighing.TblContract>)db.TblContracts.Where(a => a.FkCustomer == row.Id)).Select(a => a.Code).ToArray();
//var x = from n in db.TblPortageMoneys
// where n.FkContractType == contype && n.FkCustomer == row.Id
// group n by n.Kind into m
// select new customerAccRow { Kind =m.Key, Weight=m.Sum(a=>a.Weight), PriceSum=m.Sum(a=>a.PriceSum)};
}
internal async Task _loginAsync(web_db.TblUser x, web_db.sardweb_Context db)
{
var claims = new List <Claim>
{
new Claim(ClaimTypes.NameIdentifier, x.Id.ToString()),
new Claim(ClaimTypes.Name, x.Username ?? ""),
new Claim(ClaimTypes.Role, x.Roles ?? ""),
new Claim(ClaimTypes.GivenName, x.Title ?? ""),
new Claim("Years", db.TblUserSals.Where(a => a.FkUser == x.Id).Select(a => a.FkSal).ToArray().ToJson()),
new Claim(ClaimTypes.Dsa, x.Salmalidef.ToString()),
new Claim("Permis", Newtonsoft.Json.JsonConvert.SerializeObject(db.TblUserPermis.Where(a => a.FkUser == x.Id)).ToString()),
new Claim("userBalanceCode", x.BalanceCode.ToString()),
};
ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "login");
ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity);
await HttpContext.SignInAsync(principal);
}
public packing(web_db._Weighing.TblPacking row, web_db.sardweb_Context db, int salmali)
{
this.Code = row.Code;
this.Id = row.Id;
this.IsActive = row.IsActive;
this.Title = row.Title;
this.WightEmpty = row.WightEmpty;
this.WightFull = row.WightFull;
this.WightScale = row.WightScale;
this.ForContractType = row.ForContractType();
this.OtcodeKala = row.OtcodeKala;
this.OtcodeKalaAcc = row.OtcodeKalaAcc;
this.OtcodeVahedShomaresh = row.OtcodeVahedShomaresh;
this.IsNotAc = row.IsNotAc ?? false;
{
InContract = db.TblContracts.Include(a => a.TblContractPackings).Where(a => a.FkSalmali == salmali && a.TblContractPackings.Any(S => S.FkPacking == this.Id)).Sum(a => a.CountMaxIn) ?? 0;
OutContract = db.TblContracts.Include(a => a.TblContractPackings).Where(a => a.FkSalmali == salmali && a.TblContractPackings.Any(S => S.FkPacking == this.Id)).Sum(a => a.CountMaxOut) ?? 0;
}
}
public IActionResult Index()
{
var kiloview = true; // Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString());
var db = new web_db.sardweb_Context();
var us = new web_CusDB.db_Context().TblCustomers.Single(a => a.Id == User._getuserId());
var x = (from n in db.TblContracts
let s = db.TblSalMalis.FirstOrDefault(a => a.Id == n.FkSalmali)
let c = db.TblCustomers.FirstOrDefault(a => a.Id == n.FkCustomer)
where
((c.NationalCode.Equals(us.CodeMelli)) && (c.Mob.Trim().Equals(us.Mob.Trim())))
&& (s.IsOrginal == true)
select new web_sard.Models.tbls.contract.contract(n, db, true, false, null, kiloview)).ToList();
ViewBag.sals = db.TblSalMalis.Where(a => a.IsOrginal == true).OrderByDescending(a => a.SalAz).ToList();
return(View(x));
}
public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db)
{
var portage = db.TblPortages.Find(id);
var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype);
#region rem PortageRows
foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id))
{
db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id));
db.TblPortageRows.Remove(item);
}
#endregion
#region rem images
var dbdoc = new web_dbDocument.db_Context();
dbdoc.TblDocuments.RemoveRange(dbdoc.TblDocuments.Where(a => a.FkPortage == portage.Id));
db.TblPortages.Remove(portage);
#endregion
db.SaveChanges();
dbdoc.SaveChanges();
if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)
{
var x = db.TblPortageRows.Where(a => a.FkPortage == portage.Id);
foreach (var item in x.Select(a => a.FkContract).Distinct())
{
Models.cl.refTblStoreLogcontractSardKhane(item.Value, db);
}
}
return(true);
}
//public static bool RemoveFullPortage(Guid id, web_db.sardweb_Context db)
//{
// var portage = db.TblPortages.Find(id);
// var contypeclone = db.TblContractTypes.Single(a => a.Id == portage.FkContracttype);
// #region rem PortageRows
// foreach (var item in db.TblPortageRows.Where(a => a.FkPortage == portage.Id))
// {
// db.TblPortageRowInjuries.RemoveRange(db.TblPortageRowInjuries.Where(a => a.FkPortageRow == item.Id));
// db.TblPortageRows.Remove(item);
// }
// #endregion
// #region rem images
// db.TblDocuments.RemoveRange(db.TblDocuments.Where(a => a.FkPortage == portage.Id));
// db.TblPortages.Remove(portage);
// #endregion
// db.SaveChanges();
// if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane)
// {
// var x = db.TblPortageRows.Where(a => a.FkPortage == portage.Id);
// foreach (var item in x.Select(a => a.FkContract).Distinct())
// {
// Models.cl.refTblStoreLogcontractSardKhane(item.Value, db);
// }
// }
// else if (contypeclone.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
// {
// Models.cl.refTblStoreLogcontractTypeSabad(contypeclone.Id , db);
// }
// return true;
//}
//public static bool RemoveFullContract(Guid id, web_db.sardweb_Context db)
//{
// try
// {
// db.TblContractPackings.RemoveRange(db.TblContractPackings.Where(a => a.FkContract == id));
// db.TblContractProducts.RemoveRange(db.TblContractProducts.Where(a => a.FkContract == id));
// db.TblContracts.Remove(db.TblContracts.Find(id));
// db.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
//}
public static async Task <Guid?> AddPayvastCustomerAsync(web_db.sardweb_Context db, string CellPhone, int sal)
{
var Mali_KindOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_KindOT) ?? new web_db.TblConf()).Value;
var Mali_UrlOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_UrlOT) ?? new web_db.TblConf()).Value;
var Mali_UserOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_UserOT) ?? new web_db.TblConf()).Value;
var Mali_PassOT = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Mali_PassOT) ?? new web_db.TblConf()).Value;
ApiPaivast.AccountingServiceSoapClient vv = new AccountingServiceSoapClient(AccountingServiceSoapClient.EndpointConfiguration.AccountingServiceSoap, Mali_UrlOT);
var c = await vv.GetCustomerIdByCellPhoneAsync(CellPhone : CellPhone);
var idc = c;
var cid = await vv.GetCustomerInfoAsync(idc, Mali_UserOT, Mali_PassOT);
if (cid != null)
{
string txt = "ثبت موفق";
var row = db.TblCustomers.FirstOrDefault(a => a.FkSalmali == sal && a.IdOtherSystem == cid.Id.ToString());
if (row == null)
{
row = new web_db.TblCustomer
{
Id = Guid.NewGuid(),
FkSalmali = sal,
IdOtherSystem = cid.Id.ToString(),
IsEnable = true,
Code = (db.TblCustomers.Where(a => a.FkSalmali == sal).Max(a => (int?)a.Code) ?? 0) + 1,
};
db.TblCustomers.Add(row);
txt = "بروزرسانی موفق";
}
row.IsEnable = true;
row.Addras = "";
row.Mob = CellPhone;
row.NationalCode = cid.NationalCode;
row.Title = cid.Name.ToPersianChars();
db.SaveChanges();
return(row.Id);
}
return(null);
}
public IActionResult Index()
{
var db = new web_CusDB.db_Context();
var dbweb = new web_db.sardweb_Context();
var x = db.tblReqContracts.Where(a => a.tblCusId == User._getuserId()).OrderByDescending(a => a.DateLast).ToList();
foreach (var item in x)
{
item._Contract = dbweb.TblContracts.Include(a => a.FkContractTypeNavigation).SingleOrDefault(a => a.Id == item.ContractId);
item._LasttblReqContractRows = db.tblReqContractRows.OrderBy(a => a.Date).Last(a => a.TblReqContractId == item.Id);
}
ViewBag.US_WeightZarib = (dbweb.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.US_WeightZarib) ?? new web_db.TblConf()).Value.ToInt(1);
return(View(x));
}
public IActionResult contract(Guid id)
{
var kiloview = true;// Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString());
var db = new web_db.sardweb_Context();
var dbdoc = new web_dbDocument.db_Context();
var us = new web_CusDB.db_Context().TblCustomers.Single(a => a.Id == User._getuserId());
var x = db.TblContracts.Find(id);
var port = db.TblPortages.Include(a => a.TblPortageRows).Where(a =>
a.TblPortageRows.Any(s => s.FkContract == id)).Select(a => a.Id).Distinct().ToList();
if (port == null)
{
port = new List <Guid>();
}
ViewBag.listiamges = dbdoc.TblDocuments.Where(a => (port.Contains(a.FkP ?? Guid.Empty) || port.Contains(a.FkPortage ?? Guid.Empty)) && (a.Kind.Contains("Sign") == false)).ToList();
ViewBag.kiloview = kiloview;// Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.US_WeightViewEnable && a.Value == true.ToString());
return(View(new web_sard.Models.tbls.contract.contract(x, db, true, true, null, kiloview)));
}
public static web_db.TblCustomer checkCodeCusMain(web_CusDB.tblCus c)
{
web_db.sardweb_Context db = new web_db.sardweb_Context();
var saldef = db.TblSalMalis.FirstOrDefault(a => a.IsOpen);
if (saldef == null)
{
return(null);
}
var x = db.TblCustomers.Where(a => a.Mob == c.Mob && a.NationalCode == c.CodeMelli & a.FkSalmali == saldef.Id).Distinct();
var f = x.FirstOrDefault();
if (f != null && f.Code != c.CodeCusMainSystem)
{
return(x.First());
}
return(null);
}
public static void _refstoreTow(web_db.sardweb_Context db, Guid fkportage)
{
var x = db.TblPortageRows.Where(a => a.FkPortage == fkportage);
var por = db.TblPortages.Find(fkportage);
por.WeightNet = (por.Weight1 - por.Weight2).gadrmotlagh();
if (Models.tbls.portage.kindPortage.listkindcontract.Single(a => a.code == por.KindCode).Manfi)
{
por.WeightNet = -por.WeightNet;
}
var contype = web_sard.Models.cl._ListContractType(por.FkSalmali).Single(a => a.Id == por.FkContracttype);
if (contype.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
Models.cl.refTblStoreLogcontractTypeSabad(contype.Id, db);
}
db.SaveChanges();
}
public static async Task sendsmsNoteAsync(IConfiguration _mySettings, CancellationToken stoppingToken = default)
{
web_db.sardweb_Context db = new web_db.sardweb_Context();
{
var sms = Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.Main_ActiceSms && a.Value == true.ToString());
var user = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_UserSms) ?? new web_db.TblConf()).Value;
var pass = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_PassSms) ?? new web_db.TblConf()).Value;
var num = (Models.cl._conf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_NumSms) ?? new web_db.TblConf()).Value;
web_lib.sms s = new web_lib.sms {
numfrom = num, password = pass, username = user
};
var x = db.TblNoteRows.Where(a => a.SendSms && a.Date == DateTime.Now.Date).Include(a => a.TblNote).AsEnumerable().GroupBy(a => a.TblNote);
var us = db.TblUsers.Where(a => a.IsActive && a.IsDel == false).AsEnumerable();
foreach (var mes in x)
{
foreach (var item in us.Where(a => mes.Any(s => s.ForUserId.GetValueOrDefault() == a.Id || (string.IsNullOrWhiteSpace(s.ForUserroll) == false? a.Roles.Contains(s.ForUserroll ?? ""):false))))
{
var txt = new StringBuilder();
txt.AppendLine(_mySettings.GetValue <string>("txtPortagesms"));
txt.AppendLine($"یاداوری");
txt.AppendLine($"در مورخه : " + (DateTime.Now.Date).ToPersianDate());
txt.AppendLine(mes.Key.Caption);
try
{
var v = await s.sendsmsAsync(item.Mob, txt.ToString(), stoppingToken);
}
catch
{
}
}
}
};
}
public customer(web_db.TblCustomer row, web_db.sardweb_Context db, web_db._Weighing.TblContractType.KindCotractTypeEnum?kind = null, bool grops = true)
{
this.Addras = row.Addras;
this.Code = row.Code;
this.FkSalmali = row.FkSalmali;
this.Id = row.Id;
this.IdOtherSystem = row.IdOtherSystem;
this.IsEnable = row.IsEnable;
this.Mob = row.Mob;
this.NationalCode = row.NationalCode;
this.Title = row.Title;
this.datelastlogin = row.Dateloginlast;
this.codesContract = (db.TblContracts.Include(a => a.FkContractTypeNavigation).Where(a => (kind == null?true: (a.FkContractTypeNavigation.KindCotractType == kind)) && a.FkCustomer == row.Id)).Select(a => a.Code).ToArray();
this.listfkGroup = new Guid[] { };
this.listGroup = new string[] { };
if (grops)
{
var v = db.TblCustomerGroups.Where(a => a.FkCustumer == this.Id).Include(a => a.FkGroupNavigation);
this.listfkGroup = v.Select(a => a.FkGroup).ToArray();
this.listGroup = v.Select(a => a.FkGroupNavigation.Title).ToArray();
}
}
