private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex != -1)
{
Cursor = Cursors.WaitCursor;
int id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
String cri = " where t.id=" + id;
List <ModelTransaction> lists = (onlineStatus) ? dao.Select(cri, StationID) : dao.SelectOffine(cri, StationID);
if (lists.Count > 0)
{
tran = lists[0];
FrmDetail frmManualGen = new FrmDetail(this, tran);
frmManualGen.ShowDialog();
}
Cursor = Cursors.Default;
}
}
public void ShowReport()
{
String cri = " where date(create_date) between date('" + DP_START.Value.ToString("yyyy-MM-dd") + "') and date('" + DP_END.Value.ToString("yyyy-MM-dd") + "') and LoungePlace=" + lounge_site.SelectedValue;
//int StationID = Convert.ToInt16(ManageLOG.getValueFromRegistry(Configurations.AppRegName, "StationID"));
List <ModelTransaction> lists = tranDao.Select(cri, Convert.ToInt16(lounge_site.SelectedValue));
if (lists != null)
{
//foreach (ModelTransaction model in lists)
//{
//model.group_idName = findGroupName(model.group_id + "");
//model.LoungeName = findStationName(model.LoungePlace + "");
//model.seat_no = model.seat_no;
//model.create_byName = findUserName(model.create_by + "");
//model.update_byName = findUserName(model.update_by + "");
//}
string path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location);
var rptPath = @"report1.rdlc";
reportViewer1.Visible = true;
reportViewer1.LocalReport.ReportPath = rptPath;
ReportDataSource datasource = new ReportDataSource("DataSet1", lists);
reportViewer1.LocalReport.DataSources.Clear();
reportViewer1.LocalReport.DataSources.Add(datasource);
reportViewer1.DocumentMapCollapsed = true;
reportViewer1.RefreshReport();
}
else
{
MessageBox.Show("ไม่พบข้อมูล");
}
}
private void B_UPLOAD_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
int StationID = Convert.ToInt32(ManageLOG.getValueFromRegistry("WiFi Management", "StationID"));
//----------------Create folder
String folderName = @"C:\BangkokAirways\reports\" + DateTime.Now.ToString("yyyyMMdd") + "\\";
String fileName = folderName + @"\Report_" + StationID + "_" + DateTime.Now.ToString("yyyyMMddHHmm") + ".txt";
DirectoryInfo di = new DirectoryInfo(@"" + folderName);
if (!di.Exists)
{
di.Create();
} //ถ้าไม่พบ Folder ก็ทำการสร้างมันขึ้นมา
//----------------Create File
ManageLOG mangeLog = new ManageLOG();
mangeLog.fileName = fileName;
mangeLog.folderName = folderName;
TransactionDao tranDao = new TransactionDao();
String cri = "where date(create_date) = date('" + DateTime.Now.ToString("yyyy-MM-dd") + "') and LoungePlace=" + StationID + " order by update_date desc";
List <ModelTransaction> lists = tranDao.Select(cri, StationID);
int seq = 1;
String header = "No,Username,Type,GenDate,GroupName,Duration,PassengerName,FromCity,ToCity,AirlineCode,FlightNo,DateOfFlight,SeatNo,LoungePlace,LoungeType,LoungeArea,Owner,Begin_Date,Status,Remark,AccessCode,Remark2,LastUpdate,LastUpdateBy";
mangeLog.WriteLog(header);
foreach (ModelTransaction transaction in lists)
{
mangeLog.WriteLog(
seq + "," +
"-," +
transaction.type + "," +
transaction.create_date_custom + "," +
transaction.group_idName + "," +
transaction.duration + "," +
transaction.passenger_name + "," +
transaction.from_city + "," +
transaction.to_city + "," +
transaction.airline_code + "," +
transaction.flight_no + "," +
transaction.date_of_flight_custom + "," +
transaction.seat_no + "," +
transaction.LoungeSite + "," +
transaction.LoungeName + "," +
transaction.LoungeAreaName + "," +
transaction.create_byName + "," +
transaction.begin_date_custom + "," +
transaction.status + "," +
transaction.remark + "," +
transaction.ath_id + "," +
transaction.remakr2 + "," +
transaction.update_date_custom + "," +
transaction.update_byName
);
seq++;
}
;
//----------------Ftp File
CustomUtils util = new CustomUtils();
util.ftpServerIP = ftpServerIP.Text;
util.ftpUserID = ftpUserID.Text;
util.ftpPassword = ftpPassword.Text;
Boolean result = util.Upload(fileName);
Cursor = Cursors.Default;
if (result)
{
MessageBox.Show("อัพโหลดเรียบร้อยแล้ว");
}
}
public static void Main(string[] args)
{
//Boolean closeFtp = false;
//String xx = Configurations.deCode("U0VSVkVSPTIwMi40Ny4yNTAuMjAzO0RBVEFCQVNFPWF1dGhlbmNvZGVkYjtVSUQ9YzExO1BBU1NXT1JEPVBAc3N3MHJkOw==");
//Console.WriteLine();
//
//String xxx = ManageLOG.deCode("U0VSVkVSPTIwMi40Ny4yNTAuMjAzO0RBVEFCQVNFPWF1dGhlbmNvZGVkYjtVSUQ9Y2F0MDE7UEFTU1dPUkQ9UEBzc3cwcmQ7");
//Console.WriteLine("");
try
{
RadDao radDao = new RadDao();
// radDao.getAthCodeInfo("628821");
//Console.WriteLine();
/*
* 0 = Run all station.
* format : ????.exe {station} {yyyyMMdd}
*/
String _station = args.Length > 0 ? (args[0].Equals("0") ? "" : String.IsNullOrEmpty(args[0]) ? "" : " Where id=" + args[0]) : "";
Sftp sftp = new Sftp("sftp.bangkokair.net", "cat2gos", "C@t2g0s");
Console.WriteLine("sftp.bangkokair.net Connected. " + DateTime.Now);
//if (!closeFtp)
//{
sftp.Connect(22);
//}
DateTime runDate = args.Length > 0 ? (String.IsNullOrEmpty(args[1]) ? DateTime.Now.AddDays(-1) : new DateTime(Convert.ToInt16(args[1].Substring(0, 4)), Convert.ToInt16(args[1].Substring(4, 2)), Convert.ToInt16(args[1].Substring(6, 2)), 0, 0, 0)) : DateTime.Now.AddDays(-1);//Run pevios day
TransactionDao tranDao = new TransactionDao();
StationDao stationDao = new StationDao();
LoungeDao loungeDao = new LoungeDao();
AreaDao areaDao = new AreaDao();
List <ModelStation> stations = stationDao.Select("" + _station);
if (stations.Count > 0)
{
foreach (ModelStation station in stations)
{
if (station.id != 99)
{
List <ModelLounge> lounges = loungeDao.Select(" Where lounge_station=" + station.id);
if (lounges.Count > 0)
{
foreach (ModelLounge lounge in lounges)
{
List <ModelArea> areas = areaDao.Select(" Where area_station=" + station.id + " and area_lounge=" + lounge.id);
if (areas.Count > 0)
{
foreach (ModelArea area in areas)
{
String PATH_LOCAL = String.Format(@"{0}{1}\Gen log\Log {2} {3}", Configurations.DailyTransactionLogsPath, station.site_code, lounge.lounge_name, area.area_name);
String PATH_FTP = String.Format("{0}/Gen log/Log {1} {2}", station.site_code, lounge.lounge_name, area.area_name);
DirectoryInfo di = new DirectoryInfo(@"" + PATH_LOCAL);
//if (!closeFtp)
//{
if (!di.Exists)
{
di.Create();
}
//Create path on server
sftp.Mkdir(PATH_FTP);
//}
//ignore group_id=32 ==> cat test group.
String cri = "where date(create_date) = date('" + runDate.ToString("yyyy-MM-dd") + "') and LoungePlace=" + station.id + " and LoungeType=" + lounge.id + " and LoungeArea=" + area.id + " and group_id <> 32 order by LoungePlace asc,LoungeType asc,LoungeArea asc,update_date desc";
List <ModelTransaction> lists = tranDao.Select(cri, station.id);
ManageLOG mangeLog = new ManageLOG();
if (lists.Count > 0)
{
mangeLog.fileName = String.Format(@"{0}\export_{1}.csv", PATH_LOCAL, runDate.ToString("yyyy-MM-dd"));
mangeLog.folderName = PATH_LOCAL;
String header = "No,Username,Type,GenDate,GroupName,Duration,PassengerName,FromCity,ToCity,AirlineCode,FlightNo,DateOfFlight,SeatNo,LoungePlace,LoungeType,LoungeArea,Owner,Begin_Date,Status,Remark,AccessCode,Remark2,LastUpdate,LastUpdateBy";
mangeLog.WriteLog(header);
int seq = 1;
foreach (ModelTransaction transaction in lists)
{
String athCodeBeginUse = transaction.begin_date.ToString("yyyy-MM-dd HH:mm:ss");
try
{
athCodeBeginUse = radDao.getAthCodeInfo(transaction.ath_id);
}
catch (Exception ex)
{
logger.Debug("* Skip get begindate of " + station.site_code + ">>" + lounge.lounge_name + ">>" + area.area_name + " ::ID::" + transaction.id);
logger.Error("* " + ex.InnerException.Message);
}
mangeLog.WriteLog(
seq + "," + //No
Utils.CustomUtils.RemoveSpecialCharacters(transaction.passenger_name + "" + transaction.flight_no + "" + transaction.seat_no) + "," +
transaction.type + "," + //Type
transaction.create_date.ToString("yyyy-MM-dd HH:mm:ss") + "," +
transaction.group_idName + "," + //GroupName
transaction.duration + "," + //Duration
Utils.CustomUtils.RemoveSpecialCharacters(transaction.passenger_name) + "," + //PassengerName
Utils.CustomUtils.RemoveSpecialCharacters(transaction.from_city) + "," + //FromCity
Utils.CustomUtils.RemoveSpecialCharacters(transaction.to_city) + "," + //ToCity
Utils.CustomUtils.RemoveSpecialCharacters(transaction.airline_code) + "," + //AirlineCode
Utils.CustomUtils.RemoveSpecialCharacters(transaction.flight_no) + "," + //FlightNo
transaction.date_of_flight.ToString("yyyy-MM-dd HH:mm:ss") + "," +
Utils.CustomUtils.RemoveSpecialCharacters(transaction.seat_no) + "," + //SeatNo
transaction.LoungeSiteCode + "," + //LoungePlace
transaction.LoungeName + "," + //LoungeType
transaction.LoungeAreaName + "," + //LoungeArea
transaction.create_byName + "," + //Owner
athCodeBeginUse + "," +
transaction.status + "," + //Status
Utils.CustomUtils.RemoveSpecialCharacters(transaction.remark) + "," + //Remark
transaction.ath_id + "," + //AccessCode
Utils.CustomUtils.RemoveSpecialCharacters(transaction.remakr2) + "," + //Remark2
transaction.update_date.ToString("yyyy-MM-dd HH:mm:ss") + "," +
transaction.update_byName //LastUpdateBy
);
//Update begindate
tranDao.UpdateBeginDate(transaction, station.id);
seq++;
}
}
else
{
mangeLog.fileName = String.Format(@"{0}\export_{1} No data.csv", PATH_LOCAL, runDate.ToString("yyyy-MM-dd"));
mangeLog.folderName = PATH_LOCAL;
mangeLog.WriteLog("");
logger.Debug("Transaction of " + station.site_code + ">>" + lounge.lounge_name + ">>" + area.area_name + " is empty");
}
/*
* TRANSFER FILE TO SERVER.
*/
//if (!closeFtp)
//{
sftp.Put(mangeLog.fileName, PATH_FTP);
//}
}
}
else
{
logger.Debug("Area of " + station.site_code + ">>" + lounge.lounge_name + " is empty.");
}
}
}
else
{
logger.Debug("Lounge of " + station.site_code + " is empty.");
}
}
}
}
else
{
logger.Debug("Station is empty.");
}
/*
* CLOSE FTP
*/
sftp.Close();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
