public List <LOOK_UPDC> LoadByType(string lookuptype, DBConnection Connection) { List <LOOK_UPDC> objLOOK_UP = new List <LOOK_UPDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_LOOK_UPSLoadByType"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LU_TYPE", DbType.String, lookuptype); 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) { objLOOK_UP.Add(FillObject(drRow)); } return(objLOOK_UP); }
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 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 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 Function LoadAll() As Boolean //================================================================= // Loads all of the records in the database, and sets the currentRow to the first row //================================================================= public List <PayDepartmentDC> LoadAll(DBConnection Connection) { List <PayDepartmentDC> objPayDesignation = new List <PayDepartmentDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PayDepartmentsLoadAll"); 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); } foreach (DataRow drRow in ds.Tables[0].Rows) { objPayDesignation.Add(FillObject(drRow)); } return(objPayDesignation); }
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); }
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); }
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 <LABORDC> GetLaborFromManPower(DBConnection Connection, int DAILY_ID, int DAILY_TYPE) { List <LABORDC> objLABOR_VALU = new List <LABORDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_getLaborHoursFromManpower"); 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 Insert(DBConnection Connection, USERS_RMAGDC objUSERS_RMAG) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_USERS_RMAGSInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_RMAG_ID", DbType.Int32, objUSERS_RMAG.USER_RMAG_ID); dbCommandWrapper.AddInParameter("p_USER_ID", DbType.Int32, objUSERS_RMAG.USER_ID); dbCommandWrapper.AddInParameter("p_RMAG_ID", DbType.Int32, objUSERS_RMAG.RMAG_ID); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objUSERS_RMAG.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objUSERS_RMAG.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objUSERS_RMAG.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objUSERS_RMAG.MODIFIED_BY); if (Connection.Transaction != null) { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(insertCount); }
public USERS_RMAGDC LoadByPrimaryKey(DBConnection Connection, int USER_RMAG_ID) { USERS_RMAGDC objUSERS_RMAG = new USERS_RMAGDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_USERS_RMAGSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_RMAG_ID", DbType.Int32, USER_RMAG_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objUSERS_RMAG = FillObject(reader); return(objUSERS_RMAG); }
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); }
public PERMIT_TYPEDC LoadByPrimaryKey(DBConnection Connection, string PERMIT_TYPE_ID) { PERMIT_TYPEDC obj = new PERMIT_TYPEDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMIT_TYPESLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("@p_PERMIT_TYPE_ID", DbType.String, PERMIT_TYPE_ID); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } obj = (Utility.ConvertToObject <PERMIT_TYPEDC>(ds.Tables[0])); return(obj); }
//================================================================= // public Function LoadAll() As Boolean //================================================================= // Loads all of the records in the database, and sets the currentRow to the first row //================================================================= public List <PERMIT_TYPEDC> LoadAll(DBConnection Connection, bool getDescWithCode = false) { List <PERMIT_TYPEDC> list = new List <PERMIT_TYPEDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMIT_TYPESLoadAll"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("@p_getDescWithCode", DbType.Boolean, getDescWithCode); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } list.AddRange(Utility.ConvertToObjects <PERMIT_TYPEDC>(ds.Tables[0])); return(list); }
public List <MAN_POWERDC> LoadByDailyID(DBConnection Connection, int DAILY_ID) { List <MAN_POWERDC> objMAN_POWE = new List <MAN_POWERDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_MAN_POWERLoadByDailyID"); 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); } objMAN_POWE = (Utility.ConvertToObjects <MAN_POWERDC>(ds.Tables[0])); return(objMAN_POWE); }
public int Insert(DBConnection Connection, LABORDC objLABOR_VALU) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_LABOR_VALUEInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddOutParameter("p_LABOR_VALUE_ID", DbType.Int32, objLABOR_VALU.LABOR_VALUE_ID); dbCommandWrapper.AddInParameter("p_LABOR_ID", DbType.Int32, objLABOR_VALU.LABOR_ID); dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objLABOR_VALU.DAILY_ID); dbCommandWrapper.AddInParameter("p_HOURS", DbType.Decimal, objLABOR_VALU.HOURS); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objLABOR_VALU.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objLABOR_VALU.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objLABOR_VALU.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objLABOR_VALU.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objLABOR_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 TaskDC LoadByPrimaryKey(DBConnection Connection, string TaskID) { TaskDC objTask = new TaskDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_TasksLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); 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); } objTask = FillObject(reader); return(objTask); }
public LABORDC LoadByPrimaryKey(DBConnection Connection, int LABOR_VALUE_ID) { LABORDC objLABOR_VALU = new LABORDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_LABOR_VALUELoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LABOR_VALUE_ID", DbType.Int32, LABOR_VALUE_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objLABOR_VALU = FillObject(reader); return(objLABOR_VALU); }
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); }
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); }
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); }
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 Function LoadAll() As Boolean //================================================================= // Loads all of the records in the database, and sets the currentRow to the first row //================================================================= public List <PERMITDC> LoadAll(DBConnection Connection, string projectIDs = "All") { List <PERMITDC> objPERMIT = new List <PERMITDC>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMITSLoadAll"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_projectIDs", DbType.String, projectIDs); DataSet ds = new DataSet(); if (Connection.Transaction != null) { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction); } else { ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand); } objPERMIT.AddRange(Utility.ConvertToObjects <PERMITDC>(ds.Tables[0])); //foreach (DataRow drRow in ds.Tables[0].Rows) //{ // objPERMIT.Add(FillObject(drRow)); //} return(objPERMIT); }
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 int Delete(DBConnection Connection, PERMITDC objPERMIT) { int deleteCount = 0; try { StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMITSDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_PERMIT_ID", DbType.Int32, objPERMIT.PERMIT_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } } catch (Exception exp) { //Utilities.InsertIntoErrorLog("Error: PERMIT DELETE ", exp.Message + "\r\n" + exp.StackTrace, Convert.ToInt32(objPERMIT.MODIFIED_BY)); objPERMIT.SetError(exp); throw exp; } return(deleteCount); }
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 <String> LoadNames(DBConnection Connection, string Column_Name, string Column_Value) { List <String> names = new List <string>(); StringBuilder sql = new StringBuilder(); sql.Append("proc_MAN_POWER_AJAX"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_NAME", DbType.String, Column_Value); 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) { names = ds.Tables[0].AsEnumerable().Select(r => r.Field <string>(Column_Name)).ToList(); } return(names); }
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 string CompanyNameString(DBConnection Connection, string companyids) { string companyNames = string.Empty; StringBuilder sql = new StringBuilder(); sql.Append("proc_LoadCompanyNameByCompanyIDString"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_company_id", DbType.String, companyids); 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) { companyNames = ds.Tables[0].Rows[0][0].ToString(); } return(companyNames); }