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); }