public static string getCountUserAnswer(string q_type, string t_id, string q_id, string a_id)
{
string uan = null;
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
try
{
string json_str = _parti.GetCountUserAnswer(q_type, t_id, q_id, a_id);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
uan = json_str;
}
}
catch (Exception ex)
{
MessageBox.swalModal(_Page, "error", "e0:" + ex.Message, "");
}
return(uan);
}
public static List <GetUserProfile> GetUserProfileInfo(string id)
{
getUserProfile.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTrainerList(id);
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.GetTrainerList)
{
getUserProfile.Add(new GetUserProfile(vl.id, vl.fullname_la, vl.fullname_eng, vl.date_of_birth, vl.sex, vl.status, vl.village, vl.district,
vl.province, vl.work_place, vl.department, vl.position, vl.date_of_govermented, vl.office_tel, vl.mobile_tel, vl.email,
vl.avatar_url, vl.doc1_url, vl.doc2_url, vl.doc3_url, vl.doc4_url, vl.doc5_url, vl.username, vl.education_level, vl.education_major,
vl.education_country, vl.educated_year, vl.education_name));
}
}
return(getUserProfile);
}
public static List <trainingrpt01> GetRPT01Info(string type, string sdate, string edate)
{
listTrainingrpt01s.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (listTrainingrpt01s.Count == 0)
{
string json_str = _parti.GetTrainingRPT01(type, sdate, edate);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.trainingrpt01)
{
listTrainingrpt01s.Add(new trainingrpt01(vl.course_id, vl.course_name, vl.training_id, vl.title,
vl.total_trainee, vl.date_range, vl.organizer, vl.total_event, vl.training_address, vl.total_trainee_fmale));
}
}
}
return(listTrainingrpt01s);
}
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);
}
public static List <GetTrainingIDName> getTrainingId(string id, string title)
{
GetTrainingIdNames.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (GetTrainingIdNames.Count == 0)
{
string json_str = _parti.GetTrainingIdNames(id, title);
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.GetTrainingIDName)
{
GetTrainingIdNames.Add(new GetTrainingIDName(vl.id, vl.title));
}
}
}
return(GetTrainingIdNames);
}
public static List <GetTrainingExperience_Trainer> GetTrainingExperiences_Trainer(string id)
{
listTrainingExperiences_Trainer.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (listTrainingExperiences_Trainer.Count == 0)
{
string json_str = _parti.GetTrainingExperience_Trainer(id);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetTrainingExperience_Trainer)
{
listTrainingExperiences_Trainer.Add(new GetTrainingExperience_Trainer(vl.training_id,
vl.title, vl.int_or_ext, vl.address, vl.training_date, vl.trainer_id));
}
}
}
return(listTrainingExperiences_Trainer);
}
public static List <GetQAnswer> GetQAnswerID(string t_id, string q_id)
{
listGetQAnswer.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (listGetQAnswer.Count == 0)
{
string json_str = _parti.GetQAnswer(t_id, q_id);
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
{
var i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetQAnswer)
{
listGetQAnswer.Add(new GetQAnswer(vl.a_id, vl.answer_text, vl.q_id, vl.t_id, vl.status, vl.date_of_modified_date));
}
}
}
return(listGetQAnswer);
}
public static List <GetExperience> GetExperianceInfo(string exper_id)
{
listGetExperiance.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (listGetExperiance.Count == 0)
{
string json_str = _parti.GetExperience(exper_id);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetExperience)
{
listGetExperiance.Add(new GetExperience(vl.id, vl.experience_id, vl.responsibility, vl.office, vl.years));
}
}
}
return(listGetExperiance);
}
public static List <CheckTraineeForTraining> checkTraineeForTrainings(string trainee_id, string course_id)
{
listCheckTraineeForTraining.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.CheckTraineeForTraining(trainee_id, course_id);
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.CheckTraineeForTraining)
{
listCheckTraineeForTraining.Add(new CheckTraineeForTraining(vl.id, vl.trainee_id, vl.course_id, vl.course_name,
vl.title, vl.training_address, vl.training_date, vl.code));
}
}
return(listCheckTraineeForTraining);
}
public static List <GetTrainerByTraining> GetTrainerByTrainings(string id)
{
TrainerByTrainings.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTrainerByTraining(id);
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
{
int i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetTrainerByTraining)
{
TrainerByTrainings.Add(new GetTrainerByTraining(vl.training_id, vl.trainer_id, vl.fullname, vl.work_place));
i++;
}
}
return(TrainerByTrainings);
}
public static List <GetCourse> GetgridData()
{
gridData.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (gridData.Count == 0)
{
string json_str = _parti.GetCourse();
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.GetCourse)
{
gridData.Add(new GetCourse(vl.id, vl.name, vl.description));
}
}
}
return(gridData);
}
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"), "");
}
}
private List <GetQTitle> GetQTitleList(string t_id)
{
listGetQTitle.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (listGetQTitle.Count == 0)
{
string json_str = _parti.GetQTitle(t_id);
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
{
var i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetQTitle)
{
listGetQTitle.Add(new GetQTitle(vl.t_id, vl.title_name, vl.training_id, vl.date_of_modified_data, vl.q_type));
HtmlElement _tbody = new HtmlElement();
var QType = "";
if (vl.q_type == "b")
{
QType = "ຄຳຖາມກ່ອນຝຶກ";
}
else if (vl.q_type == "a")
{
QType = "ຄຳຖາມຫຼັງຝຶກ";
}
_tbody.InnerHtml = "<tr class='evalist'><td class='col s1 m1 l1'>" + i + "</td>" +
"<td class='col s2 m2 l2'>" + vl.t_id + "</td>" +
"<td class='col s4 m4 l4'>" + vl.title_name + "</td>" +
"<td class='col s2 m2 l2'>" + QType + " </td>" +
"<td class='col s3 m3 l3 center'><div class='row right'><div class='col'>" +
"<a class='btn-floating waves-effect tooltipped hvr-grow-shadow' data-position='left' data-tooltip='ແກ້ໄຂ' " +
"id='btnEdit" + i + "' name='" + vl.t_id + "' onclick='GetQInfo(" + (i - 1) + ", this.name)'><i class='material-icons right'>edit</i>" +
"</a></div><div class='col'><a class='btn-floating waves-effect tooltipped hvr-grow-shadow' data-position='top' " +
"data-tooltip='ເປີດຫນ້າແບບຟອມສຳລັບຜູ້ຝຶກ' id='btnEvaLink" + i + "' name='" + vl.t_id + "' onclick='GenLink(this.name, " + i + ")'>" +
"<i class='material-icons right'>open_in_new</i></a></div><div class='col'><a class='btn-floating waves-effect tooltipped hvr-grow-shadow modal-trigger' data-position='right' " +
"data-tooltip='ສ້າງ QR Code ສຳລັບແບບຟອມນີ້' id='btnQRGent" + i + "' name='" + vl.t_id + "' onclick='GenQRCode(this.name, " + i + ")'><i class='fas fa-qrcode'></i></a></div></div></td></tr>";
tbody.Controls.Add(_tbody);
i++;
}
}
}
return(listGetQTitle);
}
public List <GetTraineeList> GetTraineeLists()
{
TraineeLists.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTraineeList("");
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
{
int i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetTraineeList)
{
TraineeLists.Add(new GetTraineeList(vl.id, vl.fullname_la, vl.fullname_eng, vl.date_of_birth, vl.sex, vl.status, vl.village, vl.district,
vl.province, vl.work_place, vl.department, vl.position, vl.date_of_govermented, vl.office_tel, vl.mobile_tel, vl.email, vl.avatar_url,
vl.approval_id, vl.doc1_url, vl.doc2_url, vl.doc3_url, vl.doc4_url, vl.doc5_url, vl.appr_id, vl.appr_fullname, vl.appr_position_name, vl.appr_position_major,
vl.appr_relationship_trainee, vl.appr_office_name, vl.appr_office_tel, vl.appr_mobile_tel, vl.appr_email, vl.education_level, vl.education_major,
vl.education_country, vl.educated_year, vl.education_name));
//Render Table
HtmlElement _tbody = new HtmlElement();
_tbody.InnerHtml = "<tr id='" + i + "' class='search_result'>" +
"<td>" + i + "</td>" +
"<td><img class='materialboxed circle z-depth-3' width='50' " +
"height='50' src='" + vl.avatar_url + "'></td>" +
"<td>" + vl.id + "</td>" +
"<td>" + vl.fullname_la + "</td>" +
"<td>" + vl.work_place + "</td>" +
"<td><div class='row'><div class='col'><button type='button' " +
"class='btn btn-small teal darken-2 tooltipped hvr-grow-shadow modal-trigger z-depth-3' " +
"href='#modalTrainee' data-position='left' data-tooltip='ແກ້ໄຂຂໍ້ມູນ' " +
"id='" + (i - 1) + "' onclick='SetTraineeInfo(this.id)'>" +
"<i class='material-icons'>edit</i></button></div></div></td></tr>";
tbBody.Controls.Add(_tbody);
i++;
}
lblTotalTrainer.InnerText = (i - 1).ToString();
}
return(TraineeLists);
}
private List <GetTrainerList> GetTrainerLists()
{
TrainerLists.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTrainerList("");
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
{
int i = 0;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetTrainerList)
{
TrainerLists.Add(new GetTrainerList(vl.id, vl.fullname_la, vl.fullname_eng, vl.date_of_birth, vl.sex, vl.status, vl.village, vl.district,
vl.province, vl.work_place, vl.department, vl.position, vl.date_of_govermented, vl.office_tel, vl.mobile_tel, vl.email,
vl.avatar_url, vl.doc1_url, vl.doc2_url, vl.doc3_url, vl.doc4_url, vl.doc5_url, vl.username, vl.education_level, vl.education_major,
vl.education_country, vl.educated_year, vl.education_name));
//Render Carousel
HtmlElement carouselItem = new HtmlElement();
carouselItem.InnerHtml = "<div class='card card-profiler laotxt hvr-grow-shadow' data-cindex='" + i + "'>" +
"<div class='card-image'>" +
"<a href='#'><img class='img' src='" + vl.avatar_url.Replace("~", "") + "'></a>" +
"</div>" +
"<div class='table center'>" +
"<p class='truncate'>" + vl.fullname_la + "</p>" +
"<p class='truncate'>" + vl.position + "</p>" +
"<button id='btn" + i + "' value='" + i + "' onclick='SetTrainerInfo(this.value); return false;' type='button' " +
"class='btn-floating btn-small waves-effect waves-light red darken-3 tooltipped modal-trigger' href='#modalTrainer' data-position='buttom' " +
"data-tooltip='ຂໍ້ມູນເພີ່ມຕື່ມ'><i class='material-icons'>keyboard_arrow_down</i></button>" +
"</div></div>";
crsTrainerList.Controls.AddAt(i, carouselItem);
i++;
}
lblTotalTrainer.InnerText = i.ToString();
}
return(TrainerLists);
}
public List <GetCompareYearPlan> SumYearPlanThisyear()
{
planByTimeRanges.Clear();
try
{
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
gridDataCourses = GetgridData();
if (planByTimeRanges.Count == 0)
{
foreach (var i in gridDataCourses)
{
if (i.id == 0)
{
goto Line1;
}
else
{
string json_str = _parti.GetCompareYearPlan(i.id.ToString(), thisyear, "Y");
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetCompareYearPlan)
{
planByTimeRanges.Add(new GetCompareYearPlan(thisyear, i.id.ToString(), vl.CourseName, vl.Targets, vl.DoneTarget));
}
}
}
}
}
}
catch (Exception ex)
{
MessageBox.swalModal(_Page, "error", "e0:" + ex.Message, "");
}
Line1:
return(planByTimeRanges);
}
public List <SumYearlyCourse> GetpieChart()
{
List <@SumYearlyCourse> chartData = new List <@SumYearlyCourse>();
try
{
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.SumYearlyCourse();
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.SumYearlyCourse)
{
chartData.Add(new SumYearlyCourse(vl.course, vl.total, vl.course + ", " + vl.total.ToString("N")));
}
}
catch (Exception ex)
{
MessageBox.swalModal(this.Page, "error", "en:internal error[" + ex.Message.Replace("'", "") + "]", "");
}
return(chartData);
}
public static List <GetYearPlan> GetgridDataYearPlans()
{
try
{
gridDataYearPlans.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (gridDataYearPlans.Count == 0)
{
string json_str = _parti.GetYearPlans("");
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.GetYearPlans)
{
gridDataYearPlans.Add(new GetYearPlan(vl.id, vl.year_plan, vl.course_id, vl.target));
}
}
}
}
catch (Exception)
{
gridDataYearPlans = null;
}
return(gridDataYearPlans);
}
public List <GetTrainingList> GetTrainingLists()
{
TrainingLists.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTrainingList("");
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
{
int i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetTrainingList)
{
TrainingLists.Add(new GetTrainingList(vl.id, vl.title, vl.course_id, vl.course_name, vl.int_or_ext,
vl.training_address, vl.training_district, vl.training_province, vl.training_days, vl.training_date,
vl.description, vl.date_of_modified_date));
//Render Card Training Main
var MMMM = vl.training_date.ToString("MMMM");
var ddyyyy = vl.training_date.ToString(" dd, yyyy");
var TningDate = "";
switch (MMMM)
{
case "January":
TningDate = "ມັງກອນ" + ddyyyy;
break;
case "February":
TningDate = "ກຸມພາ" + ddyyyy;
break;
case "March":
TningDate = "ມີນາ" + ddyyyy;
break;
case "April":
TningDate = "ເມສາ" + ddyyyy;
break;
case "May":
TningDate = "ພຶດສະພາ" + ddyyyy;
break;
case "June":
TningDate = "ມິຖຸນາ" + ddyyyy;
break;
case "July":
TningDate = "ກໍລະກົດ" + ddyyyy;
break;
case "August":
TningDate = "ສິງຫາ" + ddyyyy;
break;
case "September":
TningDate = "ກັນຍາ" + ddyyyy;
break;
case "October":
TningDate = "ຕຸລາ" + ddyyyy;
break;
case "November":
TningDate = "ພະຈິກ" + ddyyyy;
break;
case "December":
TningDate = "ທັນວາ" + ddyyyy;
break;
}
HtmlElement _tbody = new HtmlElement();
_tbody.InnerHtml = "<div class='card hvr-grow-shadow' id='" + vl.id + "'>" +
"<div class='card-image'>" +
"<img src = 'img/" + vl.course_id + ".jpg' class='img'>" +
"<a class='btn-floating halfway-fab waves-effect waves-light red accent-1 " +
"tooltipped' data-position='right' data-tooltip='ລາຍລະອຽດ' id='" + (i - 1) + "' name='" + vl.id + "' onclick='SetTrainingInfo(this.id, this.name)'>" +
"<i class='small material-icons'>more_vert</i></a>" +
"</div>" +
"<div class='card-content grey lighten-3'>" +
"<b class='card-title black-text'>" + TningDate + "</b>" +
"<p>" + vl.title + "</p>" +
"<p>" + vl.training_address + "</p>" +
"<a class='tooltipped' " +
"data-position='right' data-tooltip='ລົບ' name='" + vl.id + "' id='" + vl.training_date.ToString("yyyy-MM-dd") + "' " +
"onclick='DelTraining(this.name, this.id)'><i class='material-icons red-text darken-3'>delete</i></a>" +
"<p class='gray-text center' style='font-size:xx-small'>id:" + vl.id + "</p>" +
"</div></div>";
cardTraining.Controls.Add(_tbody);
i++;
}//);
}
return(TrainingLists);
}
private List <GetCompareYearPlan> GetCompareYear(string courseID, string QorY, string times_range)
{
try
{
chartCompareYearPlans.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (chartCompareYearPlans.Count == 0)
{
string json_str = _parti.GetCompareYearPlan(courseID, times_range, QorY);
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
{
int tg = 0;
int dtg = 0;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetCompareYearPlan)
{
chartCompareYearPlans.Add(new GetCompareYearPlan(vl.PlanType, vl.CourseID, vl.CourseName, vl.Targets, vl.DoneTarget));
lblYearPlan.InnerText = vl.PlanType;
lblCourseName.InnerText = vl.CourseName;
lblTargets.InnerText = vl.Targets;
tg = Convert.ToInt16(vl.Targets);
lblDoneTarget.InnerText = vl.DoneTarget;
dtg = Convert.ToInt16(vl.DoneTarget);
}
if (dtg > tg)
{
dtg = (dtg * 100) / tg;
lblDetails.InnerText = "ປະຕິບັດໄດ້ລື່ນຄາດຫມາຍຄິດໄລ່ເປັນ " + dtg + " ສ່ວນຮ້ອຍຂອງໂຕເລກຄາດຫມາຍ.";
}
else if (dtg < tg)
{
dtg = (dtg * 100) / tg;
lblDetails.InnerText = "ປະຕິບັດໄດ້ລຸດຄາດຫມາຍຄິດໄລ່ເປັນ " + dtg + " ສ່ວນຮ້ອຍຂອງໂຕເລກຄາດຫມາຍ.";
}
else if (dtg == tg)
{
dtg = (dtg * 100) / tg;
lblDetails.InnerText = "ປະຕິບັດໄດ້ຕາມຄາດຫມາຍຄິດໄລ່ເປັນ " + dtg + " ສ່ວນຮ້ອຍຂອງໂຕເລກຄາດຫມາຍ.";
}
}
}
}
catch (Exception)
{
chartCompareYearPlans = null;
}
return(chartCompareYearPlans);
}
public static List <GetAllQuestionList> getAllQuestionLists(string course_id, string sdate, string edate)
{
questionLists.Clear();
try
{
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
if (questionLists.Count == 0)
{
if (course_id == "0")
{
foreach (var i in gridDataCourses)
{
if (i.id == 0)
{
goto Line1;
}
else
{
string json_str = _parti.GetAllQuestionList(i.id.ToString(), sdate, edate);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetAllQuestionList)
{
questionLists.Add(new GetAllQuestionList(vl.t_id, vl.title, vl.course_name, vl.training_address, vl.org, vl.sdate, vl.edate));
}
}
}
}
}
else
{
string json_str = _parti.GetAllQuestionList(course_id, sdate, edate);
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 database
{
MessageBox.swalModal(_Page, "warning", "e2:ບໍ່ສາມາດເຊື່ອມຕໍ່ຖານຂໍ້ມູນໄດ້.", "");
}
else
{
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
foreach (var vl in rootObject.GetAllQuestionList)
{
questionLists.Add(new GetAllQuestionList(vl.t_id, vl.title, vl.course_name, vl.training_address, vl.org, vl.sdate, vl.edate));
}
}
}
}
}
catch (Exception ex)
{
MessageBox.swalModal(_Page, "error", "e0:" + ex.Message, "");
}
Line1:
return(questionLists);
}
public List <Trainee.GetTraineeList> GetTraineeLists()
{
TraineeLists.Clear();
wcf.parti.Service1 _parti = new wcf.parti.Service1();
partiDB.RootObject rootObject = new partiDB.RootObject();
string json_str = _parti.GetTraineeList("");
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
{
int i = 1;
rootObject = JsonConvert.DeserializeObject <partiDB.RootObject>(json_str);
//Parallel.ForEach(rootObject.GetTraineeList, vl =>
//{
foreach (var vl in rootObject.GetTraineeList)
{
TraineeLists.Add(new Trainee.GetTraineeList(vl.id, vl.fullname_la, vl.fullname_eng, vl.date_of_birth, vl.sex, vl.status, vl.village, vl.district,
vl.province, vl.work_place, vl.department, vl.position, vl.date_of_govermented, vl.office_tel, vl.mobile_tel, vl.email, vl.avatar_url,
vl.approval_id, vl.doc1_url, vl.doc2_url, vl.doc3_url, vl.doc4_url, vl.doc5_url, vl.appr_id, vl.appr_fullname, vl.appr_position_name, vl.appr_position_major,
vl.appr_relationship_trainee, vl.appr_office_name, vl.appr_office_tel, vl.appr_mobile_tel, vl.appr_email, vl.education_level, vl.education_major,
vl.education_country, vl.educated_year, vl.education_name));
//Render Table Trainer Choice
HtmlElement _tbody = new HtmlElement();
HtmlElement _tbody2 = new HtmlElement();
_tbody.InnerHtml = "<tr id='1Tnee" + i + "' class='trTrainee'>" +
"<td>" + vl.fullname_la + ", " + vl.work_place + ".</td>" +
"<td><div class='row'><div class='col'>" +
"<button type='button' class='btn-floating btn-small z-depth-3 blue tooltipped " +
"hvr-grow-shadow' " +
"href='#!' data-position='left' data-tooltip='ເລືອກເອົາ' id='1Tnee" + i + "' name='2Tnee" + i + "'" +
"onclick='Select(this.id, this.name)'><i class='material-icons'>send</i></button>" +
"</div> <div class='col'></div></div></td>" +
"<input type='hidden' value='" + vl.id + "' id='i1Tnee" + i + "'/></tr>";
_tbody2.InnerHtml = "<tr id='2Tnee" + i + "' hidden>" +
"<td>" + vl.fullname_la + ", " + vl.work_place + ".</td>" +
"<td><div class='row'><div class='col'>" +
"<button type='button' class='btn-floating btn-small z-depth-3 red darken-3 tooltipped " +
"hvr-grow-shadow' " +
"href='#!' data-position='right' data-tooltip='ລົບອອກ' id='2Tnee" + i + "' name='1Tnee" + i + "'" +
"onclick='Disselect(this.id, this.name)'><i class='material-icons'>delete_forever</i></button>" +
"</div> <div class='col'></div></div></td>" +
"<input type='hidden' id='i2Tnee" + i + "' value='" + vl.id + "' /></tr>";
tbTneeBody1.Controls.Add(_tbody);
tbTneeBody2.Controls.Add(_tbody2);
i++;
}//);
}
return(TraineeLists);
}
