public async Task <IActionResult> Edit(web_CusDB.tblCus model)
{
if (model.CodeMelli.IsCodemeli() == false)
{
ModelState.AddModelError("CodeMelli", "کد ملی اشتباه است");
}
if (ModelState.IsValid)
{
var db = new web_CusDB.db_Context();
var us = db.TblCustomers.Single(a => a.Id == User._getuserId());
us.Name = model.Name;
us.CodeMelli = model.CodeMelli;
us.Addras = model.Addras;
us.CodeCusMainSystem = us.checkCodeCusMain().Code;
db.SaveChanges();
await LoginAuth._loginAsync(this.HttpContext, us);
return(RedirectToAction("Index"));
}
return(View(model));
}
public static async Task _loginAsync(HttpContext httpcontext, web_CusDB.tblCus x)
{
x.dateLast = DateTime.Now;
var IsProfileOK = false;
if (!x.CodeMelli.IsEmpty() && !x.Name.IsEmpty())
{
IsProfileOK = true;
}
var claims = new List <Claim>
{
new Claim("Id", x.Id.ToString()),
new Claim(ClaimTypes.Name, x.Mob ?? ""),
new Claim("Name", x.Name ?? ""),
new Claim("IsProfileOK", IsProfileOK.ToString()),
new Claim("lastdate", x.dateLast.ToString()),
new Claim("CodeCusMainSystem", x.CodeCusMainSystem.ToString()),
};
ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "login");
ClaimsPrincipal principal = new ClaimsPrincipal(userIdentity);
await httpcontext.SignInAsync(principal);
}
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 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 async Task <IActionResult> Login(string mob, string code)
{
if (mob.IsEmpty())
{
return(View( ));
}
if (mob.IsMobile())
{
ViewBag.mob = mob;
var db = new web_CusDB.db_Context();
var us = db.TblCustomers.SingleOrDefault(a => a.Mob == mob);
if (code.IsEmpty())
{
if (this.Request.googleRecapch3Check(web_CusDB.stat.CapchSecretKey) == false)
{
ViewBag.mob = null;
ViewBag.err = "لطفاً تایید کنید که ربات نیستید.";
ModelState.AddModelError(string.Empty, "لطفاً تایید کنید که ربات نیستید.");
return(View());
}
if (us == null)
{
us = new web_CusDB.tblCus
{
Id = Guid.NewGuid(),
Mob = mob,
dateAdd = DateTime.Now,
Addras = "",
CodeMelli = "",
Name = "",
CodeCusMainSystemAcc = ""
};
db.TblCustomers.Add(us);
}
if (us._DateCodeSms.GetValueOrDefault().AddMinutes(2) > DateTime.Now)
{
ViewBag.txt = "کد قبلا برای شما ارسال گردیده است";
return(View());
}
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,
};
us._CodeSMS = new Random().Next(1000, 99999);
us._DateCodeSms = DateTime.Now;
db.SaveChanges();
sms.sendsmsAsync(mob, (dbmain.TblConf.SingleOrDefault(a => a.Key == web_db.TblConf.KeyEnum.Main_SherkatName) ?? new web_db.TblConf()).Value + @$ "
کد ورود به سایت: " + us._CodeSMS.ToString());
ViewBag.txt = "کد برای شما ارسال گردید";
return(View());
}
else
{
if (us._CodeSMS.ToString() == code)
{
us.CodeCusMainSystem = web_CusDB.tblCus.checkCodeCusMain(us).Code;
us.dateLast = DateTime.Now;
db.SaveChanges();
await LoginAuth._loginAsync(HttpContext, us);
return(RedirectToAction("index", "home"));
}
else
{
ViewBag.txt = "کد ارسالی اشتباه است";
return(View());
}
}
}
else
{
ViewBag.txt = "شماره موبایل اشتباه است";
return(View());
}
}
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());
}
