public void UpdateSeq(List <RankingData> rankingdatas, string username)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
foreach (RankingData rankingdata in rankingdatas)
{
kkcoc_tr_ranking rd = slmdb.kkcoc_tr_ranking.Where(r => r.coc_RankingId == rankingdata.coc_RankingId).FirstOrDefault();
if (rd.coc_Seq != rankingdata.coc_Seq)
{
rd.coc_Seq = rankingdata.coc_Seq;
rd.coc_UpdatedBy = username;
rd.coc_UpdatedDate = DateTime.Now;
slmdb.SaveChanges();
}
}
//Save and discard changes
//if we get here things are looking good.
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteRanking(int?rankingId, string username)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
DeleteRankingCampaignData(rankingId);
DeleteRankingDealerData(rankingId);
kkcoc_tr_ranking rd = slmdb.kkcoc_tr_ranking.Where(r => r.coc_RankingId == rankingId).FirstOrDefault();
int?seq = rd.coc_Seq;
List <kkcoc_tr_ranking> rds = slmdb.kkcoc_tr_ranking.Where(r => r.coc_Seq > seq).ToList();
if (rds != null)
{
foreach (kkcoc_tr_ranking r in rds)
{
r.coc_Seq--;
slmdb.SaveChanges();
}
}
rd.Is_Delete = true;
rd.coc_UpdatedBy = username;
rd.coc_UpdatedDate = DateTime.Now;
//slmdb.kkcoc_tr_ranking.DeleteObject(rd);
slmdb.SaveChanges();
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void EditRanking(RankingData ranking, List <RankingCampaignData> rankingcampaigns, List <RankingDealerData> rankingdealers, string username)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
kkcoc_tr_ranking rk = slmdb.kkcoc_tr_ranking.Where(r => r.coc_RankingId == ranking.coc_RankingId).FirstOrDefault();
rk.coc_Name = ranking.coc_Name;
rk.coc_SkipDate = ranking.coc_SkipDate;
rk.coc_UpdatedBy = username;
rk.coc_UpdatedDate = DateTime.Now;
//slmdb.Ranking.AddObject(rk);
slmdb.SaveChanges();
//delete old Ranking_Campaign
List <kkcoc_tr_ranking_campaign> oldRanking_Campaign = slmdb.kkcoc_tr_ranking_campaign.Where(r => r.coc_RankingId == ranking.coc_RankingId).ToList();
if (oldRanking_Campaign != null)
{
foreach (kkcoc_tr_ranking_campaign orc in oldRanking_Campaign)
{
slmdb.kkcoc_tr_ranking_campaign.DeleteObject(orc);
slmdb.SaveChanges();
}
}
//delete old Ranking_Dealer
List <kkcoc_tr_ranking_dealer> oldRanking_Dealer = slmdb.kkcoc_tr_ranking_dealer.Where(r => r.coc_RankingId == ranking.coc_RankingId).ToList();
if (oldRanking_Dealer != null)
{
foreach (kkcoc_tr_ranking_dealer ord in oldRanking_Dealer)
{
slmdb.kkcoc_tr_ranking_dealer.DeleteObject(ord);
slmdb.SaveChanges();
}
}
//add rankingcampaigns
if (rankingcampaigns != null)
{
foreach (RankingCampaignData rcd in rankingcampaigns)
{
if (slmdb.kkcoc_tr_ranking_campaign.Where(r => r.coc_CampaignCode == rcd.coc_CampaignCode && r.coc_CampaignCode == rcd.coc_CampaignName).Count() == 0)
{
kkcoc_tr_ranking_campaign rc = new kkcoc_tr_ranking_campaign();
rc.coc_RankingId = rk.coc_RankingId;
rc.coc_CampaignCode = rcd.coc_CampaignCode;
rc.coc_CampaignName = rcd.coc_CampaignName;
slmdb.kkcoc_tr_ranking_campaign.AddObject(rc);
slmdb.SaveChanges();
}
}
}
//add rankingdealers
if (rankingdealers != null)
{
foreach (RankingDealerData rdd in rankingdealers)
{
if (slmdb.kkcoc_tr_ranking_dealer.Where(r => r.coc_DealerCode == rdd.coc_DealerCode && r.coc_DealerName == rdd.coc_DealerName).Count() == 0)
{
kkcoc_tr_ranking_dealer rd = new kkcoc_tr_ranking_dealer();
rd.coc_RankingId = rk.coc_RankingId;
rd.coc_DealerCode = rdd.coc_DealerCode;
rd.coc_DealerName = rdd.coc_DealerName;
slmdb.kkcoc_tr_ranking_dealer.AddObject(rd);
slmdb.SaveChanges();
}
}
}
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int AddRanking(RankingData ranking, List <RankingCampaignData> rankingcampaigns, List <RankingDealerData> rankingdealers, string username)
{
try
{
int key = 0;
using (TransactionScope scope = new TransactionScope())
{
int?maxSeq = maxSeqRankingData();
if (maxSeq == null)
{
ranking.coc_Seq = 0;
kkcoc_tr_ranking rk = new kkcoc_tr_ranking();
rk.coc_Seq = 1;
rk.coc_Name = ranking.coc_Name;
rk.coc_SkipDate = ranking.coc_SkipDate;
rk.coc_UpdatedBy = username;
rk.coc_UpdatedDate = DateTime.Now;
rk.coc_CreatedBy = username;
rk.coc_CreatedDate = DateTime.Now;
slmdb.kkcoc_tr_ranking.AddObject(rk);
slmdb.SaveChanges();
key = rk.coc_RankingId;
}
else
{
kkcoc_tr_ranking maxRanking = slmdb.kkcoc_tr_ranking.Where(r => r.coc_Seq == maxSeq).FirstOrDefault();
maxRanking.coc_Seq = maxSeq + 1;
slmdb.SaveChanges();
//ranking.Seq = maxSeq;
kkcoc_tr_ranking rk = new kkcoc_tr_ranking();
rk.coc_Seq = maxSeq;
rk.coc_Name = ranking.coc_Name;
rk.coc_SkipDate = ranking.coc_SkipDate;
rk.coc_UpdatedBy = username;
rk.coc_UpdatedDate = DateTime.Now;
rk.coc_CreatedBy = username;
rk.coc_CreatedDate = DateTime.Now;
slmdb.kkcoc_tr_ranking.AddObject(rk);
slmdb.SaveChanges();
key = rk.coc_RankingId;
if (rankingcampaigns != null)
{
foreach (RankingCampaignData rcd in rankingcampaigns)
{
if (slmdb.kkcoc_tr_ranking_campaign.Where(r => r.coc_CampaignCode == rcd.coc_CampaignCode && r.coc_CampaignCode == rcd.coc_CampaignName).Count() == 0)
{
kkcoc_tr_ranking_campaign rc = new kkcoc_tr_ranking_campaign();
rc.coc_RankingId = rk.coc_RankingId;
rc.coc_CampaignCode = rcd.coc_CampaignCode;
rc.coc_CampaignName = rcd.coc_CampaignName;
slmdb.kkcoc_tr_ranking_campaign.AddObject(rc);
slmdb.SaveChanges();
}
}
}
//add rankingdealers
if (rankingdealers != null)
{
foreach (RankingDealerData rdd in rankingdealers)
{
if (slmdb.kkcoc_tr_ranking_dealer.Where(r => r.coc_DealerCode == rdd.coc_DealerCode && r.coc_DealerName == rdd.coc_DealerName).Count() == 0)
{
kkcoc_tr_ranking_dealer rd = new kkcoc_tr_ranking_dealer();
rd.coc_RankingId = rk.coc_RankingId;
rd.coc_DealerCode = rdd.coc_DealerCode;
rd.coc_DealerName = rdd.coc_DealerName;
slmdb.kkcoc_tr_ranking_dealer.AddObject(rd);
slmdb.SaveChanges();
}
}
}
}
//add rankingcampaigns
scope.Complete();
return(key);
}
}
catch (Exception ex)
{
throw ex;
}
}
