public static bool DeleteEmailList(int listIid)
{
bool Retval = true;
Retval = EmailListToEmail.DeleteEmailsFromList(listIid);
if (Retval == true)
{
string SqlStatement = string.Format("DELETE EMAIL_LIST WHERE ListIid='{0}'", listIid);
Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, ModuleName, "DeleteEmailList");
}
return(Retval);
}
public static bool DeleteOrphans()
{
bool Retval = true;
string SqlStatement = string.Format("DELETE EMAIL_LIST WHERE listType = 1 AND listIid NOT IN (SELECT emailId from REPORT WHERE eMailType = 1)");
Retval = MainClass.ExecuteSql(SqlStatement, true, TableName, ModuleName, "DeleteEmailList");
if (Retval == true)
{
Retval = EmailListToEmail.DeleteOrphans();
}
return(Retval);
}
