private object cus(web_db._Weighing.TblContractType typecontract, Models.tbls.portage.portage model)
{
if (typecontract.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ABaskul)
{
var conf = typecontract.ConfigABaskul();
var c =
db.TblCustomers.Include(a => a.TblContracts).Where(a =>
a.FkSalmali == User._getuserSalMaliDef() &&
a.IsEnable
).OrderBy(a => a.Code).Select(a => new web_sard.Models.tbls.customer.customer(a, db, web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad, true)).ToList();
if (model.FkCustomer.IsEmpty() && conf.CustomerPishfarz.HasValue)
{
var cc = (c.SingleOrDefault(a => a.Code == conf.CustomerPishfarz) ?? new web_sard.Models.tbls.customer.customer());
model.FkCustomer = cc.Id;
model.Customer = cc;
model.Customerstr = cc.Title;
}
return(c);
}
else
{
return
(db.TblCustomers.Include(a => a.TblContracts).Where(a =>
a.FkSalmali == User._getuserSalMaliDef() &&
a.IsEnable &&
a.TblContracts.Any(s => s.FkContractType == typecontract.Id)
).OrderBy(a => a.Code).Select(a => new web_sard.Models.tbls.customer.customer(a, db, web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad, true)).ToList());
}
}
private object cus(web_db._Weighing.TblContractType typecontract, Models.tbls.portage.portage model)
{
return
(db.TblCustomers.Include(a => a.TblContracts).Where(a =>
a.FkSalmali == User._getuserSalMaliDef() &&
a.IsEnable &&
a.TblContracts.Any(s => s.FkContractType == typecontract.Id)
).OrderBy(a => a.Code).Select(a => new web_sard.Models.tbls.customer.customer(a, db, web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane, true)).ToList());
}
public IActionResult CreateIN(Guid id, Guid idtype, int kindPortage)
{
var tim = DateTime.Now;
Models.tbls.portage.portage model = new Models.tbls.portage.portage
{
Id = Guid.NewGuid(),
Date1 = tim,
Date1date = tim.ToPersianDate(),
Date1time = new TimeSpan(tim.Hour, tim.Minute, 0),
Weight1IsBascul = true
};
var row = db.TblPortages.Find(id);
if (row != null)
{
if (row.IsEnd)
{
return(Redirect(Request.UrlReferer()));
}
model = new Models.tbls.portage.portage(row, db, true);
idtype = model.FkContractType;
kindPortage = model.KindCode;
}
var typecontract = db.TblContractTypes.Find(idtype);
if (model.Code == 0)
{
model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1;
}
ViewData["type"] = typecontract;
ViewData["kindPortage"] = kindPortage;
var intosard = false;
if ((kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane) || (kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane))
{
intosard = true;
}
ViewBag.contrs = (from n in db.TblContracts.Include(a => a.FkContractTypeNavigation).Include(a => a.FkCustomerNavigation)
where n.FkSalmali == typecontract.FkSalmali && n.FkContractType == idtype //&&
// (intosard == false ? true : (n._FkContractPeer.HasValue))
orderby n.Code ascending
select n).ToList();
return(View(model));
}
public IActionResult CreateOut(Guid id)
{
var x = db.TblPortages.Find(id);
if (x.Date2.HasValue == false)
{
x.Date2 = DateTime.Now;
x.Weight2IsBascul = true;
}
var model = new Models.tbls.portage.portage(x, db, true, false, true);
return(View(model));
}
public IActionResult PrintAjax(Guid id, string kind)
{
var x = new Models.tbls.portage.portage(db.TblPortages.Find(id), db, true, true, true);
x.ContractType.TblPortages = null;
x.ContractType.TblContracts = null;
var p = "";
if (!kind.IsEmpty())
{
var fileContent = System.IO.File.ReadAllText(Path.Combine(Directory.GetCurrentDirectory(), $"wwwroot\\Reports\\portage\\rpt_{(int)x.ContractType.KindCotractType}_{kind}.html"));
p = fileContent;
}
return(Content(new { json = x, page = p }.ToJson()));
}
public IActionResult CreateIN(Guid id, Guid idtype, int kindPortage)
{
var tim = DateTime.Now;
Models.tbls.portage.portage model = new Models.tbls.portage.portage
{
Id = Guid.NewGuid(),
Date1 = tim,
Date1date = tim.ToPersianDate(),
Date1time = new TimeSpan(tim.Hour, tim.Minute, 0),
Weight1IsBascul = true
};
var row = db.TblPortages.Find(id);
if (row != null)
{
if (row.IsEnd)
{
return(Redirect(Request.UrlReferer()));
}
model = new Models.tbls.portage.portage(row, db, true);
idtype = model.FkContractType;
kindPortage = model.KindCode;
}
var typecontract = db.TblContractTypes.Find(idtype);
if (model.Code == 0)
{
model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1;
}
ViewData["type"] = typecontract;
ViewData["kindPortage"] = kindPortage;
ViewData["listcustumer"] = cus(typecontract, model);
return(View(model));
}
public IActionResult CreateOut(Models.tbls.portage.portage model, bool resendSms, string print)
{
var x = db.TblPortages.Find(model.Id);
model.ContractType = cl._ListContractType(User._getuserSalMaliDef()).Single(a => a.Id == model.FkContractType);
ModelState.Remove("FkCarTbl");
if (model.ContractType.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
ModelState.Remove("Date1date");
ModelState.Remove("Date1time");
ModelState.Remove("Customer.Mob");
ModelState.Remove("Customer.NationalCode");
ModelState.Remove("Customer.Code");
ModelState.Remove("Customer.Title");
ModelState.Remove("Customer.Id");
ModelState.Remove("Weight1");
ModelState.Remove("Weight2");
if (ModelState.IsValid)
{
x.CarMashin = model.CarMashin;
x.CarRanande = model.CarRanande;
x.CarShMashin = model.CarShMashin;
x.FkCar = model.FkCar;
x.CarMashin = cl._ListCar.Single(a => a.Id == model.FkCar).Title;
x.CarTell = model.CarTell;
var dbdoc = new web_dbDocument.db_Context();
if (x.Weight2 != model.Weight2)
{
var z = cl.captureDorbinBaskul();
if (z != null)
{
dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument
{
Date = DateTime.Now,
FkP = x.Id,
Id = Guid.NewGuid(),
Image = z,
Kind = "OutBaskul",
Format = ""
});
}
}
x.Weight2 = model.Weight2;
x.WeightNet = (x.Weight2 - x.Weight1).gadrmotlagh();
x.Weight2IsBascul = model.Weight2IsBascul;
x.Txt = model.Txt;
x.Date2 = model.Date2date.ToDate().AddHours(model.Date2time.Value.Hours).AddMinutes(model.Date2time.Value.Minutes);
x.IsDel = false;
if (x.Dateadd2.HasValue == false)
{
x.Dateadd2 = DateTime.Now;
x.FkUsAdd2 = User._getuserid();
}
else
{
x.Dateedit2 = DateTime.Now;
x.FkUsEdit2 = User._getuserid();
}
x.IsPermitOk = null;
x.FkUsPermit = null;
x.TxtPermit = "";
x.IsEnd = false;
{
x.SmsOk = resendSms == true ? null : (x.SmsOk == true ? (bool?)true : false);
}
ViewBag.error = checkportage(x);
if (((string)ViewBag.error).IsEmpty())
{
using (var trans = new TransactionScope())
{
Models.cl._refstoreOne(db, x.Id);
x.IsPermitOk = contract.IsPermitOK(x, db);
if (x.IsPermitOk == true)
{
x.IsEnd = true;
x.TxtPermit = "";
x.FkUsPermit = null;
}
else
{
x.IsEnd = false;
}
db.SaveChanges();
Models.cl._refstoreTow(db, x.Id);
trans.Complete();
}
dbdoc.SaveChanges();
if (x.IsPermitOk == false)
{
return(RedirectToAction("CreateOut", x.Id));
}
if (string.IsNullOrEmpty(print))
{
return(RedirectToAction("index", new { idtype = x.FkContracttype, kindPortage = x.KindCode }));
}
return(RedirectToAction("Print", new { id = x.Id }));
}
}
ViewData["type"] = db.TblContractTypes.Find(x.FkContracttype);
ViewData["kindPortage"] = x.KindCode;
// model.Documents = db.TblDocuments.Where(a => a.FkPortage == model.Id).Select(a => new Models.tbls.portage.PortageDocument(a)).ToList();
model.ListRows = db.TblPortageRows.Where(a => a.FkPortage == model.Id).Select(a => new Models.tbls.portage.PortageRow(a, db, false)).ToList();
}
return(View(model));
}
public IActionResult CreateIN(Guid idtype, int kindPortage, Models.tbls.portage.portage model)
{
ModelState.Remove("Weight2");
ModelState.Remove("Date2date");
ModelState.Remove("Date2time");
ModelState.Remove("Customer.Mob");
ModelState.Remove("Customer.NationalCode");
ModelState.Remove("Customer.Code");
ModelState.Remove("Customer.Title");
ModelState.Remove("Customer.Id");
ModelState.Remove("FkCarTbl");
var typecontract = db.TblContractTypes.Find(idtype);
if (typecontract.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad)
{
ModelState.Remove("Weight1");
var conf = typecontract.ConfigASabad();
if (ModelState.IsValid)
{
var x = db.TblPortages.Find(model.Id);
if (x == null)
{
model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1;
x = new web_db._Weighing.TblPortage
{
FkSalmali = User._getuserSalMaliDef(),
Code = model.Code,
Dateadd1 = DateTime.Now,
FkContracttype = idtype,
FkUsAdd1 = User._getuserid().Value,
Id = model.Id,
KindCode = kindPortage,
KindTitle = Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == kindPortage).txt,
};
db.TblPortages.Add(x);
}
else
{
x.Dateedit1 = DateTime.Now;
x.FkUsEdit1 = User._getuserid().Value;
}
x.CarMashin = model.CarMashin;
x.CarRanande = model.CarRanande;
x.CarShMashin = model.CarShMashin;
x.CarTell = model.CarTell;
x.FkCar = model.FkCar;
x.CarMashin = cl._ListCar.Single(a => a.Id == model.FkCar).Title;
x.FkCustomer = model.FkCustomer;
var dbdoc = new web_dbDocument.db_Context();
if (x.Weight1 != model.Weight1)
{
var z = cl.captureDorbinBaskul();
if (z != null)
{
dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument
{
Date = DateTime.Now,
FkP = x.Id,
Id = Guid.NewGuid(),
Image = z,
Kind = "InBaskul",
Format = ""
});
}
}
x.Weight1 = model.Weight1;
x.Weight1IsBascul = model.Weight1IsBascul;
x.Txt = model.Txt;
x.Date1 = model.Date1date.ToDate().AddHours(model.Date1time.Hours).AddMinutes(model.Date1time.Minutes);
x.IsDel = false;
x.IsPermitOk = null;
x.FkUsPermit = null;
x.TxtPermit = "";
ViewBag.error = checkportage(x);
if (((string)ViewBag.error).IsEmpty())
{
db.SaveChanges();
dbdoc.SaveChanges();
Models.cl._refstoreTow(db, x.Id);
return(RedirectToAction("index", new { idtype = x.FkContracttype }));
}
}
ViewData["type"] = db.TblContractTypes.Find(idtype);
ViewData["kindPortage"] = kindPortage;
ViewData["listcustumer"] = cus(typecontract, model);
return(View(model));
}
return(null);
}
public IActionResult View(Guid id)
{
var row = new Models.tbls.portage.portage(db.TblPortages.Find(id), db, true, true, true, true);
return(View(row));
}
public IActionResult CreateIN(Guid idtype, int kindPortage, Models.tbls.portage.portage model)
{
ModelState.Remove("Weight2");
ModelState.Remove("Date2date");
ModelState.Remove("Date2time");
ModelState.Remove("Customer.Mob");
ModelState.Remove("Customer.NationalCode");
ModelState.Remove("Customer.Code");
ModelState.Remove("Customer.Title");
ModelState.Remove("Customer.Id");
ModelState.Remove("FkCarTbl");
var kindPortageenum = (web_sard.Areas.ASurting.Models.tbls.portage.kindPortage.kindPortageEnum)kindPortage;
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane ||
kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar)
{
ModelState.Remove("CarShMashin");
ModelState.Remove("FkCar");
ModelState.Remove("CarRanande");
ModelState.Remove("CarTell");
ModelState.Remove("Weight1IsBascul");
ModelState.Remove("Weight1");
}
var typecontract = db.TblContractTypes.Find(idtype);
if (typecontract.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASurting)
{
var conf = typecontract.ConfigASurting();
if (ModelState.IsValid)
{
var x = db.TblPortages.Find(model.Id);
if (x == null)
{
model.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == idtype && a.KindCode == kindPortage).Max(a => (long?)a.Code) ?? 0) + 1;
x = new web_db._Weighing.TblPortage
{
FkSalmali = User._getuserSalMaliDef(),
Code = model.Code,
Dateadd1 = DateTime.Now,
FkContracttype = idtype,
FkUsAdd1 = User._getuserid().Value,
Id = model.Id,
KindCode = kindPortage,
KindTitle = Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == kindPortage).txt,
};
db.TblPortages.Add(x);
}
else
{
x.Dateedit1 = DateTime.Now;
x.FkUsEdit1 = User._getuserid().Value;
}
x.CarMashin = model.CarMashin ?? "";
x.CarRanande = model.CarRanande ?? "";
x.CarShMashin = model.CarShMashin ?? "";
x.CarTell = model.CarTell ?? "";
x.FkCar = model.FkCar;
x.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title;
x._FkContractMain = model._FkContractMain;
x.FkCustomer = db.TblContracts.Find(model._FkContractMain).FkCustomer;
x.Weight1 = model.Weight1;
x.Weight1IsBascul = model.Weight1IsBascul;
x.Txt = model.Txt;
x.Date1 = model.Date1date.ToDate().AddHours(model.Date1time.Hours).AddMinutes(model.Date1time.Minutes);
x.IsDel = false;
x.IsPermitOk = null;
x.FkUsPermit = null;
x.TxtPermit = "";
var dbdoc = new web_dbDocument.db_Context();
#region captureDorbinBaskul
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.In || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.Out)
{
if (x.Weight1 != model.Weight1)
{
var z = web_sard.Models.cl.captureDorbinBaskul();
if (z != null)
{
dbdoc.TblDocuments.Add(new web_dbDocument.TblDocument
{
Date = DateTime.Now,
FkP = x.Id,
Id = Guid.NewGuid(),
Image = z,
Kind = "InBaskul",
Format = ""
});
}
}
}
#endregion
#region PeerSardKhane
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane)
{
var xpkind = (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane ? web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.kindPortageEnum.OutToSurt :
web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.kindPortageEnum.InFromSurt);
foreach (var item in web_sard.Models.cl._ListContractType(x.FkSalmali).Where(a => a.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASardKhane))
{
var xp = db.TblPortages.Find(x._FkPortagePeer);
if (xp == null)
{
xp = new web_db._Weighing.TblPortage
{
FkSalmali = User._getuserSalMaliDef(),
Code = model.Code,
_FkPortagePeer = x.Id,
Dateadd1 = DateTime.Now,
FkContracttype = item.Id,
FkUsAdd1 = User._getuserid().Value,
Id = Guid.NewGuid(),
KindCode = (int)xpkind,
KindTitle = web_sard.Areas.ASardKhane.Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == (int)xpkind).txt,
};
xp.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == item.Id && a.KindCode == (int)xpkind).Max(a => (long?)a.Code) ?? 0) + 1;
db.TblPortages.Add(xp);
x._FkPortagePeer = xp.Id;
}
else
{
xp.Dateedit1 = DateTime.Now;
xp.FkUsEdit1 = User._getuserid().Value;
}
xp.CarMashin = x.CarMashin ?? "";
xp.CarRanande = x.CarRanande ?? "";
xp.CarShMashin = x.CarShMashin ?? "";
xp.CarTell = x.CarTell ?? "";
xp.FkCar = x.FkCar;
xp.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title;
xp.FkCustomer = x.FkCustomer;
xp.Weight1 = x.Weight1;
xp.Weight1IsBascul = x.Weight1IsBascul;
xp.Txt = x.Txt;
xp.Date1 = x.Date1;
xp.IsDel = false;
xp.IsPermitOk = null;
xp.FkUsPermit = null;
xp.TxtPermit = "";
}
}
#endregion
#region PeerAnbar
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar)
{
var xpkind = (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar ? web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.kindPortageEnum.OutToSurt :
web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.kindPortageEnum.InFromSurt);
foreach (var item in web_sard.Models.cl._ListContractType(x.FkSalmali).Where(a => a.KindCotractType == web_db._Weighing.TblContractType.KindCotractTypeEnum.ASabad))
{
var xp = db.TblPortages.SingleOrDefault(a => a.FkContracttype == item.Id && a.Id == x._FkPortagePeer);
if (xp == null)
{
xp = new web_db._Weighing.TblPortage
{
FkSalmali = User._getuserSalMaliDef(),
Code = model.Code,
Dateadd1 = DateTime.Now,
FkContracttype = item.Id,
FkUsAdd1 = User._getuserid().Value,
_FkPortagePeer = x.Id,
Id = Guid.NewGuid(),
KindCode = (int)xpkind,
KindTitle = web_sard.Areas.ASabad.Models.tbls.portage.kindPortage.listkindcontract.Find(a => a.code == (int)xpkind).txt,
};
xp.Code = (db.TblPortages.Where(a => a.FkSalmali == User._getuserSalMaliDef() && a.FkContracttype == item.Id && a.KindCode == (int)xpkind).Max(a => (long?)a.Code) ?? 0) + 1;
db.TblPortages.Add(xp);
x._FkPortagePeer = xp.Id;
}
else
{
xp.Dateedit1 = DateTime.Now;
xp.FkUsEdit1 = User._getuserid().Value;
}
xp.CarMashin = x.CarMashin ?? "";
xp.CarRanande = x.CarRanande ?? "";
xp.CarShMashin = x.CarShMashin ?? "";
xp.CarTell = x.CarTell ?? "";
xp.FkCar = x.FkCar;
xp.CarMashin = (web_sard.Models.cl._ListCar.SingleOrDefault(a => a.Id == model.FkCar) ?? new web_db._Weighing.TblCar()).Title;
xp.FkCustomer = x.FkCustomer;
xp.Weight1 = x.Weight1;
xp.Weight1IsBascul = x.Weight1IsBascul;
xp.Txt = x.Txt;
xp.Date1 = x.Date1;
xp.IsDel = false;
xp.IsPermitOk = null;
xp.FkUsPermit = null;
xp.TxtPermit = "";
}
}
#endregion
ViewBag.error = checkportage(x);
if (((string)ViewBag.error).IsEmpty())
{
db.SaveChanges();
dbdoc.SaveChanges();
_refstoreTow(x.Id);
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane)
{
ASardKhane.Models.cl._refstoreTow(db, x.Id);
}
if (kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.InFromAnbar || kindPortageenum == Models.tbls.portage.kindPortage.kindPortageEnum.OutToAnbar)
{
ASabad.Models.cl._refstoreTow(db, x.Id);
}
return(RedirectToAction("index", new { idtype = x.FkContracttype }));
}
}
ViewData["type"] = db.TblContractTypes.Find(idtype);
ViewData["kindPortage"] = kindPortage;
var intosard = false;
if ((kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.InFromSardkhane) || (kindPortage == (int)Models.tbls.portage.kindPortage.kindPortageEnum.OutToSardkhane))
{
intosard = true;
}
ViewBag.contrs = (from n in db.TblContracts.Include(a => a.FkContractTypeNavigation).Include(a => a.FkCustomerNavigation)
where n.FkSalmali == typecontract.FkSalmali && n.FkContractType == idtype
//&&
//(intosard == false ? true : (n._FkContractPeer.HasValue))
orderby n.Code ascending
select n).ToList();
return(View(model));
}
return(null);
}
