static void Main(string[] args)
{
//SyncServerSocket sock = new SyncServerSocket();
//if (sock.Listen())
//{
// sock.Receive();
//}
//else
//{
// Console.WriteLine("Fail to listen.");
//}
//AsyncListenServer<CS_PacketTable> instance = (AsyncListenServer<CS_PacketTable>)Activator.CreateInstance(typeof(AsyncListenServer<CS_PacketTable>));
//instance.StartListening();
UserLoginData ld = new UserLoginData();
ld.name = "냥";
ld.pwd = "0080";
ChatServer.Instance().m_UserLoginDataList.Add(ld);
ld.name = "뷰";
ld.pwd = "1111";
ChatServer.Instance().m_UserLoginDataList.Add(ld);
ld.name = "cho";
ld.pwd = "1111";
ChatServer.Instance().m_UserLoginDataList.Add(ld);
ChatServer.Instance().Run();
Console.WriteLine("Press any key.");
Console.Read();
return;
}
public int AddLogin(User user, UserLogin user_login)
{
IUserLoginRepository repo = _data_repository_factory.GetIdentityDataRepository <IUserLoginRepository>();
UserLoginData ul = new UserLoginData()
{
LoginProvider = user_login.LoginProvider,
ProviderKey = user_login.ProviderKey,
UserID = user.UserId,
ProviderDisplayName = user_login.ProviderDisplayName
};
return(repo.Save(ul));
}
public ActionResult UploadAvatar(HttpPostedFileBase UploadAvatar)
{
try
{
int userID = UserLoginData.GetSessionID(Session["UserLoggedIn"]);
userBLL.ChangeAvatar(UploadAvatar, userID);
return(RedirectToAction("ProfileManagement"));
}
catch (Exception ex)
{
return(this.ManageException(ex, "ProfileManagement"));
}
}
public IHttpActionResult Login(UserLoginData user)
{
User temp = db.Users.Find(user.UserName);
if (temp != null && user.Password == temp.Password)
{
return(Ok("{}"));
}
else
{
return(BadRequest("{}"));
}
}
public ActionResult List()
{
try
{
int userID = UserLoginData.GetSessionID(Session["UserLoggedIn"]);
return(View(new ClassifiedQueryableNotes(noteBLL.GetDataForNoteList(userID))));
}
catch (Exception ex)
{
TempData["error"] = ex.Message;
return(Redirect(Request.UrlReferrer.AbsolutePath));
}
}
public string deleteNews(string news_id)
{
string response = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
UserLoginData login_data = (UserLoginData)HttpContext.Current.Session["login_data"];
sql = "Delete News Where NEWS_ID='" + news_id + "'";
oracleObj.DeleteCommand = sql;
// ======== Log ========
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_News;
log_data.Username = login_data.User_ID;
log_data.Message = "Delete News with:" + news_id;
// =====================
try
{
if (oracleObj.Delete() >= 0)
{
response = "OK";
// === Log ===
log_data.StatusCode = log_data.LogStatus_SUCCESS;
// ===========
}
else
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_FAILED;
// ===========
}
}
catch (Exception e)
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
// ===========
response = e.Message.ToString();
HttpContext.Current.Session["response"] = "Unit Test:News:deleteNews" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
new Log().WriteLog(log_data);
return(response);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
token = Request.QueryString["token"];
code = Request.QueryString["code"];
country = new Country().getCountry();
foreach (CountryData row in country)
{
ddlCountry.Items.Insert(ddlCountry.Items.Count, new ListItem(row.Country_ThaiName, row.Country_Code));
}
province = new Province().getProvince();
foreach (ProvinceData row in province)
{
ddlProvince.Items.Insert(ddlProvince.Items.Count, new ListItem(row.Province_ThaiName, row.Province_Code));
}
if (!Page.IsPostBack)
{
string sql = "Select * From QUALIFICATIONDETAIL Where UUIDNUMBER ='" + code + "'";
List <QualificationDetail> data = new QualificationDetail().getQualificationDetailManual(sql);
txtQualificationName.Text = data[0].QualificationDegree;
txtDivision.Text = data[0].Division;
txtAcademy.Text = data[0].Academy;
txtYear.Text = data[0].Year;
try { ddlCountry.Items.FindByValue(data[0].Country_Code).Selected = true; } catch { }
try { ddlProvince.Items.FindByValue(data[0].Province_Code).Selected = true; } catch { }
txtProvinceOther.Text = data[0].Province_Other;
txtGPA.Text = data[0].gpa;
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
}
}
public async Task <ApiResponse> Login([FromBody] UserLoginData data)
{
var isEmail = data.EmailOrUsername.IsEmail();
var isUsername = data.EmailOrUsername.IsUsername();
if (!(isEmail || isUsername))
{
ModelState.AddModelError("emailOrUsername", "Enter valid Email/Username");
}
if (!ModelState.IsValid)
{
throw new ApiException(ModelState.AllErrors());
}
var userQuery = _userService.GetAll();
User user;
switch (isUsername)
{
case true:
user = await userQuery.FirstOrDefaultAsync(c => c.UserName == data.EmailOrUsername)
.ConfigureAwait(false);
break;
case false:
user = await userQuery.FirstOrDefaultAsync(c => c.Email == data.EmailOrUsername)
.ConfigureAwait(false);
break;
}
if (user != null)
{
var result = await _signInManager.PasswordSignInAsync(user, data.Password, false, false).ConfigureAwait(false);
if (result.Succeeded)
{
var mapResult = _mapper.Map <User, UserGetData>(user);
return(new ApiResponse(new UserLoginResponse
{
User = mapResult,
}));
}
}
throw new ApiException(MessageBuilder.LoginFault);
}
/*private bool makeUserTempZero()
* {
* try
* {
* this.userTempTable = new UserTempData();
* try
* {
* this.userTempTable.username = this.txtboxUserName.Text;
* this.userTempTable.requestType = null;
* this.userTempTable.requestStatus = null;
* this.userTempTable.quantity = 0;
* this.userTempTable.Date = null;
* this.db.UserTempDatas.InsertOnSubmit(this.userTempTable);
* this.db.SubmitChanges();
* return true;
* }
* catch (SqlException sqlEx)
* {
* MessageBox.Show("UserLoginTable is not created");
* return false;
* }
* return true;
* }catch(NullReferenceException exp)
* {
* MessageBox.Show("Null Ref Exp");
* return false;
* }
*
* }*/
private bool checkUserNameAvailable()
{
string name = this.txtboxUserName.Text;
UserLoginData userLoginTable = db.UserLoginDatas.SingleOrDefault(x => x.username == name);
if (userLoginTable != null)
{
return(false);
}
else
{
return(true);
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
UserLoginData emailData = db.UserLoginDatas.SingleOrDefault(x => x.email == this.emailBox.Text);
if (emailData != null)
{
this.generatePassword();
this.sendEmail(emailData);
}
else
{
MessageBox.Show("INVALID EMAIL");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
code = Request.QueryString["token"];
if (!Page.IsPostBack)
{
string sql = "Select * From SPECIAL_FIELD Where SPEC_FIELD_CODE='" + code + "'";
SpecialFieldData = SpecialFieldObj.getSpecialFieldManual(sql);
txtSPEC_FIELD_CODE.Text = SpecialFieldData[0].SpecialField_Code;
txtSPEC_FIELD_ENGNAME.Text = SpecialFieldData[0].SpecialField_Eng;
txtSPEC_FIELD_SHORTNAME.Text = SpecialFieldData[0].SpecialField_ShortName;
//ddlSPEC_FIELD_STATUS.Items.FindByValue(data.SpecialField_Status).Selected = true;
txtSPEC_FIELD_THAINAME.Text = SpecialFieldData[0].SpecialField_Thai;
facultyData = facultyObj.getFaculty();
foreach (FacultyData d in facultyData)
{
ddlFACULTY.Items.Insert(ddlFACULTY.Items.Count, new ListItem(d.Faculty_Thai, d.Faculty_Code));
}
ddlFACULTY.Items.FindByValue(SpecialFieldData[0].SpecialField_FacultyCode).Selected = true;
statusData = statusObj.getSystemStatus();
foreach (StatusData data in statusData)
{
ddlSPEC_FIELD_STATUS.Items.Insert(ddlSPEC_FIELD_STATUS.Items.Count, new ListItem(data.Status_Thai, data.Status_Code));
}
ddlSPEC_FIELD_STATUS.Items.FindByValue(SpecialFieldData[0].SpecialField_Status).Selected = true;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public string insertEditScholarshipHistory(ScholarshipStudentHistory dataInsert)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Scholarship;
log_data.Username = loginData.User_ID;
log_data.Message = "Insert ScholarshipStudentHistory with: " + dataInsert.SCHOLARSHIP_HISTORY_STUDENT_ID + ", " + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_CODE;
// 41 = เพิ่มใหม่
// 42 = แก้ไข
string historyStatus = "42";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Insert Into SCHOLARSHIP_HISTORY(RECORD_DATE, ACADEMIC_YEAR, SEMESTER, SCHOLARSHIP_CODE, STUDENT_ID, NATION_ID, PASSPORT_ID, SCHOLARSHIP_STARTDATE, SCHOLARSHIP_ENDDATE, SCHOLARSHIP_PERIOD, SCHOLARSHIP_AMOUNT, SCHOLARSHIP_IN_OUT, SCHOLARSHIP_TYPE, SCHOLARSHIP_SOURCE, NEW_REGIS_FEE, PROPERTIES_FEE, STUDY_FACILITY_FEE, IT_FEE, LIBRARY_FEE, HEALTH_FEE, ACTIVITY_FEE, CREDIT_3000, ACCIDENT_FEE, BACHELOR_ACADEMIC_FEE, MASTER_ACADEMIC_FEE, SPECIAL_PROJECT_FEE, SCHOLAR_FEE_COMMENT, MULTIPLE_SCHOLARSHIP, SCHOLARSHIP_STATUS, FINE_FEE, HISTORY_STATUS, RECORD_TIME) Values('" + dataInsert.SCHOLARSHIP_HISTORY_RECORD_DATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACADEMIC_YEAR + "','" + dataInsert.SCHOLARSHIP_HISTORY_SEMESTER + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_CODE + "','" + dataInsert.SCHOLARSHIP_HISTORY_STUDENT_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_NATION_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_PASSPORT_ID + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STARTDATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_ENDDATE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_PERIOD + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_AMOUNT + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_IN_OUT + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_TYPE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_SOURCE + "','" + dataInsert.SCHOLARSHIP_HISTORY_NEW_REGIS_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_PROPERTIES_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_STUDY_FACILITY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_IT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_LIBRARY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_HEALTH_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACTIVITY_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_CREDIT_3000 + "','" + dataInsert.SCHOLARSHIP_HISTORY_ACCIDENT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_BACHELOR_ACADEMIC_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_MASTER_ACADEMIC_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SPECIAL_PROJECT_FEE + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLAR_FEE_COMMENT + "','" + dataInsert.SCHOLARSHIP_HISTORY_MULTIPLE_SCHOLARSHIP + "','" + dataInsert.SCHOLARSHIP_HISTORY_SCHOLARSHIP_STATUS + "','" +
dataInsert.SCHOLARSHIP_HISTORY_FINE_FEE + "','" + historyStatus + "','" + dataInsert.SCHOLARSHIP_HISTORY_RECORD_TIME + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
new Log().WriteLog(log_data);
return(response);
}
public string WizardComplete(WizardModel model)
{
if (model.personalMessage.phrase.Length > 140)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.Conflict;
return("El mensaje personal superó los 140 caracteres.");
}
int userID = UserLoginData.GetSessionID(Session["UserLoggedIn"]);
userBLL.UpdateAvatar(model.avatarImg, userID);
userBLL.ChangePersonalPhrase(userID, model.personalMessage.phrase, model.personalMessage.color);
return("Cambios guardados.");
}
public ActionResult NotesList(int folderID)
{
try
{
int userID = UserLoginData.GetSessionID(Session["UserLoggedIn"]);
ContentInFolderModelView model = new ContentInFolderModelView(folderBLL.GetFolderDataBLL(folderID),
folderBLL.GetNotesInFolderBLL(userID, folderID));
return(View(model));
}
catch (Exception ex)
{
TempData["error"] = ex.Message;
return(RedirectToAction("List"));
}
}
public override void OnHandlerMessage(OperationRequest request, OperationResponse response, ClientPeer peer, SendParameters sendParameters)
{
Dictionary <byte, object> m_dic = request.Parameters;
object value;
string strUserName;
string strUserPassword;
if (m_dic.TryGetValue((byte)ParameterCode.UserRegiste, out value))
{
string strValue = value.ToString();
strValue.Trim();
log.Debug("UserRegisteHandler Get Data：" + strValue);
string[] pStr = strValue.Split(',');
if (pStr.Length == 2)
{
strUserName = pStr[0];
strUserPassword = pStr[1];
log.Debug("RegisterName：" + strUserName + "--RegisterPassword:"******"用户名重复!";
return;
}
else
{
UserLoginData newUser = new UserLoginData();
newUser.Name = strUserName;
string strMD5 = MD5Tool.StringToMD5(strUserPassword);
newUser.Password = strMD5;
int nID = m_mgr.AddUser(newUser);
peer.m_curUser = newUser;
Dictionary <byte, object> dic = new Dictionary <byte, object>();
dic.Add((byte)ParameterCode.UserRegiste, nID.ToString());
Helper.Log("注册新用户：" + nID.ToString());
response.Parameters = dic;
response.ReturnCode = (short)ReturnCode.Success;
log.Debug("UserRegiste Success: Add New User:"******"--P:" + strUserPassword + "--MD5:" + strMD5);
return;
}
}
}
response.ReturnCode = (short)ReturnCode.Error;
log.Debug("Login Error");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
Session.Remove("CurrCode");
Session.Remove("YearVersion");
Session.Remove("NumTQF1");
List <TQF.Curriculum> curriculum = new TQF.Curriculum().getYearVersion();
ddlCOPY_YEAR_VERSION.Items.Clear();
ddlCOPY_YEAR_VERSION.Items.Insert(ddlCOPY_YEAR_VERSION.Items.Count, new ListItem("-- เลือกปี --", "0000"));
foreach (TQF.Curriculum row in curriculum)
{
ddlCOPY_YEAR_VERSION.Items.Insert(ddlCOPY_YEAR_VERSION.Items.Count, new ListItem(row.YearVersion, row.YearVersion));
}
ddlCOPY_CURR_CODE.Items.Clear();
ddlCOPY_CURR_CODE.Items.Insert(ddlCOPY_CURR_CODE.Items.Count, new ListItem("-- เลือกรหัสสูตรที่ต้องการปรับปรุง --", "000000000"));
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
rBtnNEW_SCURR.Enabled = true;
}
else
{
rBtnNEW_SCURR.Enabled = false;
}
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public List <string> getOtherOffice_Authorized(UserLoginData login_data, string user_group_id)
{
List <string> OtherOffice_code = new List <string>();
foreach (AuthorizedSystemData search in login_data.authorize_systemdData)
{
if (search.UserGroup_ID == user_group_id)
{
string code = "";
code = search.OtherOffice_Authorized_Code;
OtherOffice_code.Add(code);
}
}
return(OtherOffice_code);
}
private bool updateLogindata()
{
UserLoginData loginData = db.UserLoginDatas.SingleOrDefault(x => x.username == this.uName);
if (loginData != null)
{
loginData.email = this.txtEmail.Text;
loginData.username = this.txtUserName.Text;
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
public override void Execute(INotification notification)
{
Facade.instance.RegisterCommand(Const.CMD_LOGIN, () => new LoginCommand());
LoginViewMediator mediator = new LoginViewMediator {
ViewComponent = new LoginView()
};
Facade.instance.RegisterMediator(mediator);
Facade.instance.RegisterProxy(new LoginViewProxy());
UserLoginData loginData = new UserLoginData();
loginData.setAccount("acc123");
loginData.setPassword("pwd123");
Facade.instance.SendNotification(Const.CMD_LOGIN, loginData);
}
public List <string> getDepartment_Authorized(UserLoginData login_data, string user_group_id)
{
List <string> department_code = new List <string>();
foreach (AuthorizedSystemData search in login_data.authorize_systemdData)
{
if (search.UserGroup_ID == user_group_id)
{
string code = "";
code = search.Department_Authorized_Code;
department_code.Add(code);
}
}
return(department_code);
}
public ActionResult Create(string toFolder)
{
try
{
int userID = UserLoginData.GetSessionID(Session["UserLoggedIn"]);
CreateNoteModelView model = new CreateNoteModelView();
this.PrepareModelToCreateNote(userID, ref model, Server.UrlDecode(toFolder));
return(View(model));
}
catch (Exception ex)
{
return(RedirectToAction("InternalServerError", "Error", new {
error = ex.InnerException is SqlException ? ex.InnerException.Message : ex.Message
}));
}
}
public ActionResult ChangeFolderPartial(int folderID, string folderName, int noteID)
{
try
{
ChangeFolderModelView model = new ChangeFolderModelView();
model.FolderID = folderID;
model.NoteID = noteID;
model.CurrentFolder = folderName;
model.FoldersComboBox = folderBLL.GetFoldersOfUserBLL(UserLoginData.GetSessionID(Session["UserLoggedIn"]));
return(PartialView("_ChangeFolder", model));
}
catch (Exception ex)
{
return(RedirectToAction("InternalServerError", "Error", new { error = ex.Message }));
}
}
public void deleteFile(List <string> deleteFiles)
{
string FolderPath = ConfigurationManager.AppSettings["NewsUploadFiles"];
UserLoginData login_data = (UserLoginData)HttpContext.Current.Session["login_data"];
// ======== Log ========
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_News;
log_data.Username = login_data.User_ID;
// =====================
foreach (string FileName in deleteFiles)
{
log_data.Message = "Delete Files with:" + FileName;
string FilePath = HttpContext.Current.Server.MapPath(FolderPath + (FileName));
if (System.IO.File.Exists(FilePath))
{
try
{
System.IO.File.Delete(FilePath);
// === Log ===
log_data.StatusCode = log_data.LogStatus_SUCCESS;
// ===========
}
catch (Exception e)
{
// === Log ===
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
// ===========
}
}
else
{
// === Log ===
log_data.Message += " [File Not Found]";
log_data.StatusCode = log_data.LogStatus_FAILED;
// ===========
}
new Log().WriteLog(log_data);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
try
{
if (!Page.IsPostBack)
{
fail.Visible = false;
divSuccess.Visible = false;
string degree_char = Request.QueryString["degree"];
string course_type = Request.QueryString["course_type"];
hourRefer_data = new HourRefer().getHourRefer(degree_char, course_type);
ddlLevel.Items.FindByValue(hourRefer_data.Degree_Char).Selected = true;
ddlCourseType.Items.FindByValue(hourRefer_data.CourseType).Selected = true;
txtReference_Hour.Text = hourRefer_data.HourRefer.ToString();
ddlLevel.Enabled = false;
ddlCourseType.Enabled = false;
}
}
catch (Exception err)
{
Session["response"] = err.ToString();
Response.Redirect("err_response.aspx");
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
public string setPrereq(ApproveAdvisorData setData)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Registration;
log_data.Username = loginData.User_ID;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Update ADVISOR_ALL_APPROVE";
if (setData.Pre_Req != "")
{
sql += " Set PRE_REQ='" + setData.Pre_Req + "' ";
log_data.Message = "Set pre_req with:" + setData.Pre_Req;
}
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString();
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
new Log().WriteLog(log_data);
return(response);
}
public string insertAddProject(ProjectData dataInsert)
{
string response = "";
int i = 0;
ProjectData field = dataInsert;
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_NewStdPayment;
log_data.Username = loginData.User_ID;
log_data.Message = "Insert Project_Addition With:" + field.Project_Code + "'," + field.Project_NewRegister_Fee + "," + field.Project_Card_Fee + "," + field.Project_IT_Fee + "," + field.Project_Health_Fee + "," + field.Project_Library_Fee + "," + field.Project_Properties_Fee + "," + field.Project_Accident_Fee + "," + field.Project_Academic_Fee + "," + field.Project_StudentStatus_Fee + "," + field.Project_Maintaining_Fee + "," + field.Project_Moral_Fee + "," + field.Project_Activity_Fee + "," + field.Project_Charge + "," + field.Project_QE_Fee + "," + field.Project_StudyFacility_Fee + "," + field.Project_StudentReturn_Fee;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into PROJECT_ADDITIONAL(PROJECT_CODE,THEORY_FEE,PRACTICE_FEE,THESIS_PROJ_FEE,PACKET_FEE,NEW_REGIS_FEE,CARD_FEE,IT_FEE,HEALTH_FEE,LIBRARY_FEE,PROPERTIES_FEE,ACCIDENT_FEE,ACADEMIC_FEE,STUDENT_STATUS_FEE,MAINTAINING_FEE,MORAL_FEE,ACTIVITY_FEE,CHARGE,QE_FEE,STUDY_FACILITY_FEE,STUDENT_RETURN_FEE) VALUES('" + field.Project_Code + "'," + field.Project_Theory_Fee + "," + field.Project_Practice_Fee + "," + field.Project_ThesisProject_Fee + "," + field.Project_Packet_Fee + "," + field.Project_NewRegister_Fee + "," + field.Project_Card_Fee + "," + field.Project_IT_Fee + "," + field.Project_Health_Fee + "," + field.Project_Library_Fee + "," + field.Project_Properties_Fee + "," + field.Project_Accident_Fee + "," + field.Project_Academic_Fee + "," + field.Project_StudentStatus_Fee + "," + field.Project_Maintaining_Fee + "," + field.Project_Moral_Fee + "," + field.Project_Activity_Fee + "," + field.Project_Charge + "," + field.Project_QE_Fee + "," + field.Project_StudyFacility_Fee + "," + field.Project_StudentReturn_Fee + ")";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
response = e.Message.ToString();
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
}
i++;
new Log().WriteLog(log_data);
return(response);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_university) || autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
FacultyCode = Request.QueryString["FacId"];
if (!Page.IsPostBack)
{
string sql = "Select * From FACULTY Where FACULTY_CODE='" + FacultyCode + "'";
facultyData = facultyObj.getFacultyManual(sql);
List <CampusData> campusData = new Campus().getCampus();
foreach (CampusData data in campusData)
{
ddlCampus.Items.Insert(ddlCampus.Items.Count, new ListItem(data.Campus_Thai, data.Campus_Code));
}
ddlCampus.Items.FindByValue(facultyData[0].Faculty_CampusCode).Selected = true;
txtFacultyCode.Text = facultyData[0].Faculty_Code;
txtFacultyNameThai.Text = facultyData[0].Faculty_Thai;
txtFacultyNameEng.Text = facultyData[0].Faculty_Eng;
txtFacultyShortName.Text = facultyData[0].Faculty_ShortName;
statusData = statusObj.getSystemStatus();
foreach (StatusData data in statusData)
{
ddlFacultyStatus.Items.Insert(ddlFacultyStatus.Items.Count, new ListItem(data.Status_Thai, data.Status_Code));
}
ddlFacultyStatus.Items.FindByValue(facultyData[0].Faculty_Status).Selected = true;
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.admin_faculty))
{
/*=============================*/
if (!Page.IsPostBack)
{
fail.Visible = false;
divSuccess.Visible = false;
// ประเภทอาจารย์
ddlLecturerType.Items.Clear();
List <LecturerType> lec_type = new List <LecturerType>();
lec_type = new LecturerType().getLecturerType2();
foreach (LecturerType row in lec_type)
{
ddlLecturerType.Items.Insert(ddlLecturerType.Items.Count, new ListItem(row.LecturerTypeName, row.LecturerTypeCode));
}
//===========
// ตำแหน่ง
ddlPosition.Items.Clear();
List <BoardPosData> position_data = new List <BoardPosData>();
position_data = new BoardPos().getBoardPos();
foreach (BoardPosData pos in position_data)
{
ddlPosition.Items.Insert(ddlPosition.Items.Count, new ListItem(pos.Position_Thai, pos.Position_Code));
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["login_data"] == null)
{
Response.Redirect("../index.aspx");
}
else
{
//ตรวจสอบสิทธิ์
login_data = (UserLoginData)Session["login_data"];
if (autro_obj.CheckGroupUser(login_data, group_var.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
/*=============================*/
if (!Page.IsPostBack)
{
divSuccess.Visible = false;
try
{
lecturer = Request.QueryString["lecturer"];
academic_year = Request.QueryString["year"];
semester = Request.QueryString["semester"];
if (new AddWorkLoad().getAddWorkLoad(academic_year, semester, lecturer).Lecturer != null)
{
MsgValidate("ตรวจสอบพบข้อมูลในระบบ โปรดเลือกแก้ไข ข้อมูล");
}
else
{
fail.Visible = false;
}
}
catch (Exception err)
{
MsgValidate(err.ToString());
}
}
/*=============================*/
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
// V1.0.0
public string updateConfigStudentReg(ConfigStudentRegData dataUpdate)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Registration;
log_data.Username = loginData.User_ID;
log_data.Message = "Update ConfigStudentRegistration with: " + dataUpdate.start_date + "," + dataUpdate.end_date + "," + dataUpdate.due_date + "," + dataUpdate.academic_year + "," + dataUpdate.semester + "," + dataUpdate.degree_char + "," + dataUpdate.faculty_code + "," + dataUpdate.student_academic_year;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "";
sql = "Update CONFIG_STD_REG SET START_DATE='" + dataUpdate.start_date + "',STOP_DATE = '" + dataUpdate.end_date + "',DUE_DATE = '" + dataUpdate.due_date + "' Where ACADEMIC='" + dataUpdate.academic_year + "' And SEMESTER='" + dataUpdate.semester + "' And DEGREE_CHAR='" + dataUpdate.degree_char + "' And FACULTY_CODE='" + dataUpdate.faculty_code + "' And STUDENT_ACADEMIC_YEAR='" + dataUpdate.student_academic_year + "' ";
try
{
oracleObj.UpdateCommand = sql;
if (oracleObj.Update() == 1)
{
log_data.StatusCode = log_data.LogStatus_SUCCESS;
response = "OK";
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
HttpContext.Current.Session["response"] = "Unit Test:ConfigStudentReg:updateConfigStudentReg" + " ไม่สามารถดำเนินการได้ ";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
new Log().WriteLog(log_data);
return(response);
}
/// <summary>
/// แก้ไขข้อมูลจากตาราง SYSUSER
/// </summary>
/// <param name="updateData">SysUser Object</param>
/// <returns>Success</returns>
public string updateSysUser(SysUser updateData)
{
string response = "";
UserLoginData loginData = new UserLoginData();
loginData = (UserLoginData)HttpContext.Current.Session["login_data"];
LogData log_data = new LogData();
log_data.ModuleCode = new LogData().Module_Advisor;
log_data.Username = loginData.User_ID;
log_data.Message = "Update Lecturer with: " + updateData.IdCode;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle_tqf2();
string sql = "Update SYSUSER Set FACULTYCODE = '" + updateData.FacultyCode + "',TITLENAMECODE = '" + updateData.TitleNameCode + "',DEPARTMENTCODE = '" + updateData.DepartmentCode + "',USERTYPECODE = '" + updateData.UserTypeCode + "',THNAME = '" + updateData.ThName + "',ENNAME = '" + updateData.EnName + "',THSURNAME = '" + updateData.ThSurName + "',ENSURNAME = '" + updateData.EnSurName + "',USERNAME = '******',PASSWORD = '******',POSITION = '" + updateData.Position + "',ADDRESS = '" + updateData.Address + "',TEL = '" + updateData.Tel + "',EMAIL = '" + updateData.Email + "',OPENSTATUS = '" + updateData.OpenStatus + "',PASSSPORTCODE = '" + updateData.PassportCode + "',SEX = '" + updateData.Sex + "',ACADEMICPOSITIONCODE = '" + updateData.AcademicPositionCode + "',DIVISIONCODE = '" + updateData.DivisionCode + "',BIRTHDAY = '" + updateData.BirthDay + "',BIRTHPROVINCE = '" + updateData.BirthProvince + "',BIRTHPLACE = '" + updateData.BirthPlace + "',COUNTRY = '" + updateData.Country + "',NATIONALITY = '" + updateData.Nationality + "',ETHNICITY = '" + updateData.Ethnicity + "',HEIGHT = '" + updateData.Height + "',WEIGHT = '" + updateData.Weight + "',MARITAL = '" + updateData.Marital + "',OCCUPATION = '" + updateData.Occupation + "',MOBILENUMBER = '" + updateData.MobileNumber + "',TALENT = '" + updateData.Talent + "',HOMENUMBER = '" + updateData.HomeNumber + "',HOMEBUILDING = '" + updateData.HomeBuilding + "',HOMEVILLAGE = '" + updateData.HomeVillage + "',HOMEMOO = '" + updateData.HomeMoo + "',HOMESOI = '" + updateData.HomeSoi + "',HOMEROAD = '" + updateData.HomeRoad + "',HOMETUMBOL = '" + updateData.HomeTumbol + "',HOMEAMPHUR = '" + updateData.HomeAmphur + "',HOMEPROVINCE = '" + updateData.HomeProvince + "',HOMEPOSTCODE = '" + updateData.HomePostCode + "',OFFICENAME = '" + updateData.OfficeName + "',OFFICENUMBER = '" + updateData.OfficeNumber + "',OFFICEBUILDING = '" + updateData.OfficeBuilding + "',OFFICEVILLAGE = '" + updateData.OfficeVillage + "',OFFICEMOO = '" + updateData.OfficeMoo + "',OFFICESOI = '" + updateData.OfficeSoi + "',OFFICEROAD = '" + updateData.OfficeRoad + "',OFFICETUMBOL = '" + updateData.OfficeTumbol + "',OFFICEAMPHUR = '" + updateData.OfficeAmphur + "',OFFICEPROVINCE = '" + updateData.OfficeProvince + "',OFFICEPOSTCODE = '" + updateData.OfficePostCode + "',AFFILIATION = '" + updateData.Affiliation + "',GRAD_LECTURER = '" + updateData.GradLecturer + "',SHORT_NAME = '" + updateData.ShortName + "' Where IDCODE = '" + updateData.IdCode + "'";
oracleObj.UpdateCommand = sql;
try
{
if (oracleObj.Update() == 1)
{
response = "Success";
log_data.StatusCode = log_data.LogStatus_SUCCESS;
}
else
{
log_data.StatusCode = log_data.LogStatus_FAILED;
}
}
catch (Exception e)
{
log_data.StatusCode = log_data.LogStatus_ERROR;
log_data.Message += " [" + e.ToString() + "]";
string exception = e.Message;
HttpContext.Current.Session["response"] = "updateLecturer: " + exception;
HttpContext.Current.Response.Redirect("../err_response.aspx");
}
new Log().WriteLog(log_data);
return(response);
}
void Start()
{
gameObject.AddComponent<AudioSource>();
if(File.Exists(Application.persistentDataPath + "/username.gd")) {
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Open(Application.persistentDataPath + "/username.gd", FileMode.Open);
try{
userLoginData = (UserLoginData)bf.Deserialize(file);
}catch(System.Exception ex){
Debug.LogError(ex.Message);
userLoginData = new UserLoginData("SmartEnglish","test","englishteacher","test",LanguageCode.EN);
}
file.Close();
}else{
userLoginData = new UserLoginData("SmartEnglish","test","englishteacher","test",LanguageCode.EN);
//userLoginData = new UserLoginData("SmartGreek","SmartGreek","GreekTeacher2","password");
}
LocalisationMang.langCode = userLoginData.language;
poRef = PersistentObjMang.getInstance();
connectionTest=new ConnectionError("",RoutineStatus.IDLE);
//testConnection();
prepUIElements();
downloader(true);
}
