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 (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 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 Update()
{
using (EmailListDbContext db = new EmailListDbContext())
{
EmailList emaillist = db.EmailLists.Where(x => x.U_Id == userid && x.Emlist_Id == emaillistid).FirstOrDefault();
try
{
if (listname != emaillist.List_Name)
{
emaillist.List_Name = listname;
}
else if (listdetails != emaillist.List_Dtls)
{
emaillist.List_Dtls = listdetails;
}
else if (emailid != emaillist.Eml_Id)
{
emaillist.Eml_Id = emailid;
}
db.SaveChanges();
ProecessSuccess?.Invoke(null, null);
}
catch (Exception ex)
{
ProcessFailDelegate Failed = ProcessFail;
Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString());
}
}
}
public void Add()
{
using (EmailListDbContext db = new EmailListDbContext())
{
try
{
EmailList emaillist = new EmailList()
{
List_Name = listname,
List_Dtls = listdetails,
Eml_Id = emailid,
Emlist_Id = emaillistid,
U_Id = userid
};
db.EmailLists.Add(emaillist);
db.SaveChangesAsync();
ProecessSuccess?.Invoke(null, null);
}
catch (Exception ex)
{
ProcessFailDelegate Failed = ProcessFail;
Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString());
}
}
}
public void Update()
{
using (EmailDbContext db = new EmailDbContext())
{
Email email = db.Emails.Where(x => x.U_Id == userid && x.Eml_Id == emailid).FirstOrDefault();
try
{
if (firstname != email.F_Name)
{
email.F_Name = firstname;
}
else if (lastname != email.L_Name)
{
email.L_Name = lastname;
}
else if (emailaddress != "")
{
email.Email_Add = emailaddress;
}
db.SaveChanges();
ProecessSuccess?.Invoke(null, null);
}
catch (Exception ex)
{
ProcessFailDelegate Failed = ProcessFail;
Failed?.Invoke("Failed" + Environment.NewLine + ex.ToString());
}
}
}
public void Add()
{
using (EmailDbContext db = new EmailDbContext())
{
try
{
Email email = new Email()
{
F_Name = firstname,
L_Name = lastname,
Email_Add = emailaddress,
Eml_Id = emailid,
U_Id = userid
};
db.Emails.Add(email);
db.SaveChangesAsync();
ProecessSuccess?.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 Delete()
{
using (EmailListDbContext db = new EmailListDbContext())
{
try
{
EmailList emaillist = db.EmailLists.Where(x => x.U_Id == userid && x.Emlist_Id == emaillistid).FirstOrDefault();
db.EmailLists.Remove(emaillist);
db.SaveChangesAsync();
ProecessSuccess?.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());
}
}
}
