public ReturnType AddEmailTemplateCat(EmailTemplateCat emailtemplatecat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
alading.AddToEmailTemplateCat(emailtemplatecat);
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.PropertyExisted);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateEmailTemplateCat(EmailTemplateCat emailtemplatecat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*EmailTemplateCat result = alading.EmailTemplateCat.Where(p => p.EmailTemplateCatID == emailtemplatecat.EmailTemplateCatID).FirstOrDefault();*/
EmailTemplateCat result = alading.EmailTemplateCat.Where(p => p.Code == emailtemplatecat.Code).FirstOrDefault();
if (result == null)
{
return(ReturnType.NotExisted);
}
#region Using Attach() Function Update,Default USE;
alading.Attach(result);
alading.ApplyPropertyChanges("EmailTemplateCat", emailtemplatecat);
#endregion
#region Using All Items Replace To Update ,Default UnUse
/*
* result.Code = emailtemplatecat.Code;
* result.Name = emailtemplatecat.Name;
*
*/
#endregion
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType RemoveEmailTemplateCat(string emailtemplatecatCode)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*List<EmailTemplateCat> list = alading.EmailTemplateCat.Where(p => p.EmailTemplateCatID == emailtemplatecatID).ToList();*/
List <EmailTemplateCat> list = alading.EmailTemplateCat.Where(p => p.Code == emailtemplatecatCode).ToList();
if (list.Count == 0)
{
return(ReturnType.NotExisted);
}
else
{
EmailTemplateCat sy = list.First();
//remove all template in the category
if (sy != null)
{
var query = alading.EmailTemplate.Where(c => c.Type == sy.Code);
foreach (var i in query)
{
alading.DeleteObject(i);
}
}
alading.DeleteObject(sy);
alading.SaveChanges();
return(ReturnType.Success);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public ReturnType UpdateEmailTemplateCat(string emailtemplatecatCode, EmailTemplateCat emailtemplatecat)
{
try
{
using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString()))
{
/*var result = alading.EmailTemplateCat.Where(p => p.EmailTemplateCatID == emailtemplatecatID).ToList();*/
var result = alading.EmailTemplateCat.Where(p => p.Code == emailtemplatecatCode).ToList();
if (result.Count == 0)
{
return(ReturnType.NotExisted);
}
EmailTemplateCat ob = result.First();
ob.Code = emailtemplatecat.Code;
ob.Name = emailtemplatecat.Name;
if (alading.SaveChanges() == 1)
{
return(ReturnType.Success);
}
else
{
return(ReturnType.OthersError);
}
}
}
catch (SqlException sex)
{
return(ReturnType.ConnFailed);
}
catch (System.Exception ex)
{
return(ReturnType.OthersError);
}
}
public static ReturnType UpdateEmailTemplateCat(string emailtemplatecatCode, EmailTemplateCat emailtemplatecat)
{
return(DataProviderClass.Instance().UpdateEmailTemplateCat(emailtemplatecatCode, emailtemplatecat));
}
public static ReturnType AddEmailTemplateCat(EmailTemplateCat emailtemplatecat)
{
return(DataProviderClass.Instance().AddEmailTemplateCat(emailtemplatecat));
}
