private void showEditForm(int mac_id)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "macallowed/get_at&mac_id=" + mac_id.ToString());
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (get.result)
{
MacAddressEditForm editForm = new MacAddressEditForm();
editForm.G = this.G;
int id = sr.macallowed.First <MacAllowed>().id;
string mac_address = sr.macallowed.First <MacAllowed>().mac_address;
editForm.editing_mac_id = id;
editForm.txtMacAddress.Text = mac_address;
if (editForm.ShowDialog() == DialogResult.OK)
{
this.loadMacAddressData(mac_id);
}
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
}
}
private void IstabAddEditForm_Load(object sender, EventArgs e)
{
if (this.mode == FORM_MODE.ADD)
{
this.Text = "Add data : " + Istab.getTabtypTitle(this.tabtyp);
this.txtTypcod.Focus();
}
else
{
this.Text = "Edit data : " + Istab.getTabtypTitle(this.tabtyp);
this.txtTypcod.Enabled = false;
this.txtAbbreviate_th.Focus();
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "istab/get_by_id&id=" + this.istab.id);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.istab != null)
{
this.istab = sr.istab.First <Istab>();
this.txtTypcod.Text = this.istab.typcod;
this.txtAbbreviate_en.Text = this.istab.abbreviate_en;
this.txtAbbreviate_th.Text = this.istab.abbreviate_th;
this.txtTypdes_en.Text = this.istab.typdes_en;
this.txtTypdes_th.Text = this.istab.typdes_th;
}
}
}
}
private string GetTrainerName()
{
string trainer = "";
if (this.training_list != null)
{
trainer += (this.training_list.Count > 0 ? "อบรม(" : "");
int trainer_count = 0;
foreach (TrainingCalendar t in this.training_list)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_realname&username="******"," + sr.users[0].name);
}
else
{
trainer += "";
}
}
trainer += (training_list.Count > 0 ? ")" : "");
}
return(trainer);
}
private void inquireAll()
{
if (this.serial_list.Count == 0)
{
string ids = string.Empty;
for (int i = 0; i <= 100; i++)
{
if (i == 0)
{
ids += this.serial_id_list[i].id.ToString();
}
else
{
ids += "," + this.serial_id_list[i].id.ToString();
}
}
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "serial/get_inquiry&sort=" + this.sortMode + "&ids=" + ids);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.serial_list.Count > 0)
{
this.serial_list = sr.serial_list;
this.toolStripLoadedRec.Text = this.serial_list.Count.ToString();
this.toolStripTotalRec.Text = this.serial_id_list.Count.ToString();
}
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
}
}
}
private void LoadDependenciesData()
{
#region Users list
CRUDResult get_user = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr_user = JsonConvert.DeserializeObject <ServerResult>(get_user.data);
if (sr_user.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.list_users = sr_user.users;
}
#endregion Users list
#region Leave reason
CRUDResult get_leave_cause = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "istab/get_leave_cause");
ServerResult sr_leave_cause = JsonConvert.DeserializeObject <ServerResult>(get_leave_cause.data);
if (sr_leave_cause.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.list_reason = sr_leave_cause.istab;
}
#endregion Leave reason
#region Medical Certificate
this.list_medcert.Add(new ComboboxItem("N/A (ไม่ระบุ)", 9, "X"));
this.list_medcert.Add(new ComboboxItem("ไม่มีใบรับรองแพทย์", 0, "N"));
this.list_medcert.Add(new ComboboxItem("มีใบรับรองแพทย์", 1, "Y"));
#endregion Medical Certificate
#region Status
this.list_status.Add(new ComboboxItem("WAIT", (int)CustomDateEvent.EVENT_STATUS.WAIT_FOR_CONFIRM, "WAIT"));
this.list_status.Add(new ComboboxItem("CONFIRMED", (int)CustomDateEvent.EVENT_STATUS.CONFIRMED, "CONFIRMED"));
this.list_status.Add(new ComboboxItem("CANCELED", (int)CustomDateEvent.EVENT_STATUS.CANCELED, "CANCELED"));
#endregion Status
}
private void LoadDependenciesData()
{
CRUDResult get_users = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr_users = JsonConvert.DeserializeObject <ServerResult>(get_users.data);
if (sr_users.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.list_users = sr_users.users;
}
}
private void GetServerData(string route_path)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + route_path);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
this.macloud_list = sr.macloud_list;
this.macloud_list_filtered = this.macloud_list.FindAll(m => m.SERIAL_ID > -1);
this.bs.DataSource = this.macloud_list_filtered;
this.bs.ResetBindings(true);
}
public void RefreshData()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "eventcalendar/get_event&from_date=" + this.date.ToMysqlDate() + "&to_date=" + this.date.ToMysqlDate());
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.event_list = sr.event_calendar;
this.training_list = sr.training_calendar;
this.note_calendar = sr.note_calendar.Find(t => t.date == this.date.ToMysqlDate());
}
}
public void RefreshData()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "eventcalendar/get_event&from_date=" + this.date.Value.ToMysqlDate() + "&to_date=" + this.date.Value.ToMysqlDate());
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.absent_list = sr.event_calendar.ToAbsentViewModel(this.absent_cause, this.users_list, this.max_leave);
this.trainer_list = sr.training_calendar;
this.note = sr.note_calendar.Where(t => t.date == this.date.Value.ToMysqlDate()).FirstOrDefault();
}
}
private void getDealer()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "dealer/get_list");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.dealer != null)
{
this.dealers = sr.dealer;
}
}
}
private void workerTestConnection_Dowork(object sender, DoWorkEventArgs e)
{
CRUDResult get = ApiActions.GET(this.mskMainURL.Text + "test/test_connection");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.connection_success = true;
}
else
{
this.connection_success = false;
}
}
public string GetEventAbbreviate(string event_type, string event_code)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "istab/get_by_typcod&typcod=" + event_code + "&tabtyp=" + event_type);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.istab[0].abbreviate_th);
}
else
{
return("");
}
}
public static List <Istab> GetIstab(string tabtyp)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "istab/get_all&tabtyp=" + tabtyp + "&sort=typcod");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.istab);
}
else
{
return(new List <Istab>());
}
}
private List <Users> GetUserInGroup(string usergroup)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_user_in_group&usergroup=" + usergroup);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.users);
}
else
{
return(null);
}
}
private void LoadDependenciesData()
{
#region Load users_list from server
CRUDResult get_user = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr_user = JsonConvert.DeserializeObject <ServerResult>(get_user.data);
if (sr_user.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.list_users = sr_user.users;
}
#endregion Load users_list from server
this.BindingControlEventHandler();
}
public static List <Users> GetUsers()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
return(sr.users);
//if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
//{
// return sr.users;
//}
//else
//{
// return new List<Users>();
//}
}
public static NoteCalendar GetSingleNoteCalendar(DateTime date)
{
string url = PreferenceForm.API_MAIN_URL() + "notecalendar/get_single_note&date=" + date.ToString("yyyy-MM-dd", CultureInfo.GetCultureInfo("en-US"));
CRUDResult get = ApiActions.GET(url);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.note_calendar.FirstOrDefault());
}
else
{
return(null);
}
}
private List <Users> GetTrainerAll()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_trainer");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.users);
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
return(null);
}
}
public static List <NoteCalendar> GetNoteCalendarList(int year)
{
string url = PreferenceForm.API_MAIN_URL() + "notecalendar/get_holiday_note&year=" + year.ToString();
CRUDResult get = ApiActions.GET(url);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.note_calendar);
}
else
{
return(null);
}
}
private List <Users> GetTrainerSelected()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "trainingcalendar/get_trainer&date_from=" + this.date_event.Date.ToMysqlDate() + "&date_to=" + this.date_event.Date.ToMysqlDate());
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.users);
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
return(null);
}
}
private void inquiryNext()
{
string ids = string.Empty;
int last_item_id = this.serial_list.Last <Serial_list>().ID;
int last_item_ndx = this.serial_id_list.FindIndex(t => t.id == last_item_id);
if (last_item_ndx < this.serial_id_list.Count - 1)
{
int rows_to_load = Convert.ToInt32(this.dgvSerial.ClientSize.Height / 25) + 10; // +(this.serial_id_list.Count - last_item_ndx < 100 ? this.serial_id_list.Count - last_item_ndx : 0);
int start_ndx = last_item_ndx + 1;
//int stop_ndx = (start_ndx + rows_to_load > this.serial_id_list.Count - 1 ? (this.serial_id_list.Count - 1) - start_ndx : start_ndx + rows_to_load);
int stop_ndx = (start_ndx + rows_to_load > this.serial_id_list.Count - 1 ? this.serial_id_list.Count - 1 : start_ndx + rows_to_load);
for (int i = start_ndx; i <= stop_ndx; i++)
{
if (i == start_ndx)
{
ids += this.serial_id_list[i].id.ToString();
}
else
{
ids += "," + this.serial_id_list[i].id.ToString();
}
}
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "serial/get_inquiry&sort=" + this.sortMode + "&ids=" + ids);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.serial_list.Count > 0)
{
int current_item_id = (int)this.dgvSerial.Rows[this.dgvSerial.CurrentCell.RowIndex].Cells[0].Value;
this.serial_list = this.serial_list.Concat <Serial_list>(sr.serial_list).ToList <Serial_list>();
this.dgvSerial.DataSource = this.serial_list;
int current_item_ndx = this.serial_list.FindIndex(t => t.ID == current_item_id);
this.dgvSerial.Rows[current_item_ndx].Cells[1].Selected = true;
this.dgvSerial.HorizontalScrollingOffset = this.h_scroll_pos;
this.toolStripLoadedRec.Text = this.serial_list.Count.ToString();
}
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
}
}
}
private void LoadDependenciesData()
{
#region Get users(support) data from server and push into cbSupport
//CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_support_users");
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.list_users = sr.users;
}
else
{
this.list_users = new List <Users>();
}
#endregion Get users(support) data from server and push into cbSupport
}
private void btnGo_Click(object sender, EventArgs e)
{
bool get_success = false;
string err_msg = "";
this.FormProcessing();
string users_name = ((Users)((ComboboxItem)this.cbUsers.SelectedItem).Tag).username;
string date_from = this.dtStart.Value.ToMysqlDate();
string date_to = this.dtEnd.Value.ToMysqlDate();
string sernum = (this.rbSernum.Checked ? this.txtCompnam.Texts : null);
string compnam = (this.rbCompnam.Checked ? this.txtCompnam.Texts : null);
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += delegate
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "spylog/get_log&users_name=" + users_name + "&date_from=" + date_from + "&date_to=" + date_to + (sernum != null ? "&sernum=" + sernum : "") + (compnam != null ? "&compnam=" + compnam : ""));
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
get_success = true;
this.list_spylog = sr.spy_log;
}
else
{
get_success = false;
err_msg = sr.message;
}
};
worker.RunWorkerCompleted += delegate
{
this.FormReading();
if (get_success)
{
this.FillDgvHistory();
}
else
{
MessageAlert.Show(err_msg, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
}
};
worker.RunWorkerAsync();
}
private void macAddressAllowedToolStripMenuItem_Click(object sender, EventArgs e)
{
CRUDResult res = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "macallowed/get_all");
if (res.result)
{
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(res.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
MacAddressList wind = new MacAddressList();
wind.G = this.G;
wind.mac_data = sr.macallowed;
wind.ShowDialog();
}
}
else
{
MessageBox.Show(StringResource.CANNOT_CONNECT_TO_SERVER, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private List <Istab> getIstabDataFromServer(Istab.TABTYP tabtyp)
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "istab/get_all&tabtyp=" + tabtyp.ToTabtypString() + "&sort=typcod");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.istab.Count > 0)
{
return(sr.istab);
}
else
{
return(new List <Istab>());
}
}
else
{
return(new List <Istab>());
}
}
private List <TrainingCalendar> GetTrainingCalendar()
{
DateTime first_day_of_month = new DateTime(this.date_event.Date.Year, this.date_event.Date.Month, 1);
DateTime last_day_of_month = first_day_of_month.AddMonths(1).AddDays(-1);
Console.WriteLine(" >> first_day : " + first_day_of_month.ToString() + ", last_day" + last_day_of_month.ToString());
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "trainingcalendar/get_month_trainer&date_from=" + first_day_of_month.ToMysqlDate() + "&date_to=" + last_day_of_month.ToMysqlDate());
Console.WriteLine(" >>> " + get.data);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
return(sr.training_calendar);
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
return(null);
}
}
private List <Dealer> getDealerDataFromServer()
{
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "dealer/get_list");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.dealer.Count > 0)
{
return(sr.dealer);
}
else
{
return(new List <Dealer>());
}
}
else
{
return(new List <Dealer>());
}
}
private void inquiryRest()
{
if (this.serial_list.Count == 0)
{
string ids = string.Empty;
int current_ndx = this.serial_id_list.FindIndex(t => t.id == this.current_serial.id);
int start_ndx = (current_ndx - 49 < 0 ? 0 : current_ndx - 49);
int stop_ndx = (current_ndx + 50 > this.serial_id_list.Count - 1 ? this.serial_id_list.Count - 1 : current_ndx + 50);
for (int i = start_ndx; i <= stop_ndx; i++)
{
if (i == start_ndx)
{
ids += this.serial_id_list[i].id.ToString();
}
else
{
ids += "," + this.serial_id_list[i].id.ToString();
}
}
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "serial/get_inquiry&sort=" + this.sortMode + "&ids=" + ids);
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
if (sr.serial_list.Count > 0)
{
this.serial_list = sr.serial_list;
this.toolStripLoadedRec.Text = this.serial_list.Count.ToString();
this.toolStripTotalRec.Text = this.serial_id_list.Count.ToString();
}
}
else
{
MessageAlert.Show(sr.message, "Error", MessageAlertButtons.OK, MessageAlertIcons.ERROR);
}
}
}
private void loadMacAddressData(int mac_id = 0)
{
if (this.mac_data == null)
{
CRUDResult res = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "macallowed/get_all");
if (res.result)
{
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(res.data);
if (sr.result == ServerResult.SERVER_RESULT_SUCCESS)
{
this.mac_data = sr.macallowed;
}
}
}
// Clear old data
this.dgvMacAddress.Columns.Clear();
this.dgvMacAddress.Rows.Clear();
// Create data column
DataGridViewTextBoxColumn text_col1 = new DataGridViewTextBoxColumn();
int c1 = this.dgvMacAddress.Columns.Add(text_col1);
this.dgvMacAddress.Columns[c1].HeaderText = "ID.";
this.dgvMacAddress.Columns[c1].Width = 40;
this.dgvMacAddress.Columns[c1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn text_col2 = new DataGridViewTextBoxColumn();
int c2 = this.dgvMacAddress.Columns.Add(text_col2);
this.dgvMacAddress.Columns[c2].HeaderText = "Mac Address";
this.dgvMacAddress.Columns[c2].Width = 150;
this.dgvMacAddress.Columns[c2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn text_col3 = new DataGridViewTextBoxColumn();
int c3 = this.dgvMacAddress.Columns.Add(text_col3);
this.dgvMacAddress.Columns[c3].HeaderText = "เพิ่ม/แก้ไข โดย";
this.dgvMacAddress.Columns[c3].Width = 120;
this.dgvMacAddress.Columns[c3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
DataGridViewTextBoxColumn text_col4 = new DataGridViewTextBoxColumn();
int c4 = this.dgvMacAddress.Columns.Add(text_col4);
this.dgvMacAddress.Columns[c4].HeaderText = "เพิ่ม/แก้ไข ล่าสุด";
this.dgvMacAddress.Columns[c4].Width = 130;
this.dgvMacAddress.Columns[c4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
foreach (MacAllowed mac in this.mac_data)
{
int r = this.dgvMacAddress.Rows.Add();
this.dgvMacAddress.Rows[r].Tag = (int)mac.id;
this.dgvMacAddress.Rows[r].Cells[0].ValueType = typeof(int);
this.dgvMacAddress.Rows[r].Cells[0].Value = mac.id;
this.dgvMacAddress.Rows[r].Cells[0].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgvMacAddress.Rows[r].Cells[1].ValueType = typeof(string);
this.dgvMacAddress.Rows[r].Cells[1].Value = mac.mac_address;
this.dgvMacAddress.Rows[r].Cells[2].ValueType = typeof(string);
this.dgvMacAddress.Rows[r].Cells[2].Value = mac.create_by;
this.dgvMacAddress.Rows[r].Cells[3].ValueType = typeof(string);
this.dgvMacAddress.Rows[r].Cells[3].Value = mac.create_at;
}
// Set selected row
if (mac_id > 0)
{
//this.dgvMacAddress.Rows[mac_id].Selected = true;
foreach (DataGridViewRow row in this.dgvMacAddress.Rows)
{
if ((int)row.Cells[0].Value == mac_id)
{
row.Cells[0].Selected = true;
}
}
}
this.mac_data = null;
}
private void loadUserListData(int id = 0)
{
List <Users> users = new List <Users>();
CRUDResult get = ApiActions.GET(PreferenceForm.API_MAIN_URL() + "users/get_all");
ServerResult sr = JsonConvert.DeserializeObject <ServerResult>(get.data);
switch (sr.result)
{
case ServerResult.SERVER_RESULT_SUCCESS:
this.users = sr.users;
// Clear old data
this.dgvUsers.Columns.Clear();
this.dgvUsers.Rows.Clear();
// Create column
// ID
DataGridViewTextBoxColumn text_col1 = new DataGridViewTextBoxColumn();
int c1 = this.dgvUsers.Columns.Add(text_col1);
this.dgvUsers.Columns[c1].HeaderText = "ID.";
this.dgvUsers.Columns[c1].Width = 40;
this.dgvUsers.Columns[c1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Columns[c1].Visible = false;
// username
DataGridViewTextBoxColumn text_col2 = new DataGridViewTextBoxColumn();
int c2 = this.dgvUsers.Columns.Add(text_col2);
this.dgvUsers.Columns[c2].HeaderText = "รหัสผู้ใช้";
this.dgvUsers.Columns[c2].Width = 110;
this.dgvUsers.Columns[c2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// name
DataGridViewTextBoxColumn text_col2_1 = new DataGridViewTextBoxColumn();
text_col2_1.HeaderText = "ชื่อ";
text_col2_1.Width = 110;
text_col2_1.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Columns.Add(text_col2_1);
// email
DataGridViewTextBoxColumn text_col3 = new DataGridViewTextBoxColumn();
int c3 = this.dgvUsers.Columns.Add(text_col3);
this.dgvUsers.Columns[c3].HeaderText = "อีเมล์";
//this.dgvUsers.Columns[c3].Width = 160;
this.dgvUsers.Columns[c3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Columns[c3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
// level
DataGridViewTextBoxColumn text_col4 = new DataGridViewTextBoxColumn();
int c4 = this.dgvUsers.Columns.Add(text_col4);
this.dgvUsers.Columns[c4].HeaderText = "ระดับผู้ใช้";
this.dgvUsers.Columns[c4].Width = 100;
this.dgvUsers.Columns[c4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// status
DataGridViewTextBoxColumn text_col5 = new DataGridViewTextBoxColumn();
int c5 = this.dgvUsers.Columns.Add(text_col5);
this.dgvUsers.Columns[c5].HeaderText = "สถานะ";
this.dgvUsers.Columns[c5].Width = 50;
this.dgvUsers.Columns[c5].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// allowed_web_login
DataGridViewTextBoxColumn text_col6 = new DataGridViewTextBoxColumn();
int c6 = this.dgvUsers.Columns.Add(text_col6);
this.dgvUsers.Columns[c6].HeaderText = "Web UI";
this.dgvUsers.Columns[c6].Width = 80;
this.dgvUsers.Columns[c6].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// is training_expert
DataGridViewTextBoxColumn text_col7 = new DataGridViewTextBoxColumn();
int c7 = this.dgvUsers.Columns.Add(text_col7);
this.dgvUsers.Columns[c7].HeaderText = "วิทยากร";
this.dgvUsers.Columns[c7].Width = 50;
this.dgvUsers.Columns[c7].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// max_absent
DataGridViewTextBoxColumn text_col8 = new DataGridViewTextBoxColumn();
text_col8.HeaderText = "วันลา";
text_col8.Width = 50;
text_col8.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgvUsers.Columns.Add(text_col8);
// create_at
DataGridViewTextBoxColumn text_col9 = new DataGridViewTextBoxColumn();
int c9 = this.dgvUsers.Columns.Add(text_col9);
this.dgvUsers.Columns[c9].HeaderText = "สร้างเมื่อ";
this.dgvUsers.Columns[c9].Width = 140;
this.dgvUsers.Columns[c9].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// update_at
DataGridViewTextBoxColumn text_col10 = new DataGridViewTextBoxColumn();
int c10 = this.dgvUsers.Columns.Add(text_col10);
this.dgvUsers.Columns[c10].HeaderText = "ใช้งานล่าสุด";
this.dgvUsers.Columns[c10].Width = 140;
this.dgvUsers.Columns[c10].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
// Create data row
foreach (Users user in this.users)
{
int r = this.dgvUsers.Rows.Add();
this.dgvUsers.Rows[r].Tag = (int)user.id;
this.dgvUsers.Rows[r].Cells[0].ValueType = typeof(int);
this.dgvUsers.Rows[r].Cells[0].Value = user.id;
this.dgvUsers.Rows[r].Cells[0].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgvUsers.Rows[r].Cells[1].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[1].Value = user.username;
this.dgvUsers.Rows[r].Cells[2].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[2].Value = user.name;
this.dgvUsers.Rows[r].Cells[3].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[3].Value = user.email;
this.dgvUsers.Rows[r].Cells[4].ValueType = typeof(int);
this.dgvUsers.Rows[r].Cells[4].Value = ComboboxItem.GetItemText(this.cbUserLevel, user.level);
this.dgvUsers.Rows[r].Cells[4].Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
this.dgvUsers.Rows[r].Cells[5].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[5].Value = ComboboxItem.GetItemText(this.cbUserStatus, user.status);
this.dgvUsers.Rows[r].Cells[5].Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Rows[r].Cells[6].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[6].Value = ComboboxItem.GetItemText(this.cbWebLogin, user.allowed_web_login);
this.dgvUsers.Rows[r].Cells[6].Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Rows[r].Cells[7].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[7].Value = user.training_expert;
this.dgvUsers.Rows[r].Cells[7].Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
this.dgvUsers.Rows[r].Cells[7].Style.ForeColor = (user.training_expert == "Y" ? Color.Black : Color.LightGray);
this.dgvUsers.Rows[r].Cells[8].ValueType = typeof(int);
this.dgvUsers.Rows[r].Cells[8].Value = user.max_absent;
this.dgvUsers.Rows[r].Cells[8].Style.Alignment = DataGridViewContentAlignment.MiddleRight;
this.dgvUsers.Rows[r].Cells[9].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[9].Value = user.create_at;
this.dgvUsers.Rows[r].Cells[10].ValueType = typeof(string);
this.dgvUsers.Rows[r].Cells[10].Value = user.last_use;
}
// Set selection item
if (id > 0)
{
foreach (DataGridViewRow row in this.dgvUsers.Rows)
{
if ((int)row.Tag == id)
{
row.Cells[1].Selected = true;
}
}
}
break;
default:
DialogResult dlg_res = MessageAlert.Show(sr.message, "Error", MessageAlertButtons.RETRY_CANCEL, MessageAlertIcons.ERROR);
if (dlg_res == DialogResult.Retry)
{
this.loadUserListData();
}
else
{
this.Close();
}
break;
}
}
