public override T_RolePermission GetRole4UserMenu(int User_ID, int Menu_ID) { string _sql = "Sp_GetRoleForUserMenu"; SqlService _sqlservice = new SqlService(connectionString); T_RolePermission _role = new T_RolePermission(); SqlDataReader _reader; try { _sqlservice.AddParameter("@User_ID", SqlDbType.Int, User_ID); _sqlservice.AddParameter("@Menu_ID", SqlDbType.Int, Menu_ID); _reader = _sqlservice.ExecuteSPReader(_sql); if (_reader.HasRows) { _reader.Read(); if (_reader["Doc"] != DBNull.Value) { _role.R_Read = Convert.ToBoolean(_reader["Doc"]); } if (_reader["Ghi"] != DBNull.Value) { _role.R_Write = Convert.ToBoolean(_reader["Ghi"]); } if (_reader["Xoa"] != DBNull.Value) { _role.R_Delete = Convert.ToBoolean(_reader["Xoa"]); } _reader.Close(); } else { _role.R_Read = false; _role.R_Write = false; _role.R_Delete = false; } } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } return(_role); }
public override DataSet ExecSqlDataSet(string sql) { SqlService _sqlservice = new SqlService(connectionString); try { return(_sqlservice.ExecuteSqlDataSet(sql)); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void ExecSql(string sql) { SqlService _sqlservice = new SqlService(connectionString); try { _sqlservice.ExecuteSql(sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override int InsertObjectReturn(object obj, string spName) { SqlService _sqlservice = new SqlService(connectionString); string sql = spName; foreach (PropertyInfo propertyinfo in obj.GetType().GetProperties()) { if (propertyinfo.PropertyType.ToString() == "System.DateTime") { if ((DateTime)propertyinfo.GetValue(obj, null) == DateTime.MinValue || (DateTime)propertyinfo.GetValue(obj, null) == DateTime.MaxValue) { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, DBNull.Value)); } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } SqlParameter paraOutput = new SqlParameter("@ReturnValue", SqlDbType.Int); paraOutput.Value = 0; paraOutput.Direction = ParameterDirection.Output; _sqlservice.AddParameter(paraOutput); try { _sqlservice.ExecuteSP(sql); return((int)paraOutput.Value); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_Event_Category_From_T_Event_Category(int news_id) { string _sql = "[Insert_T_Event_Category_From_T_Event_Category]"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override bool Login(string userName, string passWord) { string _sql = "Sp_UserLogin"; SqlService _sqlservice = new SqlService(connectionString); _sqlservice.AddParameter("@userName", SqlDbType.NVarChar, userName); _sqlservice.AddParameter("@passWord", SqlDbType.NVarChar, passWord); try { return(_sqlservice.ExecuteSPReader(_sql).HasRows ? true : false); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override object GetObjectByID(string sp_name, string Id, string TypeName, string FieldIDName) { SqlService _sqlservice = new SqlService(connectionString); string sql = sp_name; SqlDataReader reader; _sqlservice.AddParameter(new SqlParameter("@" + FieldIDName, Id)); try { reader = _sqlservice.ExecuteSPReader(sql); return(CBO.FillObject(reader, Type.GetType("HPCInfo." + TypeName + ",HPCInfo"))); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_CategoryChuyenDe_From_T_CategoryChuyenDe(int news_id, int copyfrom) { string _sql = "[Insert_T_CategoryChuyenDe_From_T_CategoryChuyenDe]"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.AddParameter("@CopyFrom", SqlDbType.Int, copyfrom, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void Insert_T_NewsEvent_Content_From_T_NewsEvent_Content(int news_id, int _CopyFrom) { string _sql = "Insert_T_NewsEvent_Content_From_T_NewsEvent_Content"; SqlService _sqlservice = new SqlService(); try { _sqlservice.AddParameter("@ID", SqlDbType.Int, news_id, true); _sqlservice.AddParameter("@Copyfrom", SqlDbType.Int, _CopyFrom, true); _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override DataSet GetDataSet(string TableName, string ColumnList, string Where) { string _sql = "Sp_GetColumnValues"; SqlService _sqlservice = new SqlService(connectionString); _sqlservice.AddParameter("@TableName", SqlDbType.NVarChar, TableName); _sqlservice.AddParameter("@ColumnList", SqlDbType.NVarChar, ColumnList); _sqlservice.AddParameter("@Where", SqlDbType.NVarChar, Where); try { return(_sqlservice.ExecuteSPDataSet(_sql)); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override string GetColumnValues(string TableName, string ColumnName, string Where) { string _sql = "Sp_GetColumnValues"; SqlService _sqlservice = new SqlService(connectionString); SqlDataReader _reader; StringBuilder _result = new StringBuilder(); string tmp = string.Empty; _sqlservice.AddParameter("@TableName", SqlDbType.NVarChar, TableName); _sqlservice.AddParameter("@ColumnList", SqlDbType.NVarChar, ColumnName); _sqlservice.AddParameter("@Where", SqlDbType.NVarChar, Where); try { _reader = _sqlservice.ExecuteSPReader(_sql); if (_reader.HasRows) { while (_reader.Read()) { if (_reader[ColumnName] != DBNull.Value) { _result.Append(_reader[ColumnName].ToString() + ";"); } else { _result.Append(" ;"); } } } tmp = _result.ToString(); return(tmp.EndsWith(";") ? tmp.Substring(0, tmp.Length - 1) : tmp); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override void ExecStore(string StoreName, string[] param1, object[] value) { string _sql = StoreName; SqlService _sqlservice = new SqlService(connectionString); for (int i = 0; i < param1.Length; i++) { _sqlservice.AddParameter(new SqlParameter(param1[i], value[i])); } try { _sqlservice.ExecuteSP(_sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }
public override object GetObjectByCondition(string TypeName, string whereCondition) { object obj; SqlService _sqlservice = new SqlService(connectionString); string sql = "SP_GetObjectByCondition"; try { _sqlservice.AddParameter("@TypeName", SqlDbType.NVarChar, TypeName); _sqlservice.AddParameter("@whereCondition", SqlDbType.NVarChar, whereCondition); obj = CBO.FillObject(_sqlservice.ExecuteSPReader(sql), Type.GetType("HPCInfo." + TypeName + ",HPCInfo")); } catch (Exception exception) { throw exception; } finally { _sqlservice.Disconnect(); } return(obj); }
public override void InsertObject(object obj) { SqlService _sqlservice = new SqlService(connectionString); string sql = "Sp_Insert" + obj.GetType().Name; foreach (PropertyInfo propertyinfo in obj.GetType().GetProperties()) { if (propertyinfo.PropertyType.ToString() == "System.DateTime") { if ((DateTime)propertyinfo.GetValue(obj, null) == DateTime.MinValue || (DateTime)propertyinfo.GetValue(obj, null) == DateTime.MaxValue) { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, DBNull.Value)); } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } else { _sqlservice.AddParameter(new SqlParameter("@" + propertyinfo.Name, propertyinfo.GetValue(obj, null))); } } try { _sqlservice.ExecuteSP(sql); } catch (Exception ex) { throw ex; } finally { _sqlservice.Disconnect(); } }