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