public int Update(DBConnection Connection, COMPANIEDC objCOMPANIE)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_COMPANIESUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objCOMPANIE.COMPANY_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_NAME", DbType.String, objCOMPANIE.COMPANY_NAME);
//dbCommandWrapper.AddInParameter("p_TOTAL_CUSTOMERS", DbType.Int64, objCOMPANIE.TOTAL_CUSTOMERS);
//dbCommandWrapper.AddInParameter("p_HOME_RMAG", DbType.Int32, objCOMPANIE.HOME_RMAG);
dbCommandWrapper.AddInParameter("p_COMPANY_PHONE_NUMBER", DbType.String, objCOMPANIE.COMPANY_PHONE_NUMBER);
dbCommandWrapper.AddInParameter("p_PRIMARY_CONTACT_NAME", DbType.String, objCOMPANIE.PRIMARY_CONTACT_NAME);
dbCommandWrapper.AddInParameter("p_PRIMARY_CONTACT_EMAIL", DbType.String, objCOMPANIE.PRIMARY_CONTACT_EMAIL);
dbCommandWrapper.AddInParameter("p_COMPANY_CITY", DbType.String, objCOMPANIE.COMPANY_CITY);
if (!string.IsNullOrEmpty(objCOMPANIE.COMPANY_STATE))
{
dbCommandWrapper.AddInParameter("p_COMPANY_STATE", DbType.String, objCOMPANIE.COMPANY_STATE);
}
else
{
dbCommandWrapper.AddInParameter("p_COMPANY_STATE", DbType.String, DBNull.Value);
}
dbCommandWrapper.AddInParameter("p_COMPANY_ZIP", DbType.String, objCOMPANIE.COMPANY_ZIP);
dbCommandWrapper.AddInParameter("p_COMPANY_ADDRESS", DbType.String, objCOMPANIE.COMPANY_ADDRESS);
dbCommandWrapper.AddInParameter("p_STATUS", DbType.String, objCOMPANIE.STATUS);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objCOMPANIE.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objCOMPANIE.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objCOMPANIE.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objCOMPANIE.MODIFIED_BY);
//dbCommandWrapper.AddInParameter("p_RMAGS", DbType.String, string.Join(",", objCOMPANIE.RMAGS));
dbCommandWrapper.AddInParameter("p_BILLING_CONTACT_NAME", DbType.String, objCOMPANIE.BILLING_CONTACT_NAME);
dbCommandWrapper.AddInParameter("p_BILLING_PHONE", DbType.String, objCOMPANIE.BILLING_PHONE);
dbCommandWrapper.AddInParameter("p_BILLING_CONTACT_EMAIL", DbType.String, objCOMPANIE.BILLING_CONTACT_EMAIL);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_NAME", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_NAME);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_PHONE", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_PHONE);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_EMAIL", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_EMAIL);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_NAME", DbType.String, objCOMPANIE.PROJECT_MANAGER_NAME);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_PHONE", DbType.String, objCOMPANIE.PROJECT_MANAGER_PHONE);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_EMAIL", DbType.String, objCOMPANIE.PROJECT_MANAGER_EMAIL);
dbCommandWrapper.AddInParameter("p_lock_counter", DbType.Int32, objCOMPANIE.LOCK_COUNTER);
try
{
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objCOMPANIE.IsDirty = IsDirty = true;
throw new Exception(Constants.ConcurrencyMessageSingleRow);
}
}
catch (Exception exp)
{
// Utilities.InsertIntoErrorLog("Error: CLIENTS UPDATE ", exp.Message + "\r\n" + exp.StackTrace, objCOMPANIE.MODIFIED_BY);
objCOMPANIE.SetError(exp);
throw exp;
}
return(updateCount);
}
public int Insert(DBConnection Connection, COMPANIEDC objCOMPANIE)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_COMPANIESInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddOutParameter("p_COMPANY_ID", DbType.Int32, objCOMPANIE.COMPANY_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_NAME", DbType.String, objCOMPANIE.COMPANY_NAME);
//dbCommandWrapper.AddInParameter("p_TOTAL_CUSTOMERS", DbType.Int64, objCOMPANIE.TOTAL_CUSTOMERS);
//dbCommandWrapper.AddInParameter("p_HOME_RMAG", DbType.Int32, objCOMPANIE.HOME_RMAG);
dbCommandWrapper.AddInParameter("p_COMPANY_PHONE_NUMBER", DbType.String, objCOMPANIE.COMPANY_PHONE_NUMBER);
dbCommandWrapper.AddInParameter("p_PRIMARY_CONTACT_NAME", DbType.String, objCOMPANIE.PRIMARY_CONTACT_NAME);
dbCommandWrapper.AddInParameter("p_PRIMARY_CONTACT_EMAIL", DbType.String, objCOMPANIE.PRIMARY_CONTACT_EMAIL);
dbCommandWrapper.AddInParameter("p_COMPANY_CITY", DbType.String, objCOMPANIE.COMPANY_CITY);
if (!string.IsNullOrEmpty(objCOMPANIE.COMPANY_STATE))
{
dbCommandWrapper.AddInParameter("p_COMPANY_STATE", DbType.String, objCOMPANIE.COMPANY_STATE);
}
else
{
dbCommandWrapper.AddInParameter("p_COMPANY_STATE", DbType.String, DBNull.Value);
}
dbCommandWrapper.AddInParameter("p_COMPANY_ZIP", DbType.String, objCOMPANIE.COMPANY_ZIP);
dbCommandWrapper.AddInParameter("p_COMPANY_ADDRESS", DbType.String, objCOMPANIE.COMPANY_ADDRESS);
dbCommandWrapper.AddInParameter("p_STATUS", DbType.String, objCOMPANIE.STATUS);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objCOMPANIE.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objCOMPANIE.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objCOMPANIE.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objCOMPANIE.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_BILLING_CONTACT_NAME", DbType.String, objCOMPANIE.BILLING_CONTACT_NAME);
dbCommandWrapper.AddInParameter("p_BILLING_PHONE", DbType.String, objCOMPANIE.BILLING_PHONE);
dbCommandWrapper.AddInParameter("p_BILLING_CONTACT_EMAIL", DbType.String, objCOMPANIE.BILLING_CONTACT_EMAIL);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_NAME", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_NAME);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_PHONE", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_PHONE);
dbCommandWrapper.AddInParameter("p_PROJECT_DIRECTOR_EMAIL", DbType.String, objCOMPANIE.PROJECT_DIRECTOR_EMAIL);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_NAME", DbType.String, objCOMPANIE.PROJECT_MANAGER_NAME);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_PHONE", DbType.String, objCOMPANIE.PROJECT_MANAGER_PHONE);
dbCommandWrapper.AddInParameter("p_PROJECT_MANAGER_EMAIL", DbType.String, objCOMPANIE.PROJECT_MANAGER_EMAIL);
try
{
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
}
catch (Exception exp)
{
//Utilities.InsertIntoErrorLog("Error: CLIENTS INSERTION ", exp.Message + "\r\n" + exp.StackTrace, objCOMPANIE.MODIFIED_BY);
objCOMPANIE.SetError(exp);
throw exp;
}
objCOMPANIE.COMPANY_ID = (int)dbCommandWrapper.DBCommand.Parameters["@p_COMPANY_ID"].Value;
return(insertCount);
}
