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);
}
