/// <summary>
/// Обновляет лицевой счёт
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool UpdateSubscr(SubscrModel item)
{
using (var db = new CMSdb(_context))
{
using (var tran = db.BeginTransaction())
{
var dbSubscr = db.lk_subscrs
.Where(s => s.id == item.Id);
if (dbSubscr.Any())
{
var subscr = dbSubscr.Single();
subscr.n_subscr = item.Subscr;
subscr.b_ee = item.Ee;
subscr.c_name = item.Name;
subscr.c_inn = item.Inn;
subscr.c_kpp = item.Kpp;
subscr.c_address = item.Address;
subscr.c_post_address = item.PostAddress;
subscr.c_contract = item.Contract;
subscr.d_contract_date = item.ContractDate;
subscr.d_contract_begin = item.Begin;
subscr.d_contract_end = item.End;
subscr.link = item.Link;
if (item.Ee && item.Bank != null)
{
subscr.c_bank_name = item.Bank.Name;
//subscr.c_bank_dep = item.Bank.Dep;
subscr.c_bank_bik = item.Bank.Bik;
subscr.c_bank_inn = item.Bank.Inn;
//subscr.c_bank_ks = item.Bank.Ks;
subscr.c_bank_rs = item.Bank.Rs;
}
db.Update(subscr);
if (item.Configs != null)
{
var configs = new lk_subscr_configs();
var configsData = db.lk_subscr_configs
.Where(p => p.f_subscr == item.Id);
if (configsData.Any())
{
configs = configsData.Single();
configs.c_edo_link = item.Configs.EDO;
if (item.Configs.Manager != null)
{
configs.f_manager = item.Configs.Manager.Id;
}
db.Update(configs);
}
else
{
configs = new lk_subscr_configs()
{
id = Guid.NewGuid(),
f_subscr = item.Id,
n_subscr = item.Subscr,
c_edo_link = item.Configs.EDO
};
if (item.Configs.Manager != null)
{
configs.f_manager = item.Configs.Manager.Id;
}
db.Insert(configs);
}
}
var log = new LogModel
{
PageId = item.Id,
PageName = $"{item.Name}",
Section = LogModule.Subscrs,
Action = LogAction.update
};
InsertLog(log);
tran.Commit();
return(true);
}
return(false);
}
}
}
/// <summary>
/// Создаёт лицевой счёт
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool InsertSubscr(SubscrModel item)
{
using (var db = new CMSdb(_context))
{
using (var tran = db.BeginTransaction())
{
var dbSubscr = db.lk_subscrs
.Where(s => s.id == item.Id || s.n_subscr == item.Subscr);
if (!dbSubscr.Any())
{
var subscr = new lk_subscrs()
{
id = item.Id,
n_subscr = item.Subscr,
b_ee = item.Ee,
c_address = item.Address,
c_post_address = item.PostAddress,
c_contract = item.Contract,
d_contract_date = item.ContractDate,
d_contract_begin = item.Begin,
d_contract_end = item.End,
link = item.Link
};
subscr.c_name = item.Name;
if (item.Bank != null)
{
subscr.c_bank_name = item.Bank.Name;
//subscr.c_bank_dep = item.Bank.Dep;
subscr.c_bank_bik = item.Bank.Bik;
subscr.c_bank_inn = item.Bank.Inn;
//subscr.c_bank_ks = item.Bank.Ks;
subscr.c_bank_rs = item.Bank.Rs;
}
;
db.Insert(subscr);
if (item.Configs != null)
{
var configs = new lk_subscr_configs()
{
id = Guid.NewGuid(),
f_subscr = item.Id,
n_subscr = item.Subscr,
c_edo_link = item.Configs.EDO
};
if (item.Configs.Manager != null)
{
configs.f_manager = item.Configs.Manager.Id;
}
db.Insert(configs);
}
var log = new LogModel
{
PageId = item.Id,
PageName = $"{item.Name}",
Section = LogModule.Subscrs,
Action = LogAction.insert
};
InsertLog(log);
tran.Commit();
return(true);
}
return(false);
}
}
}
