public TBS_SYSTEM_CONFIG LoadSystemConfig()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
TBS_SYSTEM_CONFIG result = ct.TBS_SYSTEM_CONFIG.FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public sp_SYS02_GetUserProfile_Result GetUserProfile()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
var result = ct.sp_SYS02_GetUserProfile(OISDataInfo.UserInfomation.USER_ID).FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public sp_SYS001_GetSystemConfig_Result GetSystemConfig()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
sp_SYS001_GetSystemConfig_Result result = ct.sp_SYS001_GetSystemConfig().FirstOrDefault();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public string GetServerName()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
string serverName = ct.Database.SqlQuery <string>("SELECT @@SERVERNAME").FirstOrDefault();
return(serverName);
}
}
catch (Exception ex)
{
throw ex;
}
}
public DateTime GetCurDateTime()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
DateTime dt = ct.Database.SqlQuery <DateTime>("SELECT GETDATE()").FirstOrDefault();
return(dt);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void UserLogout(string UserId)
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
using (TransactionScope trans = new TransactionScope())
{
ct.sp_SYS_UserLogout(UserId);
trans.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public sp_SYS_UserLogin_Result UserLogin(string UserId, string Password)
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
string AppVersion = Application.ProductVersion;
sp_SYS_UserLogin_Result user = ct.sp_SYS_UserLogin(UserId, Password, AppVersion).FirstOrDefault();
return(user);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <sp_SYS_GetMenu_Result> LoadMenu()
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
{
ct.Configuration.LazyLoadingEnabled = false;
List <sp_SYS_GetMenu_Result> menus = ct.sp_SYS_GetMenu(OISDataInfo.UserInfomation.USER_ID).ToList();
return(menus);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveSystemConfig(sp_SYS001_GetSystemConfig_Result data)
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
using (TransactionScope trans = new TransactionScope())
{
ct.sp_SYS001_SaveSystemConfig(data.IS_UPDATE_AUTOUPDATE,
data.DEFAULT_REPORT_REGISTRATION_ID,
data.DEFAULT_REPORT_LAB_SUPERVISOR_ID,
data.REPORT_REV_WPL,
data.DEFAULT_REPORT_WPA_REGISTRATION_ID,
data.DEFAULT_REPORT_WPA_LAB_SUPERVISOR_ID,
data.REPORT_REV_WPA,
OISDataInfo.UserInfomation.USER_ID);
trans.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveSystemConfig(TBS_SYSTEM_CONFIG data)
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
using (TransactionScope trans = new TransactionScope())
{
TBS_SYSTEM_CONFIG result = ct.TBS_SYSTEM_CONFIG.FirstOrDefault();
result.IS_UPDATE_AUTOUPDATE = data.IS_UPDATE_AUTOUPDATE;
result.UPD_ID = OISDataInfo.UserInfomation.USER_ID;
result.UPD_DATE = GetCurDateTime();
result.UPD_MACHINE = OISDataInfo.UserInfomation.MACHINE;
ct.SaveChanges();
trans.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveUserProfile(sp_SYS02_GetUserProfile_Result data)
{
try
{
using (OIS_SYSEntities ct = new OIS_SYSEntities())
using (TransactionScope trans = new TransactionScope())
{
ct.sp_SYS02_SaveUserProfile(data.ID,
data.PRENAME_ID,
data.FNAME_EN,
data.LNAME_EN,
data.FNAME_TH,
data.LNAME_TH,
data.NICKNAME,
data.IDCARD,
data.BIRTHDATE,
data.STARTDATE,
data.DIVISION_ID,
data.SUBDIVISION_ID,
data.POSITION_ID,
data.GROUP_ID,
data.REGISTRATION_NO,
data.LABSUPERVISOR_NO,
data.USER_PIC,
data.PASS,
data.PASS_NEW,
data.PASS_CONFIRM,
OISDataInfo.UserInfomation.USER_ID);
trans.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}
