public int Insert(List <COMPANIEDC> objCOMPANIEs)
{
int insertedCount = 0;
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
try
{
objConnection.Open(true);
insertedCount = Inserts(objConnection, objCOMPANIEs);
if (insertedCount == -1)
{
objConnection.Rollback();
}
else
{
objConnection.Commit();
}
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(insertedCount);
}
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 <COMPANIEDC> objCOMPANIEs, ref List <EXCEPTIONDC> lstExceptions)
{
int updatedCount = 0;
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
try
{
updatedCount = Updates(objCOMPANIEs, ref lstExceptions);
}
catch (Exception ex)
{
throw ex;
}
return(updatedCount);
}
public string CompanyNameString(string companyids)
{
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
string companyNames = string.Empty;
try
{
objConnection.Open(false);
companyNames = objCOMPANIEDA.CompanyNameString(objConnection, companyids);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(companyNames);
}
public List <COMPANIEDC> LoadAllActiveCompanies()
{
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
List <COMPANIEDC> objCOMPANIEDC = null;
try
{
objConnection.Open(false);
objCOMPANIEDC = objCOMPANIEDA.LoadAllActiveCompanies(objConnection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objCOMPANIEDC);
}
public COMPANIEDC LoadByPrimaryKey(int COMPANY_ID)
{
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
COMPANIEDC objCOMPANIEDC = null;
try
{
objConnection.Open(false);
objCOMPANIEDC = objCOMPANIEDA.LoadByPrimaryKey(objConnection, COMPANY_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objCOMPANIEDC);
}
public int Delete(List <COMPANIEDC> objCOMPANIEs)
{
int deletedCount = 0;
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
try
{
objConnection.Open(true);
deletedCount = objCOMPANIEDA.Delete(objConnection, objCOMPANIEs);
objConnection.Commit();
}
catch (Exception ex)
{
objConnection.Rollback();
throw ex;
}
finally
{
objConnection.Close();
}
return(deletedCount);
}
public int Inserts(DBConnection Connection, List <COMPANIEDC> objCOMPANIEs)
{
int isInserted = 0;
COMPANIEDA objCompany = new COMPANIEDA();
foreach (COMPANIEDC objCOMPANIE in objCOMPANIEs)
{
isInserted = objCompany.Insert(Connection, objCOMPANIE);
if (objCOMPANIE.COMPANY_ID == -111)
{
throw new Exception("Client Name '" + objCOMPANIE.COMPANY_NAME + "' already exists. All other changes saved successfully.");
}
if (objCompany.IsDirty)
{
break;
}
}
if (IsDirty)
{
isInserted = -1;
}
return(isInserted);
}
public List <COMPANIEDC> GetCompaniesForExport(string COMPANIES_IDs)
{
DBConnection objConnection = new DBConnection();
COMPANIEDA objCOMPANIEDA = new COMPANIEDA();
List <COMPANIEDC> objCOMPANIEDC = null;
try
{
objConnection.Open(false);
if (!string.IsNullOrEmpty(COMPANIES_IDs) && COMPANIES_IDs.Length > 0)
{
objCOMPANIEDC = objCOMPANIEDA.GetCompaniesForExport(COMPANIES_IDs, objConnection);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objCOMPANIEDC);
}
