public List <COMPANIEDC> GetCompaniesByRmags(String Rmags, DBConnection Connection) { List <COMPANIEDC> objCOMPANIES = new List <COMPANIEDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_COMPANIES_BY_RMAGS"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_RMAGS", DbType.String, Rmags); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } COMPANIEDC ObjCompany; foreach (DataRow drRow in ds.Tables[0].Rows) { ObjCompany = new COMPANIEDC(); ObjCompany.COMPANY_ID = (int)drRow["COMPANY_ID"]; ObjCompany.COMPANY_NAME = (String)drRow["COMPANY_NAME"]; ObjCompany.RMAG_ID = (int)drRow["RMAG_ID"]; objCOMPANIES.Add(ObjCompany); } return(objCOMPANIES); }
public COMPANIEDC LoadByPrimaryKey(DBConnection Connection, int COMPANY_ID) { COMPANIEDC objCOMPANIE = new COMPANIEDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_COMPANIESLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, COMPANY_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } //objCOMPANIE = FillObject(reader); return(objCOMPANIE); }
public int UpdateCompanyRmags(DBConnection Connection, COMPANIEDC objCompany) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_COMPANIESUpdateCOMPANIES_RMAGS"); SqlDatabase database = (SqlDatabase)Connection.dataBase; DbCommand cmd = database.GetStoredProcCommand(sql.ToString()); database.AddInParameter(cmd, "p_COMPANY_ID", SqlDbType.Int, objCompany.COMPANY_ID); //database.AddInParameter(cmd, "@p_COMPANIES_RMAGS_IDs", SqlDbType.Structured, Utility.CreateIDsTable(objCompany.RMAGS)); //database.AddInParameter(cmd, "p_CREATED_ON", SqlDbType.DateTime, objCompany.CREATED_ON); //database.AddInParameter(cmd, "p_CREATED_BY", SqlDbType.Int, objCompany.CREATED_BY); //database.AddInParameter(cmd, "p_MODIFIED_BY", SqlDbType.Int, objCompany.MODIFIED_BY); if (Connection.Transaction != null) { updateCount = database.ExecuteNonQuery(cmd, Connection.Transaction); } else { updateCount = database.ExecuteNonQuery(cmd); } if (updateCount == 0) { objCompany.IsDirty = IsDirty = true; } return(updateCount); }
private COMPANIEDC FillObject(DataRow row) { COMPANIEDC objCOMPANIE = null; objCOMPANIE = new COMPANIEDC(); objCOMPANIE.COMPANY_ID = (int)row["COMPANY_ID"]; objCOMPANIE.COMPANY_NAME = (String)row["COMPANY_NAME"]; //objCOMPANIE.TOTAL_CUSTOMERS = (long)row["TOTAL_CUSTOMERS"]; //objCOMPANIE.RMAG.RMAG_ID = (int)row["HOME_RMAG"]; //objCOMPANIE.RMAG.RMAG_NAME = (String)row["RMAG_NAME"]; //if (row.Table.Columns.Contains("RMAGS")) //{ // objCOMPANIE.RMAGS = Utility.FillArray(row["RMAGS"] != DBNull.Value ? (String)row["RMAGS"] : ""); //} //if (row.Table.Columns.Contains("RMAGS_NAMES")) //{ // objCOMPANIE.RMAGS_NAMES = row["RMAGS_NAMES"] != DBNull.Value ? (String)row["RMAGS_NAMES"] : ""; //} objCOMPANIE.COMPANY_PHONE_NUMBER = (String)row["COMPANY_PHONE_NUMBER"]; objCOMPANIE.PRIMARY_CONTACT_NAME = (String)row["PRIMARY_CONTACT_NAME"]; objCOMPANIE.PRIMARY_CONTACT_EMAIL = (String)row["PRIMARY_CONTACT_EMAIL"]; objCOMPANIE.COMPANY_CITY = (String)row["COMPANY_CITY"]; objCOMPANIE.COMPANY_STATE = row["COMPANY_STATE"].ToString(); objCOMPANIE.COMPANY_ZIP = (String)row["COMPANY_ZIP"]; objCOMPANIE.COMPANY_ADDRESS = Convert.ToString(row["COMPANY_ADDRESS"]); objCOMPANIE.STATUS = (String)row["STATUS"]; if (row.Table.Columns.Contains("CREATED_ON")) { objCOMPANIE.CREATED_ON = (DateTime)row["CREATED_ON"]; } if (row.Table.Columns.Contains("CREATED_BY")) { objCOMPANIE.CREATED_BY = (int)row["CREATED_BY"]; } if (row.Table.Columns.Contains("MODIFIED_ON")) { objCOMPANIE.MODIFIED_ON = (DateTime)row["MODIFIED_ON"]; } if (row.Table.Columns.Contains("MODIFIED_BY")) { objCOMPANIE.MODIFIED_BY = (int)row["MODIFIED_BY"]; } if (row.Table.Columns.Contains("LOCK_COUNTER")) { objCOMPANIE.LOCK_COUNTER = (!string.IsNullOrEmpty(row["LOCK_COUNTER"].ToString()) ? (int)row["LOCK_COUNTER"] : 0); } objCOMPANIE.BILLING_CONTACT_NAME = Convert.ToString(row["BILLING_CONTACT_NAME"]); objCOMPANIE.BILLING_PHONE = Convert.ToString(row["BILLING_PHONE"]); objCOMPANIE.BILLING_CONTACT_EMAIL = Convert.ToString(row["BILLING_CONTACT_EMAIL"]); objCOMPANIE.PROJECT_DIRECTOR_NAME = Convert.ToString(row["PROJECT_DIRECTOR_NAME"]); objCOMPANIE.PROJECT_DIRECTOR_PHONE = Convert.ToString(row["PROJECT_DIRECTOR_PHONE"]); objCOMPANIE.PROJECT_DIRECTOR_EMAIL = Convert.ToString(row["PROJECT_DIRECTOR_EMAIL"]); objCOMPANIE.PROJECT_MANAGER_NAME = Convert.ToString(row["PROJECT_MANAGER_NAME"]); objCOMPANIE.PROJECT_MANAGER_PHONE = Convert.ToString(row["PROJECT_MANAGER_PHONE"]); objCOMPANIE.PROJECT_MANAGER_EMAIL = Convert.ToString(row["PROJECT_MANAGER_EMAIL"]); return(objCOMPANIE); }
public USERS_COMPANIEDC LoadByUserID(int USER_ID, string accessType, DBConnection Connection) { USERS_COMPANIEDC objUSERS_COMPANIE = new USERS_COMPANIEDC(); StringBuilder sql = new StringBuilder(); sql.Append("[proc_USERS_COMPANIESLoadByUserID]"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_ID", DbType.Int32, USER_ID); dbCommandWrapper.AddInParameter("p_Access_Type", DbType.String, accessType); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } var enumerableDT = ds.Tables[0].AsEnumerable(); var companyIDs = enumerableDT.GroupBy(row => row.Field <int>("COMPANY_ID")); foreach (var compID in companyIDs) { COMPANIEDC objNewComp = new COMPANIEDC(); //var rmags = enumerableDT.Where(row => row.Field<int>("COMPANY_ID") == compID.Key); //foreach (var rmag in rmags) //{ // RMAGDC objNewRmag = new RMAGDC(); // objNewRmag.RMAG_ID = rmag.Field<int>("RMAG_ID"); // objNewRmag.RMAG_NAME = rmag.Field<string>("RMAG_NAME"); // objNewComp.COMPANYRMAGS.Add(objNewRmag); //} var firstRed = enumerableDT.Where(row => row.Field <int>("COMPANY_ID") == compID.Key).FirstOrDefault(); objNewComp.COMPANY_ID = firstRed.Field <int>("COMPANY_ID"); objNewComp.COMPANY_NAME = firstRed.Field <string>("COMPANY_NAME"); objNewComp.PRIMARY_CONTACT_NAME = firstRed.Field <string>("PRIMARY_CONTACT_NAME"); objNewComp.PRIMARY_CONTACT_EMAIL = firstRed.Field <string>("PRIMARY_CONTACT_EMAIL"); objNewComp.COMPANY_CITY = firstRed.Field <string>("COMPANY_CITY"); objNewComp.COMPANY_STATE = firstRed.Field <string>("COMPANY_STATE"); objNewComp.COMPANY_ZIP = firstRed.Field <string>("COMPANY_ZIP"); objNewComp.COMPANY_ADDRESS = firstRed.Field <string>("COMPANY_ADDRESS"); objNewComp.COMPANY_PHONE_NUMBER = firstRed.Field <string>("COMPANY_PHONE_NUMBER"); //objNewComp.HOME_RMAG = firstRed.Field<int>("HOME_RMAG"); //objNewComp.COMPANY_HOME_RMAG_NAME = firstRed.Field<string>("COMPANY_HOME_RMAG_NAME"); objUSERS_COMPANIE.COMPANY.Add(objNewComp); } return(objUSERS_COMPANIE); }
public IHttpActionResult Get(int id) { COMPANIEBL objCompanies = new COMPANIEBL(); COMPANIEDC objResult = new COMPANIEDC(); try { objResult = objCompanies.LoadByPrimaryKey(id); return(Ok(new { objResult })); } catch (Exception ex) { return(new TextResult(ex.Message, Request, ex.StackTrace)); } }
private COMPANIEDC FillObject(IDataReader reader) { COMPANIEDC objCOMPANIE = null; if (reader != null && reader.Read()) { objCOMPANIE = new COMPANIEDC(); objCOMPANIE.COMPANY_ID = (int)reader["COMPANY_ID"]; objCOMPANIE.COMPANY_NAME = (String)reader["COMPANY_NAME"]; //objCOMPANIE.TOTAL_CUSTOMERS = (long)reader["TOTAL_CUSTOMERS"]; //objCOMPANIE.RMAG.RMAG_ID = (int)reader["HOME_RMAG"]; objCOMPANIE.COMPANY_PHONE_NUMBER = (String)reader["COMPANY_PHONE_NUMBER"]; objCOMPANIE.PRIMARY_CONTACT_NAME = (String)reader["PRIMARY_CONTACT_NAME"]; objCOMPANIE.PRIMARY_CONTACT_EMAIL = (String)reader["PRIMARY_CONTACT_EMAIL"]; objCOMPANIE.COMPANY_CITY = (String)reader["COMPANY_CITY"]; objCOMPANIE.COMPANY_STATE = (String)reader["COMPANY_STATE"]; objCOMPANIE.COMPANY_ZIP = (String)reader["COMPANY_ZIP"]; objCOMPANIE.COMPANY_ADDRESS = Convert.ToString(reader["COMPANY_ADDRESS"]); objCOMPANIE.STATUS = (String)reader["STATUS"]; objCOMPANIE.CREATED_ON = (DateTime)reader["CREATED_ON"]; objCOMPANIE.CREATED_BY = (int)reader["CREATED_BY"]; objCOMPANIE.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objCOMPANIE.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objCOMPANIE.LOCK_COUNTER = (!string.IsNullOrEmpty(reader["LOCK_COUNTER"].ToString()) ? (int)reader["LOCK_COUNTER"] : 0); objCOMPANIE.BILLING_CONTACT_NAME = Convert.ToString(reader["BILLING_CONTACT_NAME"]); objCOMPANIE.BILLING_PHONE = Convert.ToString(reader["BILLING_PHONE"]); objCOMPANIE.BILLING_CONTACT_EMAIL = Convert.ToString(reader["BILLING_CONTACT_EMAIL"]); objCOMPANIE.PROJECT_DIRECTOR_NAME = Convert.ToString(reader["PROJECT_DIRECTOR_NAME"]); objCOMPANIE.PROJECT_DIRECTOR_PHONE = Convert.ToString(reader["PROJECT_DIRECTOR_PHONE"]); objCOMPANIE.PROJECT_DIRECTOR_EMAIL = Convert.ToString(reader["PROJECT_DIRECTOR_EMAIL"]); objCOMPANIE.PROJECT_MANAGER_NAME = Convert.ToString(reader["PROJECT_MANAGER_NAME"]); objCOMPANIE.PROJECT_MANAGER_PHONE = Convert.ToString(reader["PROJECT_MANAGER_PHONE"]); objCOMPANIE.PROJECT_MANAGER_EMAIL = Convert.ToString(reader["PROJECT_MANAGER_EMAIL"]); reader.Close(); reader.Dispose(); } return(objCOMPANIE); }
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); }
private int Delete(DBConnection Connection, COMPANIEDC objCOMPANIE) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_COMPANIESDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objCOMPANIE.COMPANY_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }
public List <COMPANIEDC> LoadAllActiveCompanies(DBConnection Connection) { List <COMPANIEDC> objCOMPANIE = new List <COMPANIEDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_ACTIVECOMPANIESLoadAll"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } COMPANIEDC ObjComp; foreach (DataRow drRow in ds.Tables[0].Rows) { ObjComp = new COMPANIEDC(); ObjComp.COMPANY_ID = (int)drRow["COMPANY_ID"]; ObjComp.COMPANY_NAME = (String)drRow["COMPANY_NAME"]; //if (drRow.Table.Columns.Contains("HOME_RMAG")) //{ // ObjComp.HOME_RMAG = (int)drRow["HOME_RMAG"]; //} objCOMPANIE.Add(ObjComp); } return(objCOMPANIE); }
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); }