public List <clsCompanies> SelectAllSuggestion(string prefix) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Companies_SelectAll]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@suggestion", prefix)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader(dataReader)); } catch (Exception ex) { throw new Exception("clsCompanies::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(VATTU businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[VATTU_Update]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@TEN", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TEN)); sqlCommand.Parameters.Add(new SqlParameter("@SOLUONG", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SOLUONG)); sqlCommand.Parameters.Add(new SqlParameter("@KYHIEU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KYHIEU)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return true; } catch //(Exception ex) { return false;//throw new Exception("VATTU::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsNickname> GetAllManagers(int empID) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "[dbo].[sp_GetAllManagers]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, empID)); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReaderForNickname(dataReader)); } catch (Exception ex) { throw new Exception("clsSuccessRegister::getNicknameByEmpID::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List<VATTU> SelectAllEntities() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[VATTU_SelectAll]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return PopulateObjectsFromReader(dataReader); } catch //(Exception ex) { return null;//throw new Exception("VATTU::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Delete by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>true for successfully deleted</returns> public bool Delete(VATTUKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[VATTU_DeleteByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return true; } catch //(Exception ex) { return false;//throw new Exception("VATTU::DeleteByKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select records by field /// </summary> /// <param name="fieldName">name of field</param> /// <param name="value">value of field</param> /// <returns>list of CGroup_solution</returns> public List <CGroup_solution> SelectByField(string fieldName, object value) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_group_solution_SelectByField"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("FieldName", fieldName)); sqlCommand.Parameters.Add(new NpgsqlParameter("Value", value)); MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader(dataReader)); } catch (Exception ex) { throw new Exception("CGroup_solution::SelectByField::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Delete records by field /// </summary> /// <param name="fieldName">name of field</param> /// <param name="value">value of field</param> /// <returns>true for successfully deleted</returns> public bool DeleteByField(string fieldName, object value) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_group_solution_DeleteByField"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("FieldName", fieldName)); sqlCommand.Parameters.Add(new NpgsqlParameter("Value", value)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("CGroup_solution::DeleteByField::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsResourcePlanner> GetAllEmpResourcePlannerByStatus(string email, int MONTH, int YEAR, int STATUS) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetAllEmpResourcePlannerByStatus]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, email)); sqlCommand.Parameters.Add(new SqlParameter("@MONTH", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, MONTH)); sqlCommand.Parameters.Add(new SqlParameter("@YEAR", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, YEAR)); sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, STATUS)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReader5(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetAllEmpResourcePlannerByStatus::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsResourcePlanner> GetAllStatusResourcePlanner() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetAllStatusResourcePlanner]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReader6(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetAllStatusResourcePlanner::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool Delete(CompaniesPro pro) { SqlCommand sqlCommand = new SqlCommand("dbo.[Companies_Delete]", MainConnection); sqlCommand.CommandType = CommandType.StoredProcedure; try { sqlCommand.Parameters.Add(new SqlParameter("@CompID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.PKID)); sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionBy)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
//not in use public List <clsResourcePlanner> GetResourcePlannerByEmpID(int EMP_ID, int DEPT_ID, int MONTH, int YEAR) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetResourcePlannerByEmpID]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, EMP_ID)); sqlCommand.Parameters.Add(new SqlParameter("@DEPT_ID", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, DEPT_ID)); sqlCommand.Parameters.Add(new SqlParameter("@MONTH", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, MONTH)); sqlCommand.Parameters.Add(new SqlParameter("@YEAR", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, YEAR)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReader3(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetResourcePlannerByEmpID::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public bool Update(DepartmentPro pro) { SqlCommand sqlCommand = new SqlCommand("dbo.[Departments_Update]", MainConnection); sqlCommand.CommandType = CommandType.StoredProcedure; try { sqlCommand.Parameters.Add(new SqlParameter("@DepID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepID)); sqlCommand.Parameters.Add(new SqlParameter("@DepParentID", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepParentID)); sqlCommand.Parameters.Add(new SqlParameter("@DepNameAr", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepNameAr)); sqlCommand.Parameters.Add(new SqlParameter("@DepNameEn", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepNameEn)); sqlCommand.Parameters.Add(new SqlParameter("@DepDesc", SqlDbType.VarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepDesc)); sqlCommand.Parameters.Add(new SqlParameter("@DepStatus", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.DepStatus)); sqlCommand.Parameters.Add(new SqlParameter("@TransactionBy", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pro.TransactionBy)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool UpdateCommendations(clsCommendations businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_UpdateCommendations]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@COMMEND_ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COMMEND_ID)); sqlCommand.Parameters.Add(new SqlParameter("@EMPLOYEE", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMPLOYEE)); sqlCommand.Parameters.Add(new SqlParameter("@PROJECT", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.PROJECT)); sqlCommand.Parameters.Add(new SqlParameter("@DATE_SENT", SqlDbType.Date, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DATE_SENT)); sqlCommand.Parameters.Add(new SqlParameter("@SENT_BY", SqlDbType.VarChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.SENT_BY)); sqlCommand.Parameters.Add(new SqlParameter("@REASON", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.REASON)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsContacts::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public DataSet SelectAllInTable(int pageNumber, int PageSize, string sortcolumn) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Companies_SelectAllInTable]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@pageSize", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, PageSize)); sqlCommand.Parameters.Add(new SqlParameter("@pageNumber", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, pageNumber)); sqlCommand.Parameters.Add(new SqlParameter("@SORTCOLUMN", SqlDbType.NVarChar, 400, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, sortcolumn)); MainConnection.Open(); SqlDataAdapter da = new SqlDataAdapter(sqlCommand); DataSet dt = new DataSet(); da.Fill(dt); return(dt); } catch (Exception ex) { throw new Exception("clsCompanies::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select all rescords /// </summary> /// <returns>list of CGroup_solution</returns> public List <CGroup_solution> SelectAll() { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_group_solution_SelectAll"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); NpgsqlDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader(dataReader)); } catch (Exception ex) { throw new Exception("CGroup_solution::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsResourcePlanner> GetBillableHoursByMonth(int empID, int month, int year) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetBillableHoursByMonth]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMPID", SqlDbType.Int, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, empID)); sqlCommand.Parameters.Add(new SqlParameter("@MONTH", SqlDbType.Int, 5, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, month)); sqlCommand.Parameters.Add(new SqlParameter("@YEAR", SqlDbType.Int, 5, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, year)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReader8(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetBillableHoursByMonth::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public DataTable SelectAllDataTable() { DataTable dt = new DataTable(); NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_group_solution_SelectAll"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Connection = MainConnection; NpgsqlDataAdapter da = new NpgsqlDataAdapter(sqlCommand); try { MainConnection.Open(); da.Fill(dt); return(dt); } catch (Exception ex) { throw new Exception("CGroup_solution::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsResourcePlanner> GetBillableHoursByWeek(int empID, int weekID) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetBillableHoursByWeek]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMPID", empID)); sqlCommand.Parameters.Add(new SqlParameter("@WEEKID", weekID)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReader8(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetBillableHoursByWeek::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Delete by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>true for successfully deleted</returns> public bool Delete(CGroup_solutionKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_group_solution_DeleteByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idgroup_solution", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idgroup_solution)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("CGroup_solution::DeleteByKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsResourcePlanner> GetNonBillableHours(string email, int display, int month, int year) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetNonBillableHours]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, email)); sqlCommand.Parameters.Add(new SqlParameter("@DISPLAY", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, display)); sqlCommand.Parameters.Add(new SqlParameter("@MONTH", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, month)); sqlCommand.Parameters.Add(new SqlParameter("@YEAR", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, year)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsRPFromReaderNonBillable(dataReader)); } catch (Exception ex) { throw new Exception("clsResourcePlanner::GetNonBillableHours::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select all rescords /// </summary> /// <returns>list of clsSongs</returns> public List <clsSongs> SelectAll() { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_Songs_SelectAll]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader(dataReader)); } catch (Exception ex) { throw new Exception("clsSongs::SelectAll::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool UpdateResourcePlanner(clsResourcePlanner businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_UpdateResourcePlanner]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID)); sqlCommand.Parameters.Add(new SqlParameter("@from", SqlDbType.DateTime, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.from)); sqlCommand.Parameters.Add(new SqlParameter("@to", SqlDbType.DateTime, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.to)); sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.Int, 2, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsResourcePlanner::UpdateResourcePlanner::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select records by field /// </summary> /// <param name="fieldName">name of field</param> /// <param name="value">value of field</param> /// <returns>list of VATTU</returns> public List<VATTU> SelectByField(string fieldName, object value) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[VATTU_SelectByField]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@FieldName", fieldName)); sqlCommand.Parameters.Add(new SqlParameter("@Value", value)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return PopulateObjectsFromReader(dataReader); } catch //(Exception ex) { return null;//throw new Exception("VATTU::SelectByField::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(NHAPTHUOC businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[NHAPTHUOC_Update]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@NGAY", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NGAY)); sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID)); sqlCommand.Parameters.Add(new SqlParameter("@TONGTIEN", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TONGTIEN)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch //(Exception ex) { return(false); //throw new Exception("NHAPTHUOC::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Delete records by field /// </summary> /// <param name="fieldName">name of field</param> /// <param name="value">value of field</param> /// <returns>true for successfully deleted</returns> public bool DeleteByField(string fieldName, object value) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[VATTU_DeleteByField]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@FieldName", fieldName)); sqlCommand.Parameters.Add(new SqlParameter("@Value", value)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return true; } catch //(Exception ex) { return false;//throw new Exception("VATTU::DeleteByField::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Select all rescords /// </summary> /// <returns>list of clsAssignedProjects</returns> public List <clsActionLists> SelectAllActionLists(string email) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetActionListsAll]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@EMAIL_ADDRESS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, email)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader(dataReader)); } catch (Exception ex) { throw new Exception("clsActionLists::SelectAllActionLists::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public bool UpdateAssetsInventoryCancel(clsAssets businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_UpdateAssetsInventoryCancel]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ASSET_ID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ASSET_ID)); sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID)); sqlCommand.Parameters.Add(new SqlParameter("@DATE_ASSIGNED", SqlDbType.DateTime, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DATE_ASSIGNED)); sqlCommand.Parameters.Add(new SqlParameter("@STATUS", SqlDbType.Int, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.STATUS)); sqlCommand.Parameters.Add(new SqlParameter("@COMMENTS", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.COMMENTS)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsAssets::sp_UpdateAssetsInventoryCancel::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(clsActionLists businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_UpdateActionLists]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@REFERENCE", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACTREF)); sqlCommand.Parameters.Add(new SqlParameter("@ACTION_TEXT", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ACT_MESSAGE)); sqlCommand.Parameters.Add(new SqlParameter("@ACTION_ASSIGNEE", SqlDbType.Int, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.EMP_ID)); sqlCommand.Parameters.Add(new SqlParameter("@ACTION_DUE_DATE", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DUE_DATE)); sqlCommand.Parameters.Add(new SqlParameter("@ACTION_DATE_CLOSED", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.DATE_CLOSED)); sqlCommand.Parameters.Add(new SqlParameter("@NICK_NAME", SqlDbType.VarChar, 255, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NICK_NAME)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("clsActionLists::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
public List <clsAssets> GetAllAssetsInventoryUnApproved(int empID) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[sp_GetAllAssetsInventoryUnApproved]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { MainConnection.Open(); sqlCommand.Parameters.Add(new SqlParameter("@EMP_ID", SqlDbType.Int, 50, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, empID)); IDataReader dataReader = sqlCommand.ExecuteReader(); return(PopulateObjectsFromReader2(dataReader)); } catch (Exception ex) { throw new Exception("clsAssets::sp_GetAllAssetsInventoryUnApproved::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Delete by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>true for successfully deleted</returns> public bool Delete(CCells_programKeys keys) { NpgsqlCommand sqlCommand = new NpgsqlCommand(); sqlCommand.CommandText = "public.sp_cells_program_DeleteByPrimaryKey"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new NpgsqlParameter("p_idcell_reported", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idcell_reported)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("CCells_program::DeleteByKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }