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_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 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_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_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_Roles(SYS_Roles sys_roles)
{
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_roles.Name, false));
para.Add(_DbHelper.CreateParameter(FIELD_IDORGANIZATION, sys_roles.IDOrganization, false));
para.Add(ouput);
_DbHelper.ExecuteReader(conn, Common.DatabaseSchema + "[SYS_Role_Insert]", para.ToArray());
return((int)ouput.Value);
}
catch (Exception ex)
{
throw new Exception(String.Format("SYS_RolesDataAccess.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 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();
}
}
