/// <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); } } }