public DataTable DN_TK_ThucTeDonVi(int Ma_dviqly, int Thang, int Nam, int ThangN1, int NamN1, int ThangN2, int NamN2, int TuNgay, int DenNgay) { DbConnection connection = _DbHelper.CreateConnection(Common.ConnectionString); connection.Open(); try { ArrayList para = new ArrayList(); para.Add(_DbHelper.CreateParam("IDMA_DVIQLY", SqlDbType.Int, Ma_dviqly)); para.Add(_DbHelper.CreateParam("ThangHT", SqlDbType.Int, Thang)); para.Add(_DbHelper.CreateParam("NamHT", SqlDbType.Int, Nam)); para.Add(_DbHelper.CreateParam("ThangN1", SqlDbType.Int, ThangN1)); para.Add(_DbHelper.CreateParam("NamN1", SqlDbType.Int, NamN1)); para.Add(_DbHelper.CreateParam("ThangN2", SqlDbType.Int, ThangN2)); para.Add(_DbHelper.CreateParam("NamN2", SqlDbType.Int, NamN2)); para.Add(_DbHelper.CreateParam("TuNgay", SqlDbType.Int, TuNgay)); para.Add(_DbHelper.CreateParam("DenNgay", SqlDbType.Int, DenNgay)); DataTable dt = _DbHelper.RunProcedureGetTable(connection, Common.DatabaseSchema + "[DN_TK_ThucTeDonVi]", para); return(dt); } catch (Exception ex) { throw new Exception(String.Format("DN_TK_ThucTeDonVi: {0}", ex.Message)); } finally { connection.Close(); } }
public int InsertSYS_Modun(SYS_Modun sys_modun) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_modun.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_modun.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CONNECTSTRING, sys_modun.ConnectString, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, sys_modun.idUser, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Modun_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_ModunDataAccess.Insert: {0}", ex.Message)); } finally { conn.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 InsertSYS_Language(SYS_Language sys_language) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_language.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_language.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_ISDEFAULT, sys_language.IsDefault, false)); para.Add(_DbHelper.CreateParameter(FIELD_PATH, sys_language.Path, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Language_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_LanguageDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_ColumnCategory(SYS_ColumnCategory sys_columncategory) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_COLUMNNAME, sys_columncategory.ColumnName, false)); para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_columncategory.DisplayName, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDCATEGORYMANAGER, sys_columncategory.IDCategoryManager, false)); para.Add(_DbHelper.CreateParameter(FIELD_ALLOWNULL, sys_columncategory.AllowNull, false)); para.Add(_DbHelper.CreateParameter(FIELD_DATATYPE, sys_columncategory.DataType, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_ColumnCategory_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_ColumnCategoryDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDM_USER(DM_USER dm_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDUSER, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_user.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_XACNHAN, dm_user.XACNHAN, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, dm_user.USERNAME, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, dm_user.PASSWORD, false)); para.Add(_DbHelper.CreateParameter(FIELD_HOTEN, dm_user.HOTEN, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, dm_user.DIACHI, false)); para.Add(_DbHelper.CreateParameter(FIELD_SODT, dm_user.SODT, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, dm_user.EMAIL, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYSINH, dm_user.NGAYSINH, false)); para.Add(_DbHelper.CreateParameter(FIELD_NGAYTAO, dm_user.NGAYTAO, false)); para.Add(_DbHelper.CreateParameter(FIELD_IS_ADMIN, dm_user.IS_ADMIN, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_USER_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DM_USERDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDM_DVQLY(DM_DVQLY dm_dvqly) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_MA_DVIQLY, dm_dvqly.MA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_TEN_DVIQLY, dm_dvqly.TEN_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_ParentId, dm_dvqly.ParentId, false)); para.Add(_DbHelper.CreateParameter(FIELD_TENVIETTAT, dm_dvqly.TenVietTat, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_DVQLY_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DM_DVQLYDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_CCU(SYS_CCU sys_ccu) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_ccu.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALREQUEST, sys_ccu.TotalRequest, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTALONLINE, sys_ccu.TotalOnline, false)); para.Add(_DbHelper.CreateParameter(FIELD_ONLINE, sys_ccu.Online, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[SYS_CCU_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_CCUDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDM_MODULE(DM_MODULE dm_module) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_IDMODULE, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDMA_DVIQLY, dm_module.IDMA_DVIQLY, false)); para.Add(_DbHelper.CreateParameter(FIELD_CONNECTSTRING, dm_module.ConnectString, false)); para.Add(_DbHelper.CreateParameter(FIELD_NAME, dm_module.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, dm_module.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDUSER, dm_module.IDUSER, false)); para.Add(ouput); _DbHelper.ExecuteNonQuery(conn, Common.DatabaseSchema + "[DM_MODULE_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DM_MODULEDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertDonVi(DonVi donvi) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_TENDV, donvi.TenDV, false)); para.Add(_DbHelper.CreateParameter(FIELD_DIACHI, donvi.DiaChi, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, donvi.Email, false)); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, donvi.ParentID, false)); para.Add(_DbHelper.CreateParameter(FIELD_PHANLOAI, donvi.PhanLoai, false)); para.Add(_DbHelper.CreateParameter(FIELD_TINH, donvi.Tinh, false)); para.Add(_DbHelper.CreateParameter(FIELD_HUYEN, donvi.Huyen, false)); para.Add(_DbHelper.CreateParameter(FIELD_XA, donvi.Xa, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[DonVi_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("DonViDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_RightOfRoles(SYS_RightOfRoles sys_rightofroles) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_rightofroles.RoleId, false)); para.Add(_DbHelper.CreateParameter(FIELD_RIGHTID, sys_rightofroles.RightId, false)); para.Add(_DbHelper.CreateParameter(FIELD_VIEW, sys_rightofroles.View, false)); para.Add(_DbHelper.CreateParameter(FIELD_UPDATE, sys_rightofroles.Update, false)); para.Add(_DbHelper.CreateParameter(FIELD_CREATE, sys_rightofroles.Create, false)); para.Add(_DbHelper.CreateParameter(FIELD_DELETE, sys_rightofroles.Delete, false)); para.Add(_DbHelper.CreateParameter(FIELD_APPROVE, sys_rightofroles.Approve, false)); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_RightOfRole_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightOfRolesDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Population(SYS_Population sys_population) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDORGANIZATION, sys_population.IDOrganization, false)); para.Add(_DbHelper.CreateParameter(FIELD_TOTAL, sys_population.Total, false)); para.Add(_DbHelper.CreateParameter(FIELD_MALE, sys_population.Male, false)); para.Add(_DbHelper.CreateParameter(FIELD_FEMALE, sys_population.Female, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Population_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_PopulationDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_CategoryManager(SYS_CategoryManager sys_categorymanager) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_TABLENAME, sys_categorymanager.TableName, false)); para.Add(_DbHelper.CreateParameter(FIELD_DISPLAYNAME, sys_categorymanager.DisplayName, false)); para.Add(_DbHelper.CreateParameter(FIELD_LINK, sys_categorymanager.Link, false)); para.Add(_DbHelper.CreateParameter(FIELD_GROUPNAME, sys_categorymanager.GroupName, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_CategoryManager_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_CategoryManagerDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Right(SYS_Right sys_right) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_FUNCNAME, sys_right.FuncName, false)); para.Add(_DbHelper.CreateParameter(FIELD_TAG, sys_right.Tag, false)); para.Add(_DbHelper.CreateParameter(FIELD_MODULEID, sys_right.ModuleID, false)); para.Add(_DbHelper.CreateParameter(FIELD_FuncID, sys_right.FuncId, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Right_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_RightDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Staff(SYS_Staff sys_staff) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_ORGANIZATIONID, sys_staff.OrganizationId, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_staff.UserId, false)); para.Add(_DbHelper.CreateParameter(FIELD_POSITIONID, sys_staff.PositionId, false)); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_FROMDATE, sys_staff.FromDate, false)); para.Add(_DbHelper.CreateParameter(FIELD_TODATE, sys_staff.ToDate, false)); para.Add(_DbHelper.CreateParameter(FIELD_ROLEID, sys_staff.RoleID, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Staff_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_StaffDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Organization(SYS_Organization sys_organization) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_NAME, sys_organization.Name, false)); para.Add(_DbHelper.CreateParameter(FIELD_CODE, sys_organization.Code, false)); para.Add(_DbHelper.CreateParameter(FIELD_ADDRESS, sys_organization.Address, false)); para.Add(_DbHelper.CreateParameter(FIELD_PHONE, sys_organization.Phone, false)); para.Add(_DbHelper.CreateParameter(FIELD_FAX, sys_organization.Fax, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, sys_organization.Email, false)); para.Add(_DbHelper.CreateParameter(FIELD_WEBSITE, sys_organization.Website, false)); para.Add(_DbHelper.CreateParameter(FIELD_TYPE, sys_organization.Type, false)); para.Add(_DbHelper.CreateParameter(FIELD_PARENTID, sys_organization.ParentId, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDPROVINCE, sys_organization.IDProvince, false)); para.Add(_DbHelper.CreateParameter(FIELD_LEVELREPORT, sys_organization.LevelReport, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Organization_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_OrganizationDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_User(SYS_User sys_user) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_USERNAME, sys_user.UserName, false)); para.Add(_DbHelper.CreateParameter(FIELD_PASSWORD, sys_user.Password, false)); para.Add(_DbHelper.CreateParameter(FIELD_FIRSTNAME, sys_user.FirstName, false)); para.Add(_DbHelper.CreateParameter(FIELD_MIDNAME, sys_user.MidName, false)); para.Add(_DbHelper.CreateParameter(FIELD_LASTNAME, sys_user.LastName, false)); para.Add(_DbHelper.CreateParameter(FIELD_EMAIL, sys_user.Email, false)); para.Add(_DbHelper.CreateParameter(FIELD_ISACTIVE, sys_user.IsActive, false)); para.Add(_DbHelper.CreateParameter(FIELD_NUMBERPHONE, sys_user.NumberPhone, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDORGANIZATION, sys_user.IDOrganization, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_User_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_UserDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Log(SYS_Log sys_log) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_log.UserId, false)); para.Add(_DbHelper.CreateParameter(FIELD_FUNCTIONID, sys_log.FunctionId, false)); para.Add(_DbHelper.CreateParameter(FIELD_ACTION, sys_log.Action, false)); para.Add(_DbHelper.CreateParameter(FIELD_DESCRIPTION, sys_log.Description, false)); para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_log.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDBC, sys_log.IDBC, false)); para.Add(_DbHelper.CreateParameter(FIELD_PHANLOAI, sys_log.PhanLoai, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Log_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_LogDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Exception(SYS_Exception sys_exception) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_TIME, sys_exception.Time, false)); para.Add(_DbHelper.CreateParameter(FIELD_EXCEPTIONTRACE, sys_exception.ExceptionTrace, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Exception_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_ExceptionDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_Region_Province(SYS_Region_Province sys_region_province) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(_DbHelper.CreateParameter(FIELD_IDREGION, sys_region_province.IDRegion, false)); para.Add(_DbHelper.CreateParameter(FIELD_IDPROVINCE, sys_region_province.IDProvince, false)); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Region_Province_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_Region_ProvinceDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public int InsertSYS_UserConfig(SYS_UserConfig sys_userconfig) { DbConnection conn = _DbHelper.CreateConnection(Common.ConnectionString); conn.Open(); try { List <DbParameter> para = new List <DbParameter>(); para.Add(_DbHelper.CreateParameter(FIELD_LANGID, sys_userconfig.LangId, false)); para.Add(_DbHelper.CreateParameter(FIELD_USERID, sys_userconfig.UserId, false)); DbParameter ouput = _DbHelper.CreateParameter(FIELD_ID, DbType.Int32, true); para.Add(ouput); _DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_UserConfig_Insert]", para.ToArray()); return((int)ouput.Value); } catch (Exception ex) { throw new Exception(String.Format("SYS_UserConfigDataAccess.Insert: {0}", ex.Message)); } finally { conn.Close(); } }
public static DbConnection CreateConnection() { DbConnection connection = _dbHelper.CreateConnection(ConnectionString); return(connection); }