public void Add() { using (CampaignDbContext db = new CampaignDbContext()) { try { Campaign campaign = new Campaign() { Camp_Id = campaignid, U_Id = userid, Camp_Dtls = campaigndetails, Camp_ACStat = campaignstatus, Emlist_Id = emaillistid, Sentmail_Count = sentemailcount, Camp_Name = campaignname, Tmp_Id = templateid, Camp_Date = startdate, //Tmp_Body = templatebody, Tmp_Name = templatename, Eml_Subject = subject, Sender_Email = senderemail }; db.Campaigns.Add(campaign); db.SaveChangesAsync(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public void Update() { using (UserDbContext db = new UserDbContext()) { User user = db.Users.Where(x => x.U_Id == userid).FirstOrDefault(); db.Users.Attach(user); try { if (fname != user.FName) { user.FName = fname; } else if (lname != user.LName) { user.LName = lname; } else if (password != user.Pass) { user.Pass = password; } else if (companyname != user.CompanyName) { user.CompanyName = companyname; } db.SaveChangesAsync(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public void Add() { using (UserDbContext db = new UserDbContext()) { try { User user = new User() { U_Id = userid, FName = fname, LName = lname, Email = email, Pass = password, CompanyName = companyname }; db.Users.Add(user); db.SaveChanges(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public void Delete() { using (CampaignDbContext db = new CampaignDbContext()) { try { Campaign campaign = db.Campaigns.Where(x => x.U_Id == userid && x.Camp_Id == campaignid).FirstOrDefault(); db.Campaigns.Remove(campaign); db.SaveChanges(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public void Delete() { using (UserDbContext db = new UserDbContext()) { try { User user = db.Users.Where(x => x.U_Id == userid).FirstOrDefault(); db.Users.Remove(user); db.SaveChanges(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }
public void Update() { using (CampaignDbContext db = new CampaignDbContext()) { Campaign campaign = db.Campaigns.Where(x => x.U_Id == userid && x.Camp_Id == campaignid).FirstOrDefault(); db.Campaigns.Attach(campaign); try { if (campaignstatus != campaign.Camp_ACStat) { campaign.Camp_ACStat = campaignstatus; } else if (campaigndetails != campaign.Camp_Dtls) { campaign.Camp_Dtls = campaigndetails; } else if (emaillistid != campaign.Emlist_Id) { campaign.Emlist_Id = emaillistid; } else if (campaignname != campaign.Camp_Name) { campaign.Camp_Name = campaignname; } else if (templateid != campaign.Tmp_Id) { campaign.Tmp_Id = templateid; } else if (sentemailcount != campaign.Sentmail_Count) { campaign.Sentmail_Count = sentemailcount; } else if (startdate != campaign.Camp_Date) { campaign.Camp_Date = startdate; } else if (senderemail != campaign.Sender_Email) { campaign.Sender_Email = senderemail; } else if (templatename != campaign.Tmp_Name) { campaign.Tmp_Name = templatename; } //else if (templatebody != campaign.Tmp_Body) //{ // campaign.Tmp_Body = templatebody; //} else if (subject != campaign.Eml_Subject) { campaign.Eml_Subject = subject; } db.SaveChangesAsync(); ProcessSuccess?.Invoke(null, null); } catch (Exception ex) { ProcessFailDelegate Failed = ProcessFail; Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString()); } } }