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 EmailList GetList()
{
using (EmailListDbContext db = new EmailListDbContext())
{
return(db.EmailLists.Where(x => x.U_Id == userid && x.Emlist_Id == emaillistid).FirstOrDefault());
}
}
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 List <EmailList> GetAllLists()
{
using (EmailListDbContext db = new EmailListDbContext())
{
return(db.EmailLists.Where(x => x.U_Id == userid).ToList());
}
}
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());
}
}
}
