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