public void InsertCampaignList(List <ProductData> productList, string ticketId, string username)
{
try
{
DateTime createdDate = DateTime.Now;
foreach (ProductData campaign in productList)
{
kkslm_tr_campaignfinal camfinal = new kkslm_tr_campaignfinal();
camfinal.slm_TicketId = ticketId;
camfinal.slm_CampaignId = campaign.CampaignId;
camfinal.slm_CampaignName = campaign.CampaignName;
camfinal.slm_Description = campaign.CampaignDesc;
camfinal.slm_CreatedBy = username;
camfinal.slm_CreatedBy_Position = GetPositionId(username, slmdb);
camfinal.slm_CreatedDate = createdDate;
slmdb.kkslm_tr_campaignfinal.AddObject(camfinal);
KKSlmTrHistoryModel.InsertHistory(slmdb, ticketId, SLMConstant.HistoryTypeCode.AddCampaignFinal, "", campaign.CampaignId, username, createdDate);
}
slmdb.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertCampaignList(List <CampaignWSData> CampaignListData, string createByUsername)
{
try
{
if (CampaignListData.Count > 0)
{
for (int i = 0; i < CampaignListData.Count; i++)
{
kkslm_tr_campaignfinal camfinal = new kkslm_tr_campaignfinal();
camfinal.slm_TicketId = CampaignListData[i].TicketId;
camfinal.slm_CampaignId = CampaignListData[i].CampaignId;
camfinal.slm_CampaignName = CampaignListData[i].CampaignName;
camfinal.slm_Description = CampaignListData[i].CampaignDetail;
camfinal.slm_CreatedBy = createByUsername;
camfinal.slm_CreatedBy_Position = GetPositionId(createByUsername, slmdb);
camfinal.slm_CreatedDate = DateTime.Now;
slmdb.kkslm_tr_campaignfinal.AddObject(camfinal);
}
slmdb.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertData(string new_ticketId, ProductData productData, string username, DateTime createdDate)
{
try
{
kkslm_tr_campaignfinal camfinal = new kkslm_tr_campaignfinal();
camfinal.slm_TicketId = new_ticketId;
camfinal.slm_CampaignId = productData.CampaignId;
camfinal.slm_CampaignName = productData.CampaignName;
camfinal.slm_Description = productData.CampaignDesc;
camfinal.slm_CreatedBy = username;
camfinal.slm_CreatedBy_Position = GetPositionId(username, slmdb);
camfinal.slm_CreatedDate = createdDate;
slmdb.kkslm_tr_campaignfinal.AddObject(camfinal);
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertData(CampaignWSData CamData, string createByUsername, DateTime createDate)
{
try
{
kkslm_tr_campaignfinal camfinal = new kkslm_tr_campaignfinal();
camfinal.slm_TicketId = CamData.TicketId;
camfinal.slm_CampaignId = CamData.CampaignId;
camfinal.slm_CampaignName = CamData.CampaignName;
camfinal.slm_Description = CamData.CampaignDetail;
camfinal.slm_CreatedBy = createByUsername;
camfinal.slm_CreatedBy_Position = GetPositionId(createByUsername, slmdb);
camfinal.slm_CreatedDate = createDate;
camfinal.slm_UpdatedBy = createByUsername;
camfinal.slm_UpdatedDate = createDate;
slmdb.kkslm_tr_campaignfinal.AddObject(camfinal);
slmdb.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
