public int Delete(DBConnection Connection, ref List <EXCEPTIONDC> lstExceptions, List <DAILYDC> objDAILs)
{
int deleteCount = 0;
foreach (DAILYDC objDAIL in objDAILs)
{
try
{
Connection.Open(true);
deleteCount = Delete(Connection, objDAIL);
Connection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objDAIL.DAILY_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
}
finally { Connection.Close(); }
}
return(deleteCount);
}
public int Delete(DBConnection Connection, List <JOBDC> objMANAGE_JOBs, ref List <EXCEPTIONDC> lstExceptions)
{
int deleteCount = 0;
try
{
foreach (JOBDC objMANAGE_JOB in objMANAGE_JOBs)
{
try
{
Connection.Open(true);
deleteCount = Delete(Connection, objMANAGE_JOB);
Connection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objMANAGE_JOB.JOB_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
Connection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception("Excption Occure");
}
}
catch (Exception exp)
{
throw exp;
}
return(deleteCount);
}
public int Updates(List <COMPANIEDC> objCOMPANIEs, ref List <EXCEPTIONDC> lstExceptions)
{
COMPANIEDA objCompany = new COMPANIEDA();
int updatedCount = 0;
//List<COMPANIES_RMAGDC> objCompRmagsList;
DBConnection objConnection = new DBConnection();
try {
foreach (COMPANIEDC objCOMPANIE in objCOMPANIEs)
{
try
{
objConnection.Open(true);
USERS_COMPANIEBL Usercompany = new USERS_COMPANIEBL();
if (objCOMPANIE.STATUS == "N")
{
int associatedRowscount = Usercompany.CheckCompanyAssociation(objCOMPANIE.COMPANY_ID);
if (associatedRowscount > 0)
{
throw new Exception("Associated record(s) cannot be inactive. All other changes saved successfully.");
}
}
updatedCount = objCompany.Update(objConnection, objCOMPANIE);
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objCOMPANIE.COMPANY_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public int Update(List <JOBDC> objMANAGE_JOBs, ref List <EXCEPTIONDC> lstExceptions, bool OnlyUpdateLatLong = false)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
JOBDA objMANAGE_JOBDA = new JOBDA();
try
{
foreach (JOBDC obj in objMANAGE_JOBs)
{
objConnection.Open(true);
try
{
updatedCount = objMANAGE_JOBDA.Update(objConnection, obj, OnlyUpdateLatLong);
if (obj.IsDirty)
{
break;
}
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = obj.JOB_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public int Update(List <PROJECTDC> objProjects, ref List <EXCEPTIONDC> lstExceptions)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
PROJECTDA projectsDA = new PROJECTDA();
try
{
foreach (PROJECTDC obj in objProjects)
{
objConnection.Open(true);
try
{
updatedCount = projectsDA.Update(objConnection, obj);
if (obj.ISDIRTY)
{
break;
}
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = obj.PROJECT_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public int Update(List <ROLEDC> objROLEs, bool updatePermissions, ref List <EXCEPTIONDC> lstExceptions)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
ROLEDA objROLEDA = new ROLEDA();
try {
foreach (ROLEDC objROLE in objROLEs)
{
objConnection.Open(true);
try {
updatedCount = objROLEDA.Update(objConnection, objROLE, updatePermissions);
IsDirty = objROLEDA.IsDirty;
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objROLE.ROLE_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception("Excption Occure");
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
public int Insert(List <PERMITDC> objPERMITs, ref List <EXCEPTIONDC> lstExceptions)
{
int insertedCount = 0;
DBConnection objConnection = new DBConnection();
PERMITDA objPERMITDA = new PERMITDA();
try
{
foreach (PERMITDC obj in objPERMITs)
{
try
{
objConnection.Open(true);
insertedCount = objPERMITDA.Insert(objConnection, obj);
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = obj.PERMIT_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(insertedCount);
}
public int Delete(List <PERMITDC> objs, ref List <EXCEPTIONDC> lstExceptions)
{
int deleteCount = 0;
DBConnection Connection = new DBConnection();
try
{
PERMITDA objDA = new PERMITDA();
foreach (PERMITDC obj in objs)
{
try
{
Connection.Open(true);
deleteCount = objDA.Delete(Connection, obj);
Connection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = obj.PERMIT_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
Connection.Rollback();
}
}
if (lstExceptions.Count > 0)
{
throw new Exception("Excption Occure");
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
Connection.Close();
}
return(deleteCount);
}
public int Update(List <USERDC> objUSERs, ref List <EXCEPTIONDC> lstExceptions)
{
int updatedCount = 0;
DBConnection objConnection = new DBConnection();
USERDA objUSERDA = new USERDA();
try
{
foreach (USERDC objUSER in objUSERs)
{
objConnection.Open(true);
try
{
objUSER.MODIFIED_ON = DateTime.Now;
updatedCount = objUSERDA.Update(objConnection, objUSER);
if (objUSERDA.IsDirty)
{
break;
}
/// Email sent an Match Complete
int EmailSent = 0;
MESSAGEDC objMsgDC = new MESSAGEDC();
MESSAGEBL objMsgBL = new MESSAGEBL();
List <string> lstUserEmails = new List <string>();
USERDA objUser = new USERDA();
USERDC objUserDC = new USERDC();
objUserDC = objUser.LoadByPrimaryKey(objConnection, objUSER.USER_ID);
// lstUserEmails = objUser.GetUsersEmailAddressByEventId(objUSER.USER_ID, "", 62, objConnection);
//if (lstUserEmails.Count > 0)
//{
Task.Run(() =>
{
//if (!lstUserEmails.Contains(objUSER.EMAIL_ADDRESS))
// lstUserEmails.Add(objUSER.EMAIL_ADDRESS);
StringBuilder strContents = new StringBuilder();
strContents.Append("<!DOCTYPE HTML><html><body><table>");
strContents.Append("<tr><td>Profile for user <b>" + objUSER.USER_NAME + "</b>. has been updated.");
strContents.Append("<tr><td>Please log into the system to verify changes.");
strContents.Append("</table></body></html>");
try
{
objMsgDC.FROM = GetSMTPAdminEmail();
objMsgDC.SUBJECT = "Your profile is changed.";
objMsgDC.CONTENTS = strContents.ToString();
objMsgDC.RECIPIENTS = String.Join(";", objUserDC.EMAIL_ADDRESS);
EmailSent = objMsgBL.SendSMTPEmail(objMsgDC, true);
}
catch (Exception exp)
{
EPay.DataAccess.Utilities.InsertIntoErrorLog("Error: USER PROFILE CHANGED NOTIFICATION EMAIL ", exp.Message + "\r\n" + exp.StackTrace, objUSER.MODIFIED_BY);
}
});
// }
objConnection.Commit();
}
catch (Exception exp)
{
EXCEPTIONDC objExcption = new EXCEPTIONDC();
objExcption.FIELD_ID = objUSER.USER_ID;
objExcption.EXCEPTION_MESSAGE = exp.Message;
objExcption.STACK_TRACK = exp.StackTrace;
lstExceptions.Add(objExcption);
objConnection.Rollback();
// throw exp;
}
}
if (lstExceptions.Count > 0)
{
throw new Exception(lstExceptions[0].EXCEPTION_MESSAGE);
}
}
catch (Exception exp)
{
throw exp;
}
finally
{
objConnection.Close();
}
return(updatedCount);
}
