public List <string> GetUsersEmailAddressByEventId(int eventid, String eventtype, int notificationtype, DBConnection Connection)
{
List <string> emailAddresses = new List <string>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_USERSGetEmailAddressByEventID");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_EVENT_OR_USER_ID", DbType.Int32, eventid);
dbCommandWrapper.AddInParameter("p_EVENT_TYPE", DbType.String, eventtype);
dbCommandWrapper.AddInParameter("p_NOTIFICATION_TYPE", DbType.Int32, notificationtype);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow row in ds.Tables[0].Rows)
{
emailAddresses.Add(Convert.ToString(row["EMAIL_ADDRESS"]));
}
return(emailAddresses);
}
public USERDC AuthenticateUser(DBConnection Connection, string username, string password)
{
password = Encryptor.Encrypt(password);
USERDC objUSER = new USERDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_USERSLoadByUserNamePassword");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_USER_NAME", DbType.String, username);
dbCommandWrapper.AddInParameter("p_PASSWORD", DbType.String, password);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
if (ds.Tables[0].Rows.Count > 0)
{
objUSER = (FillObject(ds.Tables[0].Rows[0]));
}
return(objUSER);
}
public int UpdateUserLoginStatus(string UserName, string LoginStatus, DBConnection Connection)
{
int IsUpdated = 0;
List <USERDC> objUSER = new List <USERDC>();
USERDC ObjUserDC;
StringBuilder sql = new StringBuilder();
sql.Append("proc_UpdateUSERLOGINSTATUS");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_USER_NAME", DbType.String, UserName);
dbCommandWrapper.AddInParameter("p_STATUS", DbType.String, LoginStatus);
if (Connection.Transaction != null)
{
IsUpdated = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
IsUpdated = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(IsUpdated);
}
private int Insert(DBConnection Connection, MESSAGES_COMPANIEDC objMESSAGES_COMPANIE)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_MESSAGES_COMPANIESInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MESSAGE_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_COMPANY_ID);
dbCommandWrapper.AddInParameter("p_MESSAGE_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.COMPANY_ID);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
public List <ATTACHMENTDC> LoadAllJobAttachments(DBConnection Connection, string projectIDs = "All", string attachmentTypeIDs = "All")
{
List <ATTACHMENTDC> objATTACHMENT = new List <ATTACHMENTDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_JOB_ATTACHMENTSLoadAll");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_projectIDs", DbType.String, projectIDs);
dbCommandWrapper.AddInParameter("p_attachmentTypeIDs", DbType.String, attachmentTypeIDs);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objATTACHMENT.Add(FillJobAttachmentObject(drRow));
}
return(objATTACHMENT);
}
public int Insert(DBConnection Connection, WORK_DETAILDC objWORK_DETAIL_VALU)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_WORK_DETAIL_VALUEInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddOutParameter("p_WORK_DETAIL_VALUE_ID", DbType.Int32, objWORK_DETAIL_VALU.WORK_DETAIL_VALUE_ID);
dbCommandWrapper.AddInParameter("p_WORK_DETAIL_ID", DbType.Int32, objWORK_DETAIL_VALU.WORK_DETAIL_ID);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objWORK_DETAIL_VALU.DAILY_ID);
dbCommandWrapper.AddInParameter("p_PERFORMED", DbType.String, objWORK_DETAIL_VALU.PERFORMED);
dbCommandWrapper.AddInParameter("p_UNITS", DbType.Decimal, objWORK_DETAIL_VALU.UNITS);
dbCommandWrapper.AddInParameter("p_COMMENTS", DbType.String, objWORK_DETAIL_VALU.COMMENTS);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objWORK_DETAIL_VALU.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objWORK_DETAIL_VALU.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objWORK_DETAIL_VALU.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objWORK_DETAIL_VALU.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objWORK_DETAIL_VALU.LOCK_COUNTER);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
public List <JOBDC> MapJobsLoadByFilters(DBConnection Connection, string projectIDs, string jobStatusIDs, string clientIDs = "All")
{
List <JOBDC> objMANAGE_JOB = new List <JOBDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_MAP_JOBSLoadByFilters");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ProjectIDs", DbType.String, projectIDs);
dbCommandWrapper.AddInParameter("p_JobStatusIDs", DbType.String, jobStatusIDs);
dbCommandWrapper.AddInParameter("p_clientIDs", DbType.String, clientIDs);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objMANAGE_JOB.Add(FillObject(drRow));
}
return(objMANAGE_JOB);
}
public JOBDC LoadByKey(DBConnection Connection, int PROJECT_ID, int JOB_FILE_NUMBER)
{
JOBDC objMANAGE_JOB = new JOBDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_MANAGE_JOBSLoadByKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PROJECT_ID", DbType.Int32, PROJECT_ID);
dbCommandWrapper.AddInParameter("p_JOB_FILE_NUMBER", DbType.String, JOB_FILE_NUMBER);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objMANAGE_JOB = FillObject(reader);
return(objMANAGE_JOB);
}
//=================================================================
// public Function LoadAll() As Boolean
//=================================================================
// Loads all of the records in the database, and sets the currentRow to the first row
//=================================================================
public List <PROJECTDC> LoadAll(DBConnection Connection, string clientIDs = "All", string projectStatusIDs = "All")
{
List <PROJECTDC> objPROJECT = new List <PROJECTDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PROJECTSLoadAll");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_clientIDs", DbType.String, clientIDs);
dbCommandWrapper.AddInParameter("p_projectStatusIDs", DbType.String, projectStatusIDs);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objPROJECT.Add(FillObject(drRow));
}
return(objPROJECT);
}
public RoleTaskPermDC LoadByPrimaryKey(DBConnection Connection, string RoleID, string TaskID)
{
RoleTaskPermDC objRoleTaskPerm = new RoleTaskPermDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_RoleTaskPermsLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_RoleID", DbType.String, RoleID);
dbCommandWrapper.AddInParameter("p_TaskID", DbType.String, TaskID);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objRoleTaskPerm = FillObject(reader);
return(objRoleTaskPerm);
}
private int Update(DBConnection Connection, LOOK_UPDC objLOOK_UP)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_LOOK_UPSUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_LOOK_UP_ID", DbType.Int32, objLOOK_UP.LOOK_UP_ID);
dbCommandWrapper.AddInParameter("p_LU_NAME", DbType.String, objLOOK_UP.LU_NAME);
dbCommandWrapper.AddInParameter("p_LU_TYPE", DbType.String, objLOOK_UP.LU_TYPE);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objLOOK_UP.IsDirty = IsDirty = true;
}
return(updateCount);
}
private int Update(DBConnection Connection, PERMIT_TYPEDC objPERMITS_LOOK_UP)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PERMITS_LOOK_UPUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PERMIT_TYPE_ID", DbType.String, objPERMITS_LOOK_UP.PERMIT_TYPE_ID);
dbCommandWrapper.AddInParameter("p_DESCRIPTION", DbType.String, objPERMITS_LOOK_UP.DESCRIPTION);
dbCommandWrapper.AddInParameter("p_PERMIT_CATEGORY", DbType.Int32, objPERMITS_LOOK_UP.PERMIT_CATEGORY);
dbCommandWrapper.AddInParameter("p_FEE", DbType.String, objPERMITS_LOOK_UP.FEE);
dbCommandWrapper.AddInParameter("p_DURATION", DbType.String, objPERMITS_LOOK_UP.DURATION);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objPERMITS_LOOK_UP.IsDirty = IsDirty = true;
}
return(updateCount);
}
private int Insert(DBConnection Connection, SCREENDC objSCREEN)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_SCREENSInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_SCREEN_ID", DbType.Int32, objSCREEN.SCREEN_ID);
dbCommandWrapper.AddInParameter("p_SCREEN_NAME", DbType.String, objSCREEN.SCREEN_NAME);
dbCommandWrapper.AddInParameter("p_IS_EVENT_BASED", DbType.Boolean, objSCREEN.IS_EVENT_BASED);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objSCREEN.CREATED_BY);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
private int Update(DBConnection Connection, ST_STATE_LDC objST_STATE_L)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_ST_STATE_LUUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ST_STATE", DbType.String, objST_STATE_L.ST_STATE);
dbCommandWrapper.AddInParameter("p_ST_STATENAME", DbType.String, objST_STATE_L.ST_STATENAME);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objST_STATE_L.IsDirty = IsDirty = true;
}
return(updateCount);
}
public int GenerateSnapshot(int EVENT_ID, int CREATED_BY, DateTime dtDateTime, String snapshotType, DBConnection Connection)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_SS_SYSTEM_SNAPSHOTInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_EVENT_ID", DbType.Int32, EVENT_ID);
dbCommandWrapper.AddInParameter("P_ST_SNAPSHOT_TYPE", DbType.String, snapshotType);
dbCommandWrapper.AddInParameter("CURRENT_DATETIME", DbType.DateTime, dtDateTime);
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: GENERATE SNAPSHORT(" + snapshotType + ")", exp.Message + "\r\n" + exp.StackTrace, CREATED_BY);
throw exp;
}
return(insertCount);
}
public ATTACHMENTDC LoadSingleByProjectId(DBConnection Connection, int PROJECT_ID, int ATTACHMENT_ID)
{
ATTACHMENTDC objATTACHMENT = new ATTACHMENTDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PROJECT_ATTACHMENTSLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PROJECT_ID", DbType.Int32, PROJECT_ID);
dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, ATTACHMENT_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objATTACHMENT = FillProjectAttachmentObject(drRow);
}
return(objATTACHMENT);
}
public override HYLAN_TASKDC LoadByPrimaryKey(DBConnection Connection, int TASK_TITLE_ID, int JOB_ID)
{
TASK_FIBER_POWER_DIGDC objTASK_FIBER_POWER_DIG = new TASK_FIBER_POWER_DIGDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_TASK_FIBER_POWER_DIGLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_JOB_ID", DbType.Int32, JOB_ID);
dbCommandWrapper.AddInParameter("p_TASK_TITLE_ID", DbType.Int32, TASK_TITLE_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objTASK_FIBER_POWER_DIG = (Utility.ConvertToObject <TASK_FIBER_POWER_DIGDC>(ds.Tables[0]));
if (ds.Tables.Count > 1)
{
HYLAN_TASKDC hylanTaskDC = (Utility.ConvertToObject <HYLAN_TASKDC>(ds.Tables[1]));
objTASK_FIBER_POWER_DIG.TASK_TITLE_ID = hylanTaskDC.TASK_TITLE_ID;
objTASK_FIBER_POWER_DIG.TASK_NAME = hylanTaskDC.TASK_NAME;
}
return(objTASK_FIBER_POWER_DIG);
}
public List <REPORTDC> GenerateResourceReport(int EVENT_ID, int RMAG_ID, int COMPANY_ID,
String snapshotDateTime, int snapshotType, DBConnection Connection)
{
List <REPORTDC> allocList = new List <REPORTDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_GenerateResourceAllocationReport");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("P_EVENT_ID", DbType.Int32, EVENT_ID);
dbCommandWrapper.AddInParameter("p_RMAG_ID", DbType.Int32, RMAG_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, COMPANY_ID);
dbCommandWrapper.AddInParameter("P_SNAPSHOT_DATETIME", DbType.String, snapshotDateTime);
dbCommandWrapper.AddInParameter("p_SS_MATCHING_TYPE", DbType.Int32, snapshotType);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
if (ds.Tables.Count > 0)
{
foreach (DataRow drRow in ds.Tables[0].Rows)
{
allocList.Add(FillAllocationReportObject(drRow));
}
}
return(allocList);
}
private int Update(DBConnection Connection, SCREENDC objSCREEN)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_SCREENSUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_SCREEN_ID", DbType.Int32, objSCREEN.SCREEN_ID);
dbCommandWrapper.AddInParameter("p_SCREEN_NAME", DbType.String, objSCREEN.SCREEN_NAME);
dbCommandWrapper.AddInParameter("p_IS_EVENT_BASED", DbType.Boolean, objSCREEN.IS_EVENT_BASED);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objSCREEN.MODIFIED_BY);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objSCREEN.IsDirty = IsDirty = true;
}
return(updateCount);
}
private int Insert(DBConnection Connection, NOTEDC objNOTE)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_NOTESInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_NOTE_ID", DbType.Int32, objNOTE.NOTE_ID);
dbCommandWrapper.AddInParameter("p_NOTES", DbType.String, objNOTE.NOTES);
dbCommandWrapper.AddInParameter("p_NOTES_TYPE", DbType.String, objNOTE.NOTES_TYPE);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objNOTE.LOCK_COUNTER);
dbCommandWrapper.AddInParameter("p_SCREEN_ID", DbType.Int32, objNOTE.SCREEN_ID);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objNOTE.CREATED_BY);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objNOTE.CREATED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objNOTE.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objNOTE.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_SCREEN_RECORD_ID", DbType.Int32, objNOTE.SCREEN_RECORD_ID);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
public List <LABORDC> LoadByDailyIDAndType(DBConnection Connection, int DAILY_ID, int DAILY_TYPE)
{
List <LABORDC> objLABOR_VALU = new List <LABORDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_LABOR_VALUELoadByDailyIDAndType");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, DAILY_ID);
dbCommandWrapper.AddInParameter("p_DAILY_TYPE", DbType.Int32, DAILY_TYPE);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objLABOR_VALU = (Utility.ConvertToObjects <LABORDC>(ds.Tables[0]));
return(objLABOR_VALU);
}
private int Delete(DBConnection Connection, ATTACHMENTDC objATTACHMENT)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_ATTACHMENTSDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, objATTACHMENT.ATTACHMENT_ID);
dbCommandWrapper.AddInParameter("p_IS_DELETED", DbType.Int32, objATTACHMENT.IS_DELETED);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objATTACHMENT.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objATTACHMENT.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objATTACHMENT.LOCK_COUNTER);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
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 int Insert(DBConnection Connection, ROLES_PERMISSIONDC objROLES_PERMISSION)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_ROLES_PERMISSIONSInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_ROLE_ID", DbType.Int32, objROLES_PERMISSION.ROLE_ID);
dbCommandWrapper.AddInParameter("p_SCREEN_ID", DbType.Int32, objROLES_PERMISSION.SCREEN_ID);
dbCommandWrapper.AddInParameter("p_PERMISSION_TYPE_ID", DbType.Int32, objROLES_PERMISSION.PERMISSION_TYPE_ID);
dbCommandWrapper.AddInParameter("p_PERMISSION_TYPE", DbType.String, objROLES_PERMISSION.PERMISSION_TYPE);
dbCommandWrapper.AddInParameter("p_PERMISSION_TITLE", DbType.String, objROLES_PERMISSION.PERMISSION_TITLE);
dbCommandWrapper.AddInParameter("p_GENERAL_EDIT_ACCESS_TYPE", DbType.String, objROLES_PERMISSION.GENERAL_EDIT_ACCESS_TYPE);
dbCommandWrapper.AddInParameter("p_VIEW_ACCESS_GENERAL", DbType.Boolean, objROLES_PERMISSION.VIEW_ACCESS_GENERAL);
dbCommandWrapper.AddInParameter("p_EDIT_ACCESS", DbType.Boolean, objROLES_PERMISSION.EDIT_ACCESS);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
public List <DOCUMENTCATEGORYDC> LoaddocumentCategories(DBConnection Connection, int CATEGORY_ID)
{
List <DOCUMENTCATEGORYDC> objDOCUMENTCATEGORY = new List <DOCUMENTCATEGORYDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_DOCUMENTCATEGORIESByType");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_CATEGORY_TYPE_ID", DbType.Int32, CATEGORY_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objDOCUMENTCATEGORY.Add(FillDocumentCategoryObject(drRow));
}
return(objDOCUMENTCATEGORY);
}
public List <ATTACHMENTDC> LoadByDailyId(DBConnection Connection, int DAILY_ID)
{
List <ATTACHMENTDC> objATTACHMENT = new List <ATTACHMENTDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_ATTACHMENTSLoadByDaily");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_Daily_ID", DbType.Int32, DAILY_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
foreach (DataRow drRow in ds.Tables[0].Rows)
{
objATTACHMENT.Add(FillDailyAttachmentObject(drRow));
}
return(objATTACHMENT);
}
public PayDepartmentDC LoadByPrimaryKey(DBConnection Connection, string Code)
{
PayDepartmentDC objPayDesignation = new PayDepartmentDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PayDesignationsLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_Code", DbType.String, Code);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objPayDesignation = FillObject(reader);
return(objPayDesignation);
}
//=================================================================
// public Function LoadAll() As Boolean
//=================================================================
// Loads all of the records in the database, and sets the currentRow to the first row
//=================================================================
public override List <HYLAN_TASKDC> LoadAll(DBConnection Connection, int TASK_TITLE_ID)
{
List <HYLAN_TASKDC> objTASK_FIBER_POWER_DIG = new List <HYLAN_TASKDC>();
StringBuilder sql = new StringBuilder();
sql.Append("proc_TASK_FIBER_POWER_DIGLoadAll");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TASK_TITLE_ID", DbType.Int32, TASK_TITLE_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objTASK_FIBER_POWER_DIG.AddRange(Utility.ConvertToObjects <TASK_FIBER_POWER_DIGDC>(ds.Tables[0]));
return(objTASK_FIBER_POWER_DIG);
}
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 DAILYDC LoadByPrimaryKey(DBConnection Connection, int DAILY_ID)
{
DAILYDC objDAIL = new DAILYDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_DAILYLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, DAILY_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objDAIL = (Utility.ConvertToObject <DAILYDC>(ds.Tables[0]));
return(objDAIL);
}
