public int UpdateSYS_Catagory(List <SYS_Catagory> SYS_Catagorys, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); DbConnection connection = Common.CreateConnection(connectionDataAccess.DecryptSYS_ConfigConnection(Connection)); connection.Open(); int count = 0; try { foreach (SYS_Catagory SYS_Catagory in SYS_Catagorys) { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, SYS_Catagory.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_NAME, SYS_Catagory.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, SYS_Catagory.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, SYS_Catagory.ParentID, false)); _DbHelper.ExecuteNonQuery(connection, Common.DatabaseSchema + "[SYS_Catagory_Update]", para.ToArray()); count++; } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.Update: {0}", ex.Message)); } finally { connection.Close(); } return(count); }
public SYS_User SelectUserByUserName(string connectionString, string UserName) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connectionString = connectionDataAccess.DecryptSYS_ConfigConnection(connectionString); SYS_User sysUser = new SYS_User(); DbDataReader reader = null; DbConnection connection = _DbHelper.CreateConnection(connectionString); connection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, UserName, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_User_SelectByUserName]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_UserDataAccess.SetSYS_UserInfo(reader, ref sysUser); } } catch (Exception ex) { throw new Exception(String.Format("SYS_UserDataAccess.SelectByUserName: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(sysUser); }
public void DeleteSYS_Catagory(List <SYS_Catagory> SYS_Catagorys, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); DbConnection connection = Common.CreateConnection(connectionDataAccess.DecryptSYS_ConfigConnection(Connection)); connection.Open(); List <DbParameter> para = new List <DbParameter>(); try { foreach (SYS_Catagory SYS_Catagory in SYS_Catagorys) { para.Add(_DbHelper.CreateParameter(FIELD_ID, SYS_Catagory.ID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); _DbHelper.ExecuteNonQuery(connection, Common.DatabaseSchema + "[SYS_Catagory_Delete]", para.ToArray()); para.Clear(); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.Delete: {0}", ex.Message)); } finally { connection.Close(); } }
public int InsertSYS_Catagory(SYS_Catagory SYS_Catagory, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); Connection = connect.DecryptSYS_ConfigConnection(Connection); List <DbParameter> para = new List <DbParameter>(); DbConnection conn = _DbHelper.CreateConnection(Connection); conn.Open(); try { DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_NAME, SYS_Catagory.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, SYS_Catagory.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, SYS_Catagory.ParentID, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Catagory_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDanhMuc(string TableName, string ParentName, string ChildName, string DonViTinh, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); Connection = connect.DecryptSYS_ConfigConnection(Connection); DbConnection conn = _DbHelper.CreateConnection(Connection); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter("ParentName", ParentName, false)); para.Add(_DbHelper.CreateParameter("TableName", TableName, false)); para.Add(_DbHelper.CreateParameter("ChildName", ChildName, false)); para.Add(_DbHelper.CreateParameter("DonViTinh", DonViTinh, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_Catagory_InsertDanhMuc]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.InsertDanhMuc: {0}", ex.Message)); } finally { conn.Close(); } }
public List <SYS_Organization> SelectAllSYS_Organization(string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); List <SYS_Organization> sys_organization = new List <SYS_Organization>(); DbDataReader reader = null; try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_SelectAll]", (DbParameter[])null); if (reader.HasRows) { SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization); } return(sys_organization); } catch (Exception ex) { throw new Exception(String.Format(" SYS_OrganizationDataAccess.SelectAll: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public List <SYS_Catagory> SelectListCombo(string tableName, int ID, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); DbConnection connection = _DbHelper.CreateConnection(connect.DecryptSYS_ConfigConnection(Connection)); connection.Open(); List <SYS_Catagory> SYS_Catagory = new List <SYS_Catagory>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectListCombo]", (DbParameter[])para.ToArray()); if (reader.HasRows) { SYS_CatagoryDataAccess.SetListSYS_CatagoryInfo(ref reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format(" SYS_CatagoryDataAccess.SelectListCombo: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }
public SYS_Language SelectSYS_Language(int sys_LanguageId, string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); SYS_Language sys_language = new SYS_Language(); DbDataReader reader = null; DbConnection connection = _DbHelper.CreateConnection(connect); connection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, sys_LanguageId, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Language_SelectById]", para.ToArray()); if (reader.HasRows && reader.Read()) { SYS_LanguageDataAccess.SetSYS_LanguageInfo(reader, ref sys_language); } } catch (Exception ex) { throw new Exception(String.Format("SYS_LanguageDataAccess.SelectById: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(sys_language); }
public List <SYS_Right> GetAllRightsByUser(SYS_User user, string connect) { List <SYS_Right> result = new List <SYS_Right>(); DbDataReader reader = null; SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection dbConnection = Common.CreateConnection(connect); dbConnection.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter("UserName", user.UserName, false)); reader = _DbHelper.ExecuteReader(dbConnection, Common.DatabaseSchema + "[SYS_ALLRight_GetByUser]", para.ToArray()); if (reader.HasRows) { while (reader.Read()) { SYS_Right temp = new SYS_Right(); SetSYS_RightInfo(reader, ref temp); temp.IsApprove = Boolean.Parse(reader[FIELD_APPROVE].ToString()); temp.IsDelete = Boolean.Parse(reader[FIELD_DELETE].ToString()); temp.IsCreate = Boolean.Parse(reader[FIELD_CREATE].ToString()); temp.IsUpdate = Boolean.Parse(reader[FIELD_UPDATE].ToString()); temp.ModuleID = int.Parse(reader[FIELD_MODULEID] + ""); result.Add(temp); } } return(result); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.GetRightsByUser: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } dbConnection.Close(); } }
/// <summary> /// Sử dụng cho các bảng về VTHCPD /// </summary> /// <param name="TableNotIn"></param> /// <param name="IDDonVi"></param> /// <param name="Year"></param> /// <param name="ParentID"></param> /// <param name="tableName"></param> /// <param name="Connection"></param> /// <returns></returns> public List <SYS_Catagory> SelectSYS_CatagoryByParentIDNotInTable(string TableNotIn, int IDDonVi, int IDChungLoai, int Year, string ParentID, string tableName, string Connection) { SYS_ConfigConnectionDataAccess connect = new SYS_ConfigConnectionDataAccess(); Connection = connect.DecryptSYS_ConfigConnection(Connection); DbConnection connection = _DbHelper.CreateConnection(Connection); connection.Open(); List <SYS_Catagory> SYS_Catagory = new List <SYS_Catagory>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, ParentID, false)); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, tableName, false)); para.Add(_DbHelper.CreateParameter("TableNotIn", TableNotIn, false)); para.Add(_DbHelper.CreateParameter("IDDonVi", IDDonVi, false)); para.Add(_DbHelper.CreateParameter("DBYear", Year, false)); para.Add(_DbHelper.CreateParameter("IDChungLoai", IDChungLoai, false)); reader = _DbHelper.ExecuteReader(connection, Common.DatabaseSchema + "[SYS_Catagory_SelectByParentIdNotInTable]", para.ToArray()); if (reader.HasRows) { SYS_CatagoryDataAccess.SetListSYS_CatagoryInfo(ref reader, ref SYS_Catagory); } } catch (Exception ex) { throw new Exception(String.Format("SYS_CatagoryDataAccess.SelectByIdNotInTable: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } connection.Close(); } return(SYS_Catagory); }
public SYS_UserConfig SelectByUserID_UserConfigByStrCn(string connect, int UserId) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); SYS_UserConfig userConfig = new SYS_UserConfig(); DbDataReader reader = null; List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_USERID, UserId, false)); try { reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_UserConfig_SelectByUserId]", para.ToArray()); if (reader.HasRows) { while (reader.Read()) { SetSYS_UserConfigInfo(reader, ref userConfig); } } return(userConfig); } catch (Exception ex) { throw new Exception(String.Format(" SYS_UserConfigDataAccess.SYS_UserConfig_SelectByUserId: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public List <SYS_Organization> SelectAllSYS_Organization_GetByUserID(int ID, string connect) { SYS_ConfigConnectionDataAccess connectionDataAccess = new SYS_ConfigConnectionDataAccess(); connect = connectionDataAccess.DecryptSYS_ConfigConnection(connect); DbConnection conn = _DbHelper.CreateConnection(connect); conn.Open(); List <SYS_Organization> sys_organization = new List <SYS_Organization>(); DbDataReader reader = null; try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ID, ID, false)); reader = _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_GetByUserID]", para.ToArray()); if (reader.HasRows) { SYS_OrganizationDataAccess.SetListSYS_OrganizationInfo(ref reader, ref sys_organization); } return(sys_organization); } catch (Exception ex) { throw new Exception(String.Format("SYS_OrganizationDataAccess.SelectByUserId: {0}", ex.Message)); } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public static DbDataAdapter CreateAdpter(string commandString, string connect) { DbDataAdapter adapter = _dbHelper.CreateAdpter(commandString, _SYS_ConfigConnectionDataAccess.DecryptSYS_ConfigConnection(connect)); return(adapter); }