private void EditApproval(string action)
{
wcf.parti.Service1 parti = new wcf.parti.Service1();
try
{
var result = parti.EditApproval(action, txtID.Value, txtAppr_Fullname.Value, txtAppr_Position_name.Value, txtAppr_Position_major.Value,
txtAppr_Relationship_trainee.Value, txtAppr_Office_name.Value, txtAppr_Office_tel.Value, txtAppr_Mobile_tel.Value, txtAppr_Email.Value);
if (result == "e3")
{
MessageBox.swalModal(this.Page, "info", "e3: ມີ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ນີ້ໃນຖານຂໍ້ມູນແລ້ວ ລອງໃສ່ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ໃຫມ່...", "");
}
else if (result == "e0")
{
MessageBox.swalModal(this.Page, "error", "en:internal error", "");
}
else if (result == "e2")
{
MessageBox.swalModal(this.Page, "warning", "e2:connection to dbs error...", "");
}
else if (result == "e5")
{
MessageBox.swalModal(this.Page, "success", "ຈັດການຂໍ້ມູນສຳເລັດ...", Request.RawUrl);
parti.LoggingAsync("set", "Trainee Approval", "user: "******"username"].ToString() + " had " + action + " a Trainee Approval: " +
txtAppr_Fullname.Value + " from system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
parti.LoggingAsync("set", "Trainee Approval", ex.Message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
try
{
if (inputUsername.Value == "admin" && inputPassword.Value == "lt4k[aoadmin")
{
Session["tid"] = "0";
Session["id"] = "0";
Session["username"] = "******";
Session["passwd"] = "lt4k[aoadmin";
Session["rules"] = "rw";
Session["user_avatar"] = "img/avatar.png";
Session["fullname"] = "admin";
Session["position"] = "app admin";
Session["loginstatus"] = "1";//1:logged in, 0 or Null:logout
Response.Redirect("Main");
}
else
{
string json_str = parti.GetAuthen(inputUsername.Value, enCoding.SetEncryptData(inputPassword.Value));
if (json_str == "e0")
{
MessageBox.swalToast(this.Page, "error", "e0: ລະບົບຂັດຂ້ອງຕິດຕໍ່ຜູ້ເບີ່ງແຍ່ງດ່ວນ.");
}
else if (json_str == "e1")
{
MessageBox.swalToast(this.Page, "warning", "e1: ຊື່ຜູ້ໃຊ້ ຫລື ລະຫັດຜ່ານ ບໍ່ຖືກຕ້ອງ.");
}
else if (json_str == "e2")
{
MessageBox.swalToast(this.Page, "error", "e2: ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.");
}
else
{
getAuthen = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in getAuthen.GetAuthen)
{
Session["tid"] = vl.tid;
Session["id"] = vl.id;
Session["username"] = vl.username;
Session["passwd"] = vl.passwd;
Session["rules"] = vl.rules;
Session["user_avatar"] = vl.user_avatar;
Session["fullname"] = vl.fullname;
Session["position"] = vl.position;
Session["loginstatus"] = "1";//1:logged in, 0 or Null:logout
Response.Redirect("Main");
}
parti.LoggingAsync("set", "login", "user:"******" had login successful", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
}
catch (Exception ex)
{
MessageBox.swalToast(this.Page, "error", "ex: " + ex.Message.Replace("'", ""));
parti.LoggingAsync("set", "login", ex.Message.ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
protected void btnDel_OnClick(object sender, EventArgs e)
{
wcf.parti.Service1 _parti = new wcf.parti.Service1();
try
{
string action = "del";
string sex = null;
string status = null;
string renamePath = Server.MapPath(txtAvatarHidd_I.Value);
var result = _parti.EditTrainee(action, txtID.Value, txtNameLA.Value, txtNameEng.Value, dtpBD.Value, sex,
status, txtVill.Value, txtDistrict.Value, txtProvince.Value,
txtWork_place.Value, txtDepartment.Value, txtPosition.Value, txtDate_of_govermented.Value,
txtOffice_tel.Value, txtMobile_tel.Value, txtEmail.Value, txtAvatarHidd_I.Value,
txtID.Value, txtReferDoc1Hidd_I.Value, txtReferDoc2Hidd_I.Value, txtReferDoc3Hidd_I.Value,
txtReferDoc4Hidd_I.Value, txtReferDoc5Hidd_I.Value);
if (result == "e3")
{
MessageBox.swalModal(this.Page, "info", "e3: ມີລະຫັດນີ້ໃນຖານຂໍ້ມູນແລ້ວ ລອງໃສ່ລະຫັດໃຫມ່...", "");
}
else if (result == "e0")
{
MessageBox.swalModal(this.Page, "error", "en:internal error", "");
}
else if (result == "e2")
{
MessageBox.swalModal(this.Page, "warning", "e2:connection to dbs error...", "");
}
else if (result == "e5")
{
if (txtAvatarHidd_I.Value != "")
{
File.Delete(renamePath);
}
EditApproval(action);
EditEducation(action);
string currentPage = Request.RawUrl;
MessageBox.swalModal(this.Page, "success", "ຈັດການຂໍ້ມູນສຳເລັດ...", currentPage);
_parti.LoggingAsync("set", "Trainee", "user: "******"username"].ToString() + " had delete a Trainee: " +
txtNameLA.Value + " from system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
_parti.LoggingAsync("set", "Trainee", ex.Message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
public static List <GetLogs> GetgridData(string searchtxt, string date1, string date2)
{
gridData.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.LoggingAsync("get", "Logs", searchtxt, date1, date2);
if (json_str == "e0")//code error
{
MessageBox.swalModal(_Page, "error", "e0:ລະບົບຂັດຂ້ອງຕິດຕໍ່ຜູ້ເບີ່ງແຍ່ງດ່ວນ.", "");
}
else if (json_str == "e1")//no data found
{
MessageBox.swalModal(_Page, "info", "e1:ບໍ່ມີຂໍ້ມູນທີ່ຈະສະແດງ.", "");
}
else if (json_str == "e2")//can't connect databbase
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetLogs)
{
gridData.Add(new GetLogs(vl.id, vl.method, vl.log_txt, vl.date_time));
}
}
return(gridData);
}
protected void EditAction(string eventType, object record)
{
try
{
partiDB.GetCourse claCourse = new partiDB.GetCourse();
Dictionary <string, object> KeyVal = record as Dictionary <string, object>;
Parallel.ForEach(KeyVal, key =>
{
if (key.Key == "id")
{
claCourse.id = (int)key.Value;
}
else if (key.Key == "name")
{
claCourse.name = (string)key.Value;
}
else if (key.Key == "description")
{
claCourse.description = (string)key.Value;
}
});
if (eventType == "endAdd")
{
//wcf add users
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditCourse("add", claCourse.id, true, claCourse.name, claCourse.description);
ReloadData(result);
_parti.LoggingAsync("set", "Course", "user: "******"username"].ToString() + " had add new Course: " +
claCourse.name + " to system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endEdit")
{
//wcf update data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditCourse("edit", claCourse.id, true, claCourse.name, claCourse.description);
ReloadData(result);
_parti.LoggingAsync("set", "Course", "user: "******"username"].ToString() + " had edit a Course: " +
claCourse.name + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endDelete")
{
//wcf delete data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditCourse("del", claCourse.id, true, claCourse.name, claCourse.description);
ReloadData(result);
_parti.LoggingAsync("set", "Course", "user: "******"username"].ToString() + " had delete a Course: " +
claCourse.name + " from system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
private void EditEducation(string action)
{
wcf.parti.Service1 parti = new wcf.parti.Service1();
string country = null;
if (rdEduIn.Checked)
{
country = "in";
}
else if (rdEduOut.Checked)
{
country = "out";
}
try
{
var result = parti.EditEducation(action, txtID.Value, txtEducation_level.Value,
txtEducation_major.Value, country, txtEducated_year.Value, txtEducation_Name.Value);
if (result == "e3")
{
MessageBox.swalModal(this.Page, "info", "e3: ມີ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ນີ້ໃນຖານຂໍ້ມູນແລ້ວ ລອງໃສ່ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ໃຫມ່...", "");
}
else if (result == "e0")
{
MessageBox.swalModal(this.Page, "error", "en:internal error", "");
}
else if (result == "e2")
{
MessageBox.swalModal(this.Page, "warning", "e2:connection to dbs error...", "");
}
else if (result == "e5")
{
MessageBox.swalModal(this.Page, "success", "ຈັດການຂໍ້ມູນສຳເລັດ...", Request.RawUrl);
parti.LoggingAsync("set", "User Trainer Education", "user: "******"username"].ToString() + " had " + action + " a User Trainer Education: " +
txtID.Value + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
parti.LoggingAsync("set", "User Trainer Education", ex.Message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
wcf.parti.Service1 parti = new wcf.parti.Service1();
try
{
var action = "edit";
string sex = null;
string picture_url = null;
string txtid = null;
string status = null;
if (string.IsNullOrEmpty(imageUpload.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(imageUpload.PostedFile.FileName);
var imgfilePath = Server.MapPath("avatar/") + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("avatar/") + txtUsername.Value + extension;
picture_url = "~/avatar/" + txtUsername.Value + extension;
imageUpload.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtAvatarHidd_I.Value = picture_url;
}
if (string.IsNullOrEmpty(txtReferDoc1.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(txtReferDoc1.PostedFile.FileName);
var imgfilePath = Server.MapPath("trainerdocs/") + "1_" + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("trainerdocs/") + "1_" + txtUsername.Value + extension;
picture_url = "trainerdocs/" + "1_" + txtUsername.Value + extension;
txtReferDoc1.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtReferDoc1Hidd.InnerText = picture_url;
txtReferDoc1Hidd_I.Value = picture_url;
}
if (string.IsNullOrEmpty(txtReferDoc2.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(txtReferDoc2.PostedFile.FileName);
var imgfilePath = Server.MapPath("trainerdocs/") + "2_" + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("trainerdocs/") + "2_" + txtUsername.Value + extension;
picture_url = "trainerdocs/" + "2_" + txtUsername.Value + extension;
txtReferDoc2.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtReferDoc2Hidd.InnerText = picture_url;
txtReferDoc2Hidd_I.Value = picture_url;
}
if (string.IsNullOrEmpty(txtReferDoc3.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(txtReferDoc3.PostedFile.FileName);
var imgfilePath = Server.MapPath("trainerdocs/") + "3_" + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("trainerdocs/") + "3_" + txtUsername.Value + extension;
picture_url = "trainerdocs/" + "3_" + txtUsername.Value + extension;
txtReferDoc3.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtReferDoc3Hidd.InnerText = picture_url;
txtReferDoc3Hidd_I.Value = picture_url;
}
if (string.IsNullOrEmpty(txtReferDoc4.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(txtReferDoc4.PostedFile.FileName);
var imgfilePath = Server.MapPath("trainerdocs/") + "4_" + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("trainerdocs/") + "4_" + txtUsername.Value + extension;
picture_url = "trainerdocs/" + "4_" + txtUsername.Value + extension;
txtReferDoc4.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtReferDoc4Hidd.InnerText = picture_url;
txtReferDoc4Hidd_I.Value = picture_url;
}
if (string.IsNullOrEmpty(txtReferDoc5.PostedFile.FileName) == false)
{
var imgfile = Path.GetFileName(txtReferDoc5.PostedFile.FileName);
var imgfilePath = Server.MapPath("trainerdocs/") + "5_" + imgfile;
var extension = Path.GetExtension(imgfilePath);
var renamePath = Server.MapPath("trainerdocs/") + "5_" + txtUsername.Value + extension;
picture_url = "trainerdocs/" + "5_" + txtUsername.Value + extension;
txtReferDoc5.SaveAs(imgfilePath);
if (File.Exists(renamePath))
{
File.Delete(renamePath);
}
File.Move(imgfilePath, renamePath);
txtReferDoc5Hidd.InnerText = picture_url;
txtReferDoc5Hidd_I.Value = picture_url;
}
if (rdMale.Checked)
{
sex = "m";
}
else if (rdFamale.Checked)
{
sex = "f";
}
if (action == "add")
{
txtid = txtID.Value;
}
else if (action == "edit")
{
txtid = txtIDHidden.Value;
}
if (rdDivorce.Checked)
{
status = "d";
}
else if (rdMarried.Checked)
{
status = "m";
}
else if (rdSingle.Checked)
{
status = "s";
}
txtid = txtIDHidden.Value;
var result = parti.EditTrainer(action, txtid, txtNameLa.Value, txtNameEng.Value, dtpBD.Value, sex, status, txtVillage.Value,
txtDistrict.Value, txtProvince.Value, txtWork_place.Value, txtDepartment.Value, txtPosition.Value, txtDate_of_govermented.Value,
txtOffice_tel.Value, txtMobile_tel.Value, txtEmail.Value, txtAvatarHidd_I.Value, txtReferDoc1Hidd_I.Value, txtReferDoc2Hidd_I.Value,
txtReferDoc3Hidd_I.Value, txtReferDoc4Hidd_I.Value, txtReferDoc5Hidd_I.Value, txtUsername.Value);
if (result == "e3")
{
MessageBox.swalModal(this.Page, "info", "e3: ມີ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ນີ້ໃນຖານຂໍ້ມູນແລ້ວ ລອງໃສ່ ລະຫັດ/ຊື່ຜູ້ໃຊ້ ໃຫມ່...", "");
}
else if (result == "e0")
{
MessageBox.swalModal(this.Page, "error", "en:internal error", "");
}
else if (result == "e2")
{
MessageBox.swalModal(this.Page, "warning", "e2:connection to dbs error...", "");
}
else if (result == "e5")
{
EditEducation(action);
MessageBox.swalModal(this.Page, "success", "ຈັດການຂໍ້ມູນສຳເລັດ...", Request.RawUrl);
parti.LoggingAsync("set", "User Trainer", "user: "******"username"].ToString() + " had " + action + " a User Trainer: " +
txtid + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
parti.LoggingAsync("set", "User Trainer", ex.Message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
protected void EditAction(string eventType, object record)
{
try
{
partiDB.GetUsers claUsers = new partiDB.GetUsers();
Dictionary <string, object> KeyVal = record as Dictionary <string, object>;
Parallel.ForEach(KeyVal, key =>
{
if (key.Key == "id")
{
claUsers.id = (int)key.Value;
}
else if (key.Key == "username")
{
claUsers.username = (string)key.Value;
}
else if (key.Key == "passwd")
{
claUsers.passwd = (string)key.Value;
}
else if (key.Key == "rules")
{
claUsers.rules = (string)key.Value;
}
});
if (eventType == "endAdd")
{
//wcf add users
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditUsers("add", claUsers.id, true, claUsers.username, enCoding.SetEncryptData(claUsers.passwd), claUsers.rules);
ReloadData(result);
_parti.LoggingAsync("set", "User", "user: "******"username"].ToString() + " had add a User: "******" on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endEdit")
{
//wcf update data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditUsers("edit", claUsers.id, true, claUsers.username, enCoding.SetEncryptData(claUsers.passwd), claUsers.rules);
ReloadData(result);
_parti.LoggingAsync("set", "User", "user: "******"username"].ToString() + " had edit a User: "******" on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endDelete")
{
//delete data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditUsers("del", claUsers.id, true, claUsers.username, enCoding.SetEncryptData(claUsers.passwd), claUsers.rules);
ReloadData(result);
_parti.LoggingAsync("set", "User", "user: "******"username"].ToString() + " had delete a User: "******" on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
wcf.parti.Service1 _parti = new wcf.parti.Service1();
_parti.LoggingAsync("set", "User", ex.Message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
protected void EditAction(string eventType, object record)
{
try
{
partiDB.GetYearPlan claYearPlan = new partiDB.GetYearPlan();
Dictionary <string, object> KeyVal = record as Dictionary <string, object>;
//foreach (KeyValuePair<string, object> key in KeyVal)
//{
//}
if (eventType == "endAdd")
{
Parallel.ForEach(KeyVal, key =>
{
if (key.Key == "year_plan")
{
claYearPlan.year_plan = (string)key.Value;
}
else if (key.Key.Contains("course_id"))
{
claYearPlan.course_id = key.Value.ToString();
}
else if (key.Key == "target")
{
claYearPlan.target = (int)key.Value;
}
});
//wcf add users
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditYearPlans("add", claYearPlan.id, true, claYearPlan.year_plan,
claYearPlan.course_id, claYearPlan.target, true);
ReloadData(result);
_parti.LoggingAsync("set", "YearPlan", "user: "******"username"].ToString() + " had add a YearPlan: " +
claYearPlan.id + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endEdit")
{
Parallel.ForEach(KeyVal, key =>
{
if (key.Key == "id")
{
claYearPlan.id = (int)key.Value;
}
else if (key.Key == "year_plan")
{
claYearPlan.year_plan = (string)key.Value;
}
else if (key.Key.Contains("course_id"))
{
claYearPlan.course_id = key.Value.ToString();
}
else if (key.Key == "target")
{
claYearPlan.target = (int)key.Value;
}
});
//wcf update data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditYearPlans("edit", claYearPlan.id, true, claYearPlan.year_plan,
claYearPlan.course_id, claYearPlan.target, true);
ReloadData(result);
_parti.LoggingAsync("set", "YearPlan", "user: "******"username"].ToString() + " had edit a YearPlan: " +
claYearPlan.id + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
else if (eventType == "endDelete")
{
Parallel.ForEach(KeyVal, key =>
{
if (key.Key == "id")
{
claYearPlan.id = (int)key.Value;
}
else if (key.Key == "year_plan")
{
claYearPlan.year_plan = (string)key.Value;
}
else if (key.Key.Contains("course_id"))
{
claYearPlan.course_id = key.Value.ToString();
}
else if (key.Key == "target")
{
claYearPlan.target = (int)key.Value;
}
});
//wcf delete data
wcf.parti.Service1 _parti = new wcf.parti.Service1();
var result = _parti.EditYearPlans("del", claYearPlan.id, true, claYearPlan.year_plan,
claYearPlan.course_id, claYearPlan.target, true);
ReloadData(result);
_parti.LoggingAsync("set", "YearPlan", "user: "******"username"].ToString() + " had delete a YearPlan: " +
claYearPlan.id + " on system", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
}
public static void Loging(string method, string txt)
{
wcf.parti.Service1 _parti = new wcf.parti.Service1();
_parti.LoggingAsync("set", method, txt, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), "");
}
