public void AddBuzRules(tbl_BusinessRule tblbuzrules) { try { IGenericDataRepository <tbl_BusinessRule> repository = new GenericDataRepository <tbl_BusinessRule>(); repository.Add(tblbuzrules); } catch (Exception) { throw; } }
public int SaveBusinessRulesData(IList <BusinessRulesViewModel> buzrules, int daId) { try { int result = 0; BusinessRulesManager buzrulesManager = new BusinessRulesManager(); List <tbl_BusinessRule> lstBusinessRules = new List <tbl_BusinessRule>(); List <tbl_BuzRulesAttrMapping> lstBuzRulesAttrMapping = new List <tbl_BuzRulesAttrMapping>(); var AllBuzRules = buzrules.GroupBy(b => b.BuzRuleAttrMapID); foreach (var buz in AllBuzRules) { tbl_BuzRulesAttrMapping tblbuzruleattrmapping = new tbl_BuzRulesAttrMapping(); if ((buz.Key.ToString().Length > 5) && (buz.Key.ToString().Substring(buz.Key.ToString().Length - 2, 2) == "00")) { #region Add New Business Rules int cnt = 1; var cur = buzrules.Where(e => e.BuzRuleAttrMapID == buz.Key && e.IsLinked.Equals(true)); //Querying checked highlevel transactions and BuzruleAttrMapID marked new foreach (var HighTrans in cur) { if (cnt == 1) { AttributesMapping(ref tblbuzruleattrmapping, HighTrans); tblbuzruleattrmapping.EntityState = DA.DomainModel.EntityState.Added; } cnt++; tbl_BusinessRule businessrule = new tbl_BusinessRule(); businessrule.daId = daId; businessrule.TransactionSeq = HighTrans.TransactionSeq; businessrule.tbl_BuzRulesAttrMapping = tblbuzruleattrmapping; businessrule.EntityState = DA.DomainModel.EntityState.Added; tblbuzruleattrmapping.tbl_BusinessRule.Add(businessrule); } lstBuzRulesAttrMapping.Add(tblbuzruleattrmapping); #endregion } else { #region AddModifyDelete Business Rules int cnt1 = 1; var cur = buzrules.Where(e => e.BuzRuleAttrMapID == buz.Key && (e.IsLinked.Equals(true) || e.BuzRuleID != 0)); //Querying checked highlevel transactions and BuzruleID existed foreach (var HighTrans in cur) { if (cnt1 == 1) { tblbuzruleattrmapping.BuzRulesAttrMapID = HighTrans.BuzRuleAttrMapID; AttributesMapping(ref tblbuzruleattrmapping, HighTrans); tblbuzruleattrmapping.EntityState = DA.DomainModel.EntityState.Modified; } cnt1++; tbl_BusinessRule businessrule = new tbl_BusinessRule(); businessrule.daId = daId; businessrule.TransactionSeq = HighTrans.TransactionSeq; businessrule.BuzRuleAttrMapID = HighTrans.BuzRuleAttrMapID; businessrule.BuzRuleID = HighTrans.BuzRuleID; if ((HighTrans.BuzRuleID != 0) && (HighTrans.IsLinked == true)) { businessrule.EntityState = DA.DomainModel.EntityState.Unchanged; } else if ((HighTrans.BuzRuleID == 0) && (HighTrans.IsLinked == true)) { businessrule.EntityState = DA.DomainModel.EntityState.Added; } else if ((HighTrans.BuzRuleID != 0) && (HighTrans.IsLinked == false)) { businessrule.EntityState = DA.DomainModel.EntityState.Deleted; } tblbuzruleattrmapping.tbl_BusinessRule.Add(businessrule); } lstBuzRulesAttrMapping.Add(tblbuzruleattrmapping); #endregion } } result = buzrulesManager.SaveBuzRulesDataMapping(lstBuzRulesAttrMapping); return(result); } catch (Exception) { throw; } }
public void DeleteBuzrulattrmap(int id) { try { tbl_BusinessRule objBusinessRule = new tbl_BusinessRule(); tbl_BuzRulesAttrMapping objtblBuzRuleAttrMap = new tbl_BuzRulesAttrMapping(); IGenericDataRepository <tbl_BusinessRule> repository = new GenericDataRepository <tbl_BusinessRule>(); IGenericDataRepository <tbl_BuzRulesAttrMapping> repository1 = new GenericDataRepository <tbl_BuzRulesAttrMapping>(); IList <tbl_BusinessRule> lstBusinessRule = repository.GetList(q => q.BuzRuleID == id); if (lstBusinessRule != null) { foreach (var item in lstBusinessRule) { objBusinessRule.BuzRuleID = item.BuzRuleID; objBusinessRule.BuzRuleAttrMapID = item.BuzRuleAttrMapID; objBusinessRule.daId = item.daId; objBusinessRule.TransactionSeq = item.TransactionSeq; objBusinessRule.EntityState = EntityState.Deleted; var buzruleId = item.BuzRuleAttrMapID; IList <tbl_BuzRulesAttrMapping> lstBuzRuleMapId = repository1.GetList(q => q.BuzRulesAttrMapID.Equals(item.BuzRuleAttrMapID)); if (lstBuzRuleMapId != null) { foreach (var item1 in lstBuzRuleMapId) { objtblBuzRuleAttrMap.AttrID1 = item1.AttrID1; objtblBuzRuleAttrMap.AttrID2 = item1.AttrID2; objtblBuzRuleAttrMap.AttrID3 = item1.AttrID3; objtblBuzRuleAttrMap.AttrID4 = item1.AttrID4; objtblBuzRuleAttrMap.AttrID5 = item1.AttrID5; objtblBuzRuleAttrMap.AttrID6 = item1.AttrID6; objtblBuzRuleAttrMap.AttrID7 = item1.AttrID7; objtblBuzRuleAttrMap.AttrID8 = item1.AttrID8; objtblBuzRuleAttrMap.AttrID9 = item1.AttrID9; objtblBuzRuleAttrMap.AttrID10 = item1.AttrID10; objtblBuzRuleAttrMap.AttrValueID1 = item1.AttrValueID1; objtblBuzRuleAttrMap.AttrValueID2 = item1.AttrValueID2; objtblBuzRuleAttrMap.AttrValueID3 = item1.AttrValueID3; objtblBuzRuleAttrMap.AttrValueID4 = item1.AttrValueID4; objtblBuzRuleAttrMap.AttrValueID5 = item1.AttrValueID5; objtblBuzRuleAttrMap.AttrValueID6 = item1.AttrValueID6; objtblBuzRuleAttrMap.AttrValueID7 = item1.AttrValueID7; objtblBuzRuleAttrMap.AttrValueID8 = item1.AttrValueID8; objtblBuzRuleAttrMap.AttrValueID9 = item1.AttrValueID9; objtblBuzRuleAttrMap.AttrValueID10 = item1.AttrValueID10; objtblBuzRuleAttrMap.BuzRuleDesc = item1.BuzRuleDesc; objtblBuzRuleAttrMap.BuzRulesAttrMapID = item1.BuzRulesAttrMapID; objtblBuzRuleAttrMap.Remarks = item1.Remarks; objtblBuzRuleAttrMap.ReqReference = item1.ReqReference; objtblBuzRuleAttrMap.EntityState = EntityState.Deleted; repository1.Remove(objtblBuzRuleAttrMap); } } repository.Remove(objBusinessRule); } } } catch (Exception) { throw; } }