private int Insert(DBConnection Connection, USERS_COMPANIEDC objUSERS_COMPANIE)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_USERS_COMPANIESInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_USER_ID", DbType.Int32, objUSERS_COMPANIE.USER_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objUSERS_COMPANIE.COMPANY_ID);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
private USERS_COMPANIEDC FillObject(DataRow row)
{
USERS_COMPANIEDC objUSERS_COMPANIE = null;
objUSERS_COMPANIE = new USERS_COMPANIEDC();
objUSERS_COMPANIE.USER_ID = (int)row["USER_ID"];
objUSERS_COMPANIE.COMPANY_ID = (int)row["COMPANY_ID"];
return(objUSERS_COMPANIE);
}
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);
}
private USERS_COMPANIEDC FillObject(IDataReader reader)
{
USERS_COMPANIEDC objUSERS_COMPANIE = null;
if (reader != null && reader.Read())
{
objUSERS_COMPANIE = new USERS_COMPANIEDC();
objUSERS_COMPANIE.USER_ID = (int)reader["USER_ID"];
objUSERS_COMPANIE.COMPANY_ID = (int)reader["COMPANY_ID"];
reader.Close();
reader.Dispose();
}
return(objUSERS_COMPANIE);
}
public IHttpActionResult GetByUserID(int userID, string accessType)
{
USERS_COMPANIEBL objUserCompanies = new USERS_COMPANIEBL();
USERS_COMPANIEDC objResultList = new USERS_COMPANIEDC();
try
{
objResultList = objUserCompanies.LoadByUserID(userID, accessType);
return(Ok(new { objResultList }));
}
catch (Exception ex)
{
return(new TextResult(ex.Message, Request, ex.StackTrace));
}
}
public int CheckCompanyAssociation(int CompanyID, DBConnection Connection)
{
USERS_COMPANIEDC objUSERS_COMPANIE = new USERS_COMPANIEDC();
StringBuilder sql = new StringBuilder();
int associatedRowsCount = 0;
sql.Append("[proc_CheckCompanyAssociation]");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("CompanyID", DbType.Int32, CompanyID);
associatedRowsCount = Convert.ToInt32(Connection.dataBase.ExecuteScalar(dbCommandWrapper.DBCommand));
return(associatedRowsCount);
}
public USERS_COMPANIEDC LoadByUserID(int USER_ID, string accessType)
{
DBConnection objConnection = new DBConnection();
USERS_COMPANIEDA objUSERS_COMPANIEDA = new USERS_COMPANIEDA();
USERS_COMPANIEDC objUSERS_COMPANIEDC = null;
try
{
objConnection.Open(false);
objUSERS_COMPANIEDC = objUSERS_COMPANIEDA.LoadByUserID(USER_ID, accessType, objConnection);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objUSERS_COMPANIEDC);
}
