public static void downloadArea()
{
String StationID = ManageLOG.getValueFromRegistry(Configurations.AppRegName, "StationID");
int total = 0;
int success = 0;
AreaDao dao = new AreaDao();
List <ModelArea> lists = dao.Select(" Where area_station=" + StationID);
if (lists != null)
{
total = lists.Count;
logger.Debug("# Start download [AREA] from server.");
foreach (ModelArea model in lists)
{
List <ModelArea> tmp = dao.SelectOffine(" Where id='" + model.id + "'");
if (tmp != null)
{
if (tmp.Count > 0)
{
}
else
{
if (dao.InsertOffline(model))
{
success++;
}
}
}
}
logger.Debug("# Summary=> Total Download total: " + total + " success: " + success + " fail: " + (total - success));
logger.Debug("# End Download data from server.");
}
}
private void FrmLogin_Load(object sender, EventArgs e)
{
StationID = ManageLOG.getValueFromRegistry(Configurations.AppRegName, "StationID");
String[] userInfo = ManageLOG.getValueFromRegistry(Configurations.AppRegName, "userInfo").Split(',');
//14,1,26,สนามบินสุวรรณภูมิ Inter,Lounge Inter,Area 1,1,Admin,admin1,admin1
if (userInfo.Length >= 1)
{
staffId = Convert.ToInt32(userInfo[0]);
}
if (userInfo.Length >= 2)
{
loungeId = Convert.ToInt32(userInfo[1]);
}
if (userInfo.Length >= 3)
{
areaId = Convert.ToInt32(userInfo[2]);
}
if (userInfo.Length >= 4)
{
stationName = userInfo[3];
station.Text = stationName;
}
if (userInfo.Length >= 7)
{
roleId = Convert.ToInt32(userInfo[6]);
}
if (userInfo.Length >= 8)
{
roleName = userInfo[7];
}
if (userInfo.Length >= 9)
{
username = userInfo[8];
}
if (userInfo.Length >= 10)
{
password = userInfo[9];
}
siteDao = new StationDao();
loungeDao = new LoungeDao();
areaDao = new AreaDao();
roleDao = new RoleDao();
//Check server is alive
status = Connection.IsServerConnected();
//station.DataSource = (status) ? siteDao.Select(" Where id=" + StationID) : siteDao.SelectOffine(" Where id=" + StationID);
List <ModelLounge> lounges = (status) ? loungeDao.Select(" where l.lounge_station=" + StationID) : loungeDao.SelectOffline(" where l.lounge_station=" + StationID);
lounge.DataSource = lounges;
try
{
bool bIsLoungeChild = false;
foreach (ModelLounge l in lounges)
{
if (l.id == loungeId)
{
bIsLoungeChild = true;
break;
}
}
if (bIsLoungeChild)
{
if (loungeId > 0)
{
lounge.SelectedValue = loungeId;
}
else
{
lounge.SelectedIndex = 0;
}
}
else
{
lounge.SelectedIndex = 0;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
//lounge.SelectedIndex = 0;
}
List <ModelArea> areas = (status) ? areaDao.Select(" where a.area_station=" + StationID + " and a.area_lounge=" + lounge.SelectedValue) : areaDao.SelectOffine(" where a.area_station=" + StationID + " and a.area_lounge=" + lounge.SelectedValue);
area.DataSource = areas;
try
{
bool bIsAreaChild = false;
foreach (ModelArea a in areas)
{
if (a.id == areaId)
{
bIsAreaChild = true;
break;
}
}
if (bIsAreaChild)
{
if (areaId > 0)
{
area.SelectedValue = areaId;
}
else
{
area.SelectedIndex = 0;
}
}
else
{
area.SelectedIndex = 0;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
//area.SelectedIndex = 0;
}
LAPPTITLE.Text = Application.ProductName;
LAPPCOMPANY.Text = Application.CompanyName;
LUPDATE_DATE.Text = "Version " + Application.ProductVersion;
UsernameTextBox.Focus();
if (!status)
{
UsernameTextBox.Text = username;
PasswordTextBox.Text = password;
}
lSupport.Text = String.Format(lSupport.Text, ManageLOG.getValueFromRegistry(Configurations.AppRegName, "SupportCATInternet"), "");
}
private void staff_lounge_SelectedIndexChanged(object sender, EventArgs e)
{
List <ModelArea> areaLists = (status) ? areaDao.Select(" where a.area_station=" + StationID + " and a.area_lounge=" + lounge.SelectedValue) : areaDao.SelectOffine(" where a.area_station=" + StationID + " and a.area_lounge=" + lounge.SelectedValue);
if (areaLists != null && areaLists.Count > 0)
{
area.DataSource = areaLists;
}
else
{
MessageBox.Show("ไม่พบ Area ใน " + lounge.Text);
lounge.SelectedIndex = 0;
UsernameTextBox.Focus();
}
}
private void comboLounge_SelectedIndexChanged(object sender, EventArgs e)
{
if (Convert.ToInt16(comboLounge.SelectedValue) > 0)
{
List <ModelArea> listArea = (onlineStatus) ? areaDao.Select("where a.area_station=" + lounge_site.SelectedValue + " and a.area_lounge=" + comboLounge.SelectedValue) : areaDao.SelectOffine("where a.area_station=" + lounge_site.SelectedValue + " and a.area_lounge=" + comboLounge.SelectedValue);
comboArea.DataSource = listArea;
}
else
{
comboArea.Text = "";
}
}