public IActionResult Create(Models.tbls.customer.customer model)
{
if (ModelState.IsValid)
{
var x = db.TblCustomers.Find(model.Id);
if (x == null)
{
x = new web_db.TblCustomer
{
Id = Guid.NewGuid(),
FkSalmali = User._getuserSalMaliDef(),
Code = (db.TblCustomers.Where(a => a.FkSalmali == User._getuserSalMaliDef()).Max(a => (int?)a.Code) ?? 0) + 1
};
db.TblCustomers.Add(x);
}
x.Addras = model.Addras ?? "";
x.IdOtherSystem = model.IdOtherSystem ?? "";
x.IsEnable = model.IsEnable;
x.Mob = model.Mob ?? "";
x.NationalCode = model.NationalCode ?? "";
x.Title = model.Title;
db.SaveChanges();
return(RedirectToAction("Index", new { txt = "ثبت موفق" }));
}
return(View(model));
}
public static web_sard.Models.tbls.customer.customer get(web_db.TblCustomer row, web_db.sardweb_Context db)
{
var r = new web_sard.Models.tbls.customer.customer();
if (row != null)
{
r = new web_sard.Models.tbls.customer.customer
{
Addras = row.Addras,
Code = row.Code,
FkSalmali = row.FkSalmali,
Id = row.Id,
IdOtherSystem = row.IdOtherSystem,
IsEnable = row.IsEnable,
Mob = row.Mob,
NationalCode = row.NationalCode,
Title = row.Title,
codesContract = (row.TblContracts ?? (ICollection <web_db._Weighing.TblContract>)db.TblContracts.Where(a => a.FkCustomer == row.Id)).Select(a => a.Code).ToArray()
};
var v = db.TblCustomerGroups.Where(a => a.FkCustumer == r.Id).Include(a => a.FkGroupNavigation);
r.listfkGroup = v.Select(a => a.FkGroup).ToArray();
r.listGroup = v.Select(a => a.FkGroupNavigation.Title).ToArray();
}
return(r);
}
async Task <string> sendsmsloginAsync(web_db.TblCustomer c)
{
var sms = Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.Main_ActiceSms && a.Value == true.ToString());
var us = (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 = us
};
return(await s.sendsmsAsync(c.Mob, @"سردخانه میوه طلایی
ورود موفق
" + DateTime.Now.ToPersianDateTime()));
}
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)};
}
async Task <string> sendsmsAsync(web_db.TblCustomer c)
{
c.Password = new Random().Next(11001, 99999).ToString();
c.Datesendpassword = DateTime.Now;
var sms = Models.cl._conf.Any(a => a.Key == web_db.TblConf.KeyEnum.Main_ActiceSms && a.Value == true.ToString());
var us = (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 = us
};
return(await s.sendsmsAsync(c.Mob, @"سردخانه میوه طلایی
کد ورود به سایت: " + c.Password));
}
//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 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();
}
}
