public void DeleteUploadLead(int?UploadLeadId, string username)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
DeleteUploadLeadDetailData(UploadLeadId);
kkslm_tr_upload_lead rd = slmdb.kkslm_tr_upload_lead.Where(r => r.slm_UploadLeadId == UploadLeadId).FirstOrDefault();
// slmdb.kkslm_tr_upload_lead.DeleteObject(rd);
rd.Is_Deleted = 1;
rd.slm_UpdatedBy = username;
rd.slm_UpdatedDate = DateTime.Now;
slmdb.SaveChanges();
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void EditUploadLead(UploadLeadData UploadLead, List <UploadLeadDetailData> UploadLeadDetailData, string username)
{
try
{
using (TransactionScope scope = new TransactionScope())
{
kkslm_tr_upload_lead rk = slmdb.kkslm_tr_upload_lead.Where(r => r.slm_UploadLeadId == UploadLead.slm_UploadLeadId).FirstOrDefault();
rk.slm_LeadCount = UploadLead.slm_LeadCount;
//rk.Status = UploadLead.Status;
//rk.AssignedDate = UploadLead.AssignedDate;
rk.slm_CampaignCode = UploadLead.slm_CampaignCode;
rk.slm_UpdatedBy = username;
rk.slm_UpdatedDate = DateTime.Now;
//slmdb.UploadLead.AddObject(rk);
slmdb.SaveChanges();
//delete old UploadLead_Campaign
List <kkslm_tr_upload_lead_detail> oldUploadLeadDetail = slmdb.kkslm_tr_upload_lead_detail.Where(r => r.slm_UploadLeadId == UploadLead.slm_UploadLeadId).ToList();
if (oldUploadLeadDetail != null)
{
foreach (kkslm_tr_upload_lead_detail orc in oldUploadLeadDetail)
{
slmdb.kkslm_tr_upload_lead_detail.DeleteObject(orc);
slmdb.SaveChanges();
}
}
//add UploadLeadcampaigns
if (UploadLeadDetailData != null)
{
foreach (UploadLeadDetailData rcd in UploadLeadDetailData)
{
//if (slmdb.UploadLeadDetail.Where(r => r.CampaignCode == rcd.CampaignCode && r.CampaignCode == rcd.CampaignName).Count() == 0)
//{
kkslm_tr_upload_lead_detail rc = new kkslm_tr_upload_lead_detail();
rc.slm_UploadLeadId = rcd.slm_UploadLeadId;
rc.slm_ContractBranchName = rcd.slm_ContractBranchName;
rc.slm_OwnerLead = rcd.slm_OwnerLead;
rc.slm_ThaiFirstName = rcd.slm_ThaiFirstName;
rc.slm_ThaiLastName = rcd.slm_ThaiLastName;
rc.slm_CardIdType = rcd.slm_CardIdType;
rc.slm_CardId = rcd.slm_CardId;
rc.slm_CustTelephoneMobile = rcd.slm_CustTelephoneMobile;
rc.slm_CustTelephoneHome = rcd.slm_CustTelephoneHome;
rc.slm_CustTelephoneOther = rcd.slm_CustTelephoneOther;
rc.slm_BrandName = rcd.slm_BrandName;
rc.slm_ModelName = rcd.slm_ModelName;
rc.slm_ModelYear = rcd.slm_ModelYear;
rc.slm_HpBscodeXsell = rcd.slm_HpBscodeXsell;
rc.slm_Remark = rcd.slm_Remark;
rc.slm_TicketID = rcd.slm_TicketID;
slmdb.kkslm_tr_upload_lead_detail.AddObject(rc);
slmdb.SaveChanges();
//}
}
}
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}