public bool UpdateSettingDataObj(SGSettingData obj)
{
// Create
Log.Information($"Updating a SettingData, GROUPID:{obj.GROUPID}, UID:{obj.UID}, APPRLINE:{obj.APPRLINE}, DELAYDSPPW:{obj.DELAYDISPLAYPW}, AUTOLOGIN:{obj.AUTOLOGINING}");
DBSDataCtx.Update(obj);
DBSDataCtx.SaveChanges();
return(true);
}
/* Delete from SGSettingData */
public bool DeleteSettingData(SGSettingData settingData)
{
// Delete
DBSDataCtx.Remove(settingData);
DBSDataCtx.SaveChanges();
Log.Information($"Delete the SGSettingData, {settingData}");
return(true);
}
public bool SetSettingAutoLogin(int groupId, bool autoLogin)
{
// Create
Log.Information($"Set a SettingData, GROUPID({groupId})=>AUTOLOGINING({autoLogin})");
SGSettingData SData;
SData = DBSDataCtx.setting
.Where(x => x.GROUPID == groupId)
.FirstOrDefault();
SData.AUTOLOGINING = autoLogin?1:0;
DBSDataCtx.SaveChanges();
return(true);
}
public bool SetSettingDelayDspPw(int groupId, string delayDspPw)
{
// Create
Log.Information($"Set a SettingData, GROUPID({groupId})=>DELAYDISPLAYPW({delayDspPw})");
SGSettingData SData;
SData = DBSDataCtx.setting
.Where(x => x.GROUPID == groupId)
.FirstOrDefault();
SData.DELAYDISPLAYPW = delayDspPw;
DBSDataCtx.SaveChanges();
return(true);
}
public bool SetSettingApprLine(int groupId, string apprline)
{
// Create
Log.Information($"Set a SettingData, GROUPID({groupId})=>APPRLINE({apprline})");
SGSettingData SData;
SData = DBSDataCtx.setting
.Where(x => x.GROUPID == groupId)
.FirstOrDefault();
SData.APPRLINE = apprline;
DBSDataCtx.SaveChanges();
return(true);
}
public bool SetSettingUPW(int groupId, string upw)
{
// Create
Log.Information($"Set a SettingData, GROUPID({groupId})=>UPW({upw})");
SGSettingData SData;
SData = DBSDataCtx.setting
.Where(x => x.GROUPID == groupId)
.FirstOrDefault();
SData.UPW = upw;
DBSDataCtx.SaveChanges();
return(true);
}
/* Insert to SGSettingData */
public bool InsertSettingData(int groupId, string uid, string upw, string apprline, string delayDspPw, int autoLoginUse)
{
// Create
Log.Information($"Inserting a SettingData, GROUPID:{groupId}, UID:{uid}, APPRLINE:{apprline}, DELAYDSPPW:{delayDspPw}, AUTOLOGIN:{autoLoginUse}");
DBSDataCtx.Add(new SGSettingData
{
GROUPID = groupId,
UID = uid,
UPW = upw,
APPRLINE = apprline,
DELAYDISPLAYPW = delayDspPw,
AUTOLOGINING = autoLoginUse
}
);
DBSDataCtx.SaveChanges();
return(true);
}
