public void InitializeDGVDesign(BunifuDataGridView bdgv, TabPage tp)
{
tp.Controls.Add(bdgv);
bdgv.Theme = BunifuDataGridView.PresetThemes.DarkViolet;
bdgv.Dock = DockStyle.Fill;
bdgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
public void insertSoldMedicines(BunifuDataGridView dataGridView, string paymentType)
{
DateTime now = DateTime.Now;
baglanti.Open();
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
try
{
string ilacId = dataGridView.Rows[i].Cells["İlaç ID"].Value.ToString();
string recipeId = dataGridView.Rows[i].Cells["Reçete ID"].Value.ToString();
string query = "Insert Into SatilanIlaclar(IlacId,SatisTarihi,SatisSekli,ReceteId,SatanPersonelId) Values ('" + ilacId + "','" + now.ToString("dd/MM/yyyy") + "','" + paymentType + "','" + recipeId + "','1')";
komut.Connection = baglanti;
komut.CommandText = query;
komut.ExecuteNonQuery();
komut.Dispose();
}
catch (Exception e)
{
//Console.WriteLine(e);
}
}
baglanti.Close();
}
public void insertSoldProducts(BunifuDataGridView dataGridView, string paymentType)
{
DateTime now = DateTime.Now;
baglanti.Open();
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
try
{
string productID = dataGridView.Rows[i].Cells["Ürün ID"].Value.ToString();
string productBarkod = dataGridView.Rows[i].Cells["Barkod"].Value.ToString();
string productName = dataGridView.Rows[i].Cells["Ürün Adı"].Value.ToString();
string query = "Insert Into SatilanYanUrunler(Id,UrunAdi,BarkotNo,SatisTarihi,SatisSekli,SatanPersonelId) " +
"Values ('" + productID + "','" + productName + "','" + productBarkod + "','" + now.ToString("dd/MM/yyyy") + "','" + paymentType + "','1')";
komut.Connection = baglanti;
komut.CommandText = query;
komut.ExecuteNonQuery();
komut.Dispose();
}
catch (Exception e)
{
//Console.WriteLine(e);
}
}
baglanti.Close();
}
public SequenceForm(string _usecase)
{
InitializeComponent();
this.Text += " " + _usecase;
useCase = _usecase;
cyberRawDgv = new BunifuDataGridView();
InitializeDGVDesign(cyberRawDgv, fromPcap);
pySharkDgv = new BunifuDataGridView();
InitializeDGVDesign(pySharkDgv, fromPyShark);
packetBeatDgv = new BunifuDataGridView();
InitializeDGVDesign(packetBeatDgv, fromPacketBeat);
snortDgv = new BunifuDataGridView();
InitializeDGVDesign(snortDgv, fromSnort);
phyRawDgv = new BunifuDataGridView();
InitializeDGVDesign(phyRawDgv, phyFromPcap);
mergeDgv = new BunifuDataGridView();
InitializeDGVDesign(mergeDgv, mergeCyPhy);
imputationDgv = new BunifuDataGridView();
InitializeDGVDesign(imputationDgv, imputate);
encodingDgv = new BunifuDataGridView();
InitializeDGVDesign(encodingDgv, encoding);
columnNames = new List <string> {
"TimeStamp", "Frame Len", "Frame Type", "Source MAC", "Dest MAC", "Src IP", "Dest IP", "IP Length", "IP Flag", "Src Port", "Dest Port", "TCP Length", "TCP Flag", "Next Seq", "Ack Number"
};
ProcessTab.SelectedTab = fromPcap;
populateDGVs(ref cyberRawDgv, this.useCase, "1", columnNames);
}
public static void suspendEmployee(DateTime terminationDate)
{
employeDataGridView = My.MyProject.Forms.FrmEmployeeManagement.BunifuDataGridView1;
int selectedRow = employeDataGridView.CurrentRow.Index;
employeeID = Conversions.ToInteger(employeDataGridView.Rows[selectedRow].Cells[6].Value);
db.TerminateEmployee(employeeID, terminationDate);
MdlEmpManagement.populateEmployeeList(My.MyProject.Forms.FrmEmployeeManagement.BunifuDataGridView1, My.MyProject.Forms.FrmEmployeeManagement.employeeStatus);
}
private void FrmClearance_Load(object sender, EventArgs e)
{
employeDataGridView = My.MyProject.Forms.FrmEmployeeManagement.BunifuDataGridView1;
int selectedRow = employeDataGridView.CurrentCell.RowIndex;
string firstName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[1].Value);
string lastName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[2].Value);
Label1.Text = "Check all functionalities you wish to grant to " + firstName + " " + lastName;
}
public static void populateEmployeeList(BunifuDataGridView gridView, string status)
{
gridView.Rows.Clear();
foreach (DataRow employee in db.getTableInfo("Employees", "Alias, First_Name ,LAst_Name , Yard, Phone_Number , Status, ID", status + " order by alias").Rows)
{
gridView.Rows.Add(employee["Alias"], employee["First_Name"], employee["Last_Name"], employee["Yard"], employee["Phone_Number"], employee["Status"], employee["ID"]);
}
// sqlCon.Close()
// End Using
}
public double suma_monto_datagrid(BunifuDataGridView datagrid)
{
double monto = 0;
for (int i = 0; i < datagrid.RowCount; i++)
{
if (datagrid.Rows [i].Cells [0].Value != null)
{
monto += double.Parse(datagrid.Rows [i].Cells [0].Value.ToString());
}
}
return(monto);
}
private DataGridViewRow getSelectedRow(BunifuDataGridView dataGrid)
{
for (int i = 0, loopTo = dataGrid.Rows.Count - 1; i <= loopTo; i++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dataGrid.Rows[i].Cells[1].Value, true, false)))
{
return(dataGrid.Rows[i]);
break;
}
}
return(default);
private void FrmSuspention_Load(object sender, EventArgs e)
{
employeDataGridView = My.MyProject.Forms.FrmEmployeeManagement.BunifuDataGridView1;
fromDateTimePicker1.Value = DateAndTime.Now;
reinstateDateTimePicker3.Value = DateAndTime.Now;
terminationDateTimePicker.Value = DateAndTime.Now;
selectedRow = employeDataGridView.CurrentRow.Index;
string firstName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[1].Value);
string lastName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[2].Value);
suspendLabel.Text = "Suspend employee: " + firstName + " " + lastName;
terminateLabel.Text = "Terminate employee: " + firstName + " " + lastName;
reinstateLabel.Text = "Reinstate employee: " + firstName + " " + lastName;
}
public BunifuDataGridView getAllOtherProducts(BunifuDataGridView dataGridView)
{
baglanti.Open();
string query = "SELECT YanUrunler.Id as [Ürün ID], YanUrunler.Barkod, YanUrunler.UrunAdi as [Ürün Adı], Tedarikci.FirmaAdi as [Ruhsat Sahibi]," +
"YanUrunler.Fiyat FROM YanUrunler INNER JOIN Tedarikci ON YanUrunler.RuhsatSahibiId = Tedarikci.Id";
OleDbDataAdapter adtr = new OleDbDataAdapter(query, baglanti);
ds.Clear();
adtr.Fill(ds, "YanUrunler");
dataGridView.DataSource = ds.Tables["YanUrunler"];
adtr.Dispose();
baglanti.Close();
return(dataGridView);
}
public BunifuDataGridView getAllMedicines(BunifuDataGridView dataGridView)
{
baglanti.Open();
string query = "SELECT Ilaclar.Id as [İlaç ID], Ilaclar.Barkod, Ilaclar.UrunAdi as [Ürün Adı]," +
" Ilaclar.EtkinMadde as [Etkin Madde], Ilaclar.ReceteTuru as [Reçete Türü], " +
"Ilaclar.KullanimYasi as [Kullanım Yaşı], Ilaclar.Fiyat FROM Ilaclar";
OleDbDataAdapter adtr = new OleDbDataAdapter(query, baglanti);
ds.Clear();
adtr.Fill(ds, "Ilaclar");
dataGridView.DataSource = ds.Tables["Ilaclar"];
adtr.Dispose();
baglanti.Close();
return(dataGridView);
}
public MainForm()
{
InitializeComponent();
bdgvCyber = new BunifuDataGridView();
InitializeDGVDesign(bdgvCyber, cyberTabPage);
bdgvPhysical = new BunifuDataGridView();
InitializeDGVDesign(bdgvPhysical, physicalTabPage);
bdgvCyberPhysical = new BunifuDataGridView();
InitializeDGVDesign(bdgvCyberPhysical, cpTabPage);
bdgvTrained = new BunifuDataGridView();
InitializeDGVDesign(bdgvTrained, trainedTabPage);
bdgvPscores = new BunifuDataGridView();
InitializeDGVDesign(bdgvPscores, probTabPage);
bdgvCoTrained = new BunifuDataGridView();
InitializeDGVDesign(bdgvCoTrained, coTrainTabPage);
}
public BunifuDataGridView getAllPatients(BunifuDataGridView dataGridView)
{
baglanti.Open();
string query = "SELECT Hasta.Ad, Hasta.Soyad, Hasta.HastaTc as TC, Hasta.SigortaTuru as Sigorta, Hasta.DogumTarihi as [Doğum Tarihi], " +
"Ilceler.Ilce as İlçe, Sehirler.İl as İl FROM (Ilceler INNER JOIN Hasta ON Ilceler.IlceId = Hasta.IlceId) INNER JOIN Sehirler ON " +
"Ilceler.İl = Sehirler.[Plaka Kodu]";
OleDbDataAdapter adtr = new OleDbDataAdapter(query, baglanti);
ds.Clear();
adtr.Fill(ds, "Hasta");
dataGridView.DataSource = ds.Tables["Hasta"];
adtr.Dispose();
baglanti.Close();
return(dataGridView);
}
private void bookingsBunifuDataGridView1_SelectionChanged(object sender, EventArgs e)
{
BunifuDataGridView s = (BunifuDataGridView)sender;
if (firstLoad == false)
{
contList = "";
foreach (var cont in selectedContainers)
{
contList += cont.Key + ", ";
}
contList = contList.Substring(0, contList.Length - 2);
int selectedRow = Conversions.ToInteger(s.CurrentRow.Index);
selectedBookingNumber = Conversions.ToString(bookingsBunifuDataGridView1.Rows[selectedRow].Cells[0].Value);
selectedMinibookingId = Conversions.ToInteger(bookingsBunifuDataGridView1.Rows[selectedRow].Cells[3].Value);
infoLabel.Text = "Booking #: " + selectedBookingNumber + Microsoft.VisualBasic.Constants.vbNewLine + "will receive containers:" + Microsoft.VisualBasic.Constants.vbNewLine + contList;
}
}
public Dictionary <int, string> getSelectedContIDs(BunifuDataGridView dataDrid)
{
var selectedIDs = new Dictionary <int, string>();
for (int i = 0, loopTo = dataDrid.Rows.Count - 1; i <= loopTo; i++)
{
if (Conversions.ToBoolean(Operators.ConditionalCompareObjectEqual(dataDrid.Rows[i].Cells[1].Value, true, false)))
{
int rowID;
string ssline;
rowID = Conversions.ToInteger(dataDrid.Rows[i].Cells[0].Value);
ssline = Conversions.ToString(dataDrid.Rows[i].Cells[7].Value);
selectedIDs.Add(rowID, ssline);
}
}
return(selectedIDs);
}
public BunifuDataGridView getRecipeMedicines(BunifuDataGridView dataGridView, string receteIdOrHastaTc)
{
baglanti.Open();
string query = "SELECT IlacRecete.ReceteId as [Reçete ID], IlacRecete.IlacId as [İlaç ID], Ilaclar.Barkod, Ilaclar.UrunAdi as [Ürün Adı], " +
"Ilaclar.EtkinMadde as [Etkin Madde], Ilaclar.Fiyat FROM Ilaclar " +
"INNER JOIN (Recete INNER JOIN IlacRecete ON Recete.ReceteId = IlacRecete.ReceteId) " +
"ON Ilaclar.Id = IlacRecete.IlacId WHERE (((IlacRecete.ReceteId)=" + receteIdOrHastaTc + ") OR ((Recete.HastaTcKimlikNo)='" + receteIdOrHastaTc + "'))";
OleDbDataAdapter adtr = new OleDbDataAdapter(query, baglanti);
ds.Clear();
adtr.Fill(ds, "Ilaclar");
dataGridView.DataSource = null;
dataGridView.DataSource = ds.Tables["Ilaclar"];
adtr.Dispose();
baglanti.Close();
return(dataGridView);
}
public void insertRecipeToDatabase(int doctorId, string hastaTc, BunifuDataGridView dataGridView, Bunifu.UI.WinForms.BunifuLabel recipeNoLabel)
{
DateTime now = DateTime.Now;
string query = "Insert Into Recete(YazanDoktorId,Tarih,HastaTCKimlikNo) Values ('1','" + now.ToString("dd/MM/yyyy") + "','" + hastaTc + "')";
komut.Connection = baglanti;
komut.CommandText = query;
baglanti.Open();
komut.ExecuteNonQuery();
komut.Dispose();
string query1 = "SELECT Recete.ReceteId FROM Recete GROUP BY Recete.ReceteId ORDER BY Recete.ReceteId DESC";
OleDbDataAdapter adtr = new OleDbDataAdapter(query1, baglanti);
ds.Clear();
adtr.Fill(ds, "Hasta");
int recipeId = Convert.ToInt32(ds.Tables["Hasta"].Rows[0]["ReceteId"]);
recipeNoLabel.Text = "Reçete No: " + recipeId;
Console.WriteLine(recipeId);
adtr.Dispose();
for (int i = 0; i < dataGridView.Rows.Count; i++)
{
try
{
string query2 = "Insert Into IlacRecete(ReceteId,IlacId) Values ('" + recipeId + "','" + dataGridView.Rows[i].Cells["İlaç ID"].Value.ToString() + "')";
komut.Connection = baglanti;
komut.CommandText = query2;
komut.ExecuteNonQuery();
komut.Dispose();
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
baglanti.Close();
}
public static void MergeEqualCells(DataGridViewCellPaintingEventArgs e, BunifuDataGridView dataGridView)
{
var fontStyle = new Font("Microsoft Sans Serif", 9f);
// Units with the same value
// If e.RowIndex <> -1 Then
// Using gridBrush As Brush = New SolidBrush(dataGridView.GridColor), backColorBrush As Brush = New SolidBrush(e.CellStyle.BackColor)
// Using gridLinePen As Pen = New Pen(gridBrush)
// ' Clear cell
// e.Graphics.FillRectangle(backColorBrush, e.CellBounds)
// ' Draw line (bottom border and right border of current cell)
// 'If next row cell has different content, only draw bottom border line of current cell
// If (e.RowIndex < dataGridView.Rows.Count - 2 AndAlso dataGridView.Rows(e.RowIndex + 1).Cells(e.ColumnIndex).Value.ToString() <> e.Value.ToString()) Or
// dataGridView.Rows.Count = e.RowIndex + 1 Then
// e.Graphics.DrawLine(gridLinePen, e.CellBounds.Left, e.CellBounds.Bottom - 1, e.CellBounds.Right - 1, e.CellBounds.Bottom - 1)
// End If
// ' Draw right border line of current cell
// e.Graphics.DrawLine(gridLinePen, e.CellBounds.Right - 1, e.CellBounds.Top, e.CellBounds.Right - 1, e.CellBounds.Bottom)
// ' draw/fill content in current cell, and fill only one cell of multiple same cells
// If Not e.Value Is Nothing Then
// If e.RowIndex > 0 AndAlso dataGridView.Rows(e.RowIndex - 1).Cells(e.ColumnIndex).Value.ToString() = e.Value.ToString() Then
// Else
// e.Graphics.DrawString(CType(e.Value, String), fontStyle, Brushes.Black, e.CellBounds.X + 2, e.CellBounds.Y + 5, StringFormat.GenericDefault)
// End If
// End If
// e.Handled = True
// End Using
// End Using
// End If
}
private void populateDGVs(ref BunifuDataGridView currentDGV, string usecase, string stage, List <string> columnNames)
{
currentDGV.Rows.Clear();
currentDGV.Columns.Clear();
// 1) Create Process Info
var psi = new ProcessStartInfo();
psi.FileName = @"C:\Users\substationc\AppData\Local\Programs\Python\Python37-32\python.exe";
// 2) Provide script and arguments
var script = @"C:\Users\substationc\Desktop\DataFusion\DataFusionApp\DataFusionApp\PythonScripts\GetStepData.py";
//var usecase = this.useCase;
//var stage = "8";
psi.Arguments = $"\"{script}\" \"{usecase}\" \"{stage}\"";
// 3) Process configuration
psi.UseShellExecute = false;
psi.CreateNoWindow = true;
psi.RedirectStandardOutput = true;
psi.RedirectStandardError = true;
// 4) Execute process and get output
var errors = "";
var results = "";
if (!File.Exists("C:\\Users\\substationc\\Desktop\\DataFusion\\DataFusionApp\\DataFusionApp\\bin\\Debug\\msgpack_" + usecase + "_" + stage + ".mp"))
{
using (var process = Process.Start(psi))
{
errors = process.StandardError.ReadToEnd();
results = process.StandardOutput.ReadToEnd();
}
}
var serializer = SerializationContext.Default.GetSerializer <MessagePackObject[][]>();
var unpackedObject = serializer.Unpack(File.OpenRead("C:\\Users\\substationc\\Desktop\\DataFusion\\DataFusionApp\\DataFusionApp\\bin\\Debug\\msgpack_" + usecase + "_" + stage + ".mp"));
int ctr = 0;
foreach (var features in unpackedObject)
{
var index = Array.IndexOf(unpackedObject, features);
if (ctr == 0)
{
for (int i = 0; i < columnNames.Count; i++)
{
currentDGV.Columns.Add(columnNames[i], columnNames[i]);
}
for (int j = columnNames.Count; j < features.Length; j++)
{
currentDGV.Columns.Add("Meas " + (j + 1 - columnNames.Count).ToString(), "Meas " + (j + 1 - columnNames.Count).ToString());
}
}
ctr += 1;
currentDGV.Rows.Add();
foreach (var feature in features)
{
var feature_index = Array.IndexOf(features, feature);
if (feature_index < 0)
{
continue;
}
currentDGV.Rows[index].Cells[feature_index].Value = feature;
}
}
}
public void getEDIs(BunifuDataGridView ediDataGrid)
{
string condition = "";
string table;
string EDIMode;
decimal GrossWeight = 0m;
string inputSource;
string TruckDriverName = "";
string gateDate;
string gateTime;
string TruckNumber = "";
string contSize = "";
decimal tareWeight;
DateTime ediModDateTime;
DateTime datimeTineInsideFile;
string datimeTineInsideFileStr;
DateTime gateTimeDate;
var ediorgTimeDate = default(DateTime);
DateTime dTRequestSent;
var dTRequestSentStr = default(string);
string ssLineCode;
string bkgnRelNumb;
DateTime tempDateTime, tempTime;
string confHandshakeEdi = "";
string location;
string carrierCode;
string dateAndTimeRequested;
// Set different queries for in-gate EDI and out-gate EDI
if (tabinoutGate.SelectedIndex == 0)
{
EDIMode = "IN-GATE";
InGateDataGridView.Rows.Clear();
condition = "on [In-Out Unique ID] = [Unique ID] ";
table = "(select * from [Containers In-Out] where convert(date,[Gate Date In]) >='" + fromInBunifuDatePicker.Value.ToShortDateString() + @"' AND
convert(date,[Gate Date In]) <= '" + toInBunifuDatePicker.Value.ToShortDateString() + "' and [Trouble In-Gate] = 0 and [In Gate EDI] = 1 and (" + getEDIssLines() + @")) as c lEFT join
(select * from ((select * from[EDI Records] where [Gate Mode] <> 'OUT-GATE') as d LEFT join
(select * from [ManualEDILog] ) as m on d.EDIRecID = m.EDIRecordID))as r " ;
}
else
{
EDIMode = "OUT-GATE";
OutGateDataGridView.Rows.Clear();
string showOutCans = "";
if (cbShowOutGatedCans.Checked == true)
{
showOutCans = "and [Gate Date Out] is not null";
}
VW_CompanyCompanyType c = (VW_CompanyCompanyType)cboSSLine.SelectedItem;
VW_BookingMinibooking b = (VW_BookingMinibooking)bookingComboBox.SelectedItem;
var conditionFilter = Operators.AddObject(Operators.AddObject(Operators.AddObject("and ([SS Line Code Out] like '%" + Strings.Trim(Conversions.ToString(c.CompanyCode)) + "%' or [SS Line Code In] like '%" + Strings.Trim(Conversions.ToString(c.CompanyCode)) + "%') and " + " [Booking Number] is not null and [Booking Number] like '%", b.BookingNumber), "%' "), showOutCans);
table = Conversions.ToString(Operators.AddObject(Operators.AddObject("(select * from [Containers In-Out] where (" + getEDIssLines() + ") ", conditionFilter), @") as c lEFT join
(select * from ((select * from[EDI Records] where [Gate Mode] <> 'IN-GATE') as d LEFT join
(select * from [ManualEDILog] ) as m on d.EDIRecID = m.EDIRecordID))as r " ));
// toOutBunifuDatePicker.Value.Date + "' and [Trouble In-Gate] = 0 and [In Gate EDI] = 1
condition = "on [Unique ID] = [In-Out Unique ID]";
}
if (isRefresh)
{
InOutEDIRecDT = dbCeres.getTableInfo(table, "*", condition);
searchTable = InOutEDIRecDT;
}
foreach (DataRow row in searchTable.Rows)
{
if (tabinoutGate.SelectedIndex == 0)
{
if (row["Yard Code In"] != DBNull.Value)
{
location = Strings.Trim(Conversions.ToString(row["Yard Code In"]));
}
else
{
location = "N/A";
}
if (row["Carrier Truck In"] == DBNull.Value)
{
TruckNumber = "";
}
else
{
TruckNumber = Strings.Trim(Conversions.ToString(row["Carrier Truck In"]));
}
if (row["Carrier DriverName In"] == DBNull.Value)
{
TruckDriverName = Strings.Trim("N/A");
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName In"]));
}
bkgnRelNumb = Strings.Trim(Conversions.ToString(row["Release Number"]));
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code In"]));
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code In"]));
if (row["ConfHandShakeDateTime"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["EDIModDateTime"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["EDIModDateTime"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
// ediorgTimeDate = row["EDIOriginalDateTime")
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else if (row["In Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFile = Conversions.ToDate(row["Gate Date In"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
}
else
{
datimeTineInsideFileStr = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSent = Conversions.ToDate("N/A");
}
}
else
{
datimeTineInsideFileStr = "N/A";
if (row["In Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["Gate Date In"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFileStr = confHandshakeEdi;
}
else
{
confHandshakeEdi = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSentStr = "N/A";
}
}
gateTimeDate = Conversions.ToDate(row["Gate Date In"]);
gateDate = gateTimeDate.ToString("dd-MMM-yyyy");
gateTime = gateTimeDate.ToString("HH:mm");
}
else
{
if (row["Booking Number"] != DBNull.Value)
{
bkgnRelNumb = Strings.Trim(Conversions.ToString(row["Booking Number"]));
}
else
{
bkgnRelNumb = "N/A";
}
if (row["SS Line Code Out"] == DBNull.Value)
{
ssLineCode = "";
}
else
{
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code Out"]));
}
if (row["Carrier Code Out"] != DBNull.Value)
{
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code Out"]));
}
else
{
carrierCode = "";
}
if (row["Yard Code Out"] != DBNull.Value)
{
location = Strings.Trim(Conversions.ToString(row["Yard Code Out"]));
}
else
{
location = "N/A";
}
if (row["Carrier Truck Out"] == DBNull.Value)
{
TruckNumber = "N/A";
}
else
{
TruckNumber = Strings.Trim(Conversions.ToString(row["Carrier Truck Out"]));
}
if (row["Carrier DriverName Out"] == DBNull.Value)
{
TruckDriverName = "N/A";
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName Out"]));
}
if (row["ConfHandShakeDateTime"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["EDIModDateTime"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["EDIModDateTime"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
// ediorgTimeDate = row["EDIOriginalDateTime")
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else if (row["Out Gate EDI Date Time"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["ConfHandShakeDateTime"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
if (row["Gate Date Out"] != DBNull.Value)
{
datimeTineInsideFile = Conversions.ToDate(row["Gate Date Out"]);
datimeTineInsideFileStr = datimeTineInsideFile.ToString("dd-MMM-yyyy HH:mm");
}
else
{
datimeTineInsideFileStr = "N/A";
}
}
else
{
datimeTineInsideFileStr = "N/A";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSent = Conversions.ToDate("N/A");
}
}
else
{
datimeTineInsideFileStr = "N/A";
if (row["Out Gate EDI Date Time"] != DBNull.Value && row["Gate Date Out"] != DBNull.Value)
{
ediorgTimeDate = Conversions.ToDate(row["Gate Date Out"]);
confHandshakeEdi = ediorgTimeDate.ToString("dd-MMM-yyyy HH:mm");
datimeTineInsideFileStr = confHandshakeEdi;
}
else
{
confHandshakeEdi = "N/A";
}
}
if (row["Gate Date Out"] != DBNull.Value)
{
gateTimeDate = Conversions.ToDate(row["Gate Date Out"]);
gateDate = gateTimeDate.ToString("dd-MMM-yyyy");
gateTime = gateTimeDate.ToString("HH:mm");
}
else
{
gateDate = "";
gateTime = "";
}
if (row["Date and Time"] != DBNull.Value)
{
dTRequestSent = Conversions.ToDate(row["Date and Time"]);
dTRequestSentStr = dTRequestSent.ToString("dd-MMM-yyyy HH:mm");
}
else
{
dTRequestSentStr = "N/A";
}
}
try
{
contSize = Conversions.ToString(row["ContainerSize"]);
}
catch
{
contSize = "";
}
if (row["Input Source"].Equals("SYSTEM"))
{
inputSource = "SYSTEM";
}
else if (tabinoutGate.SelectedIndex == 1)
{
if (row["Input Source"] == DBNull.Value)
{
if (row["Out Gate EDI Date Time"] == DBNull.Value)
{
inputSource = "";
}
else
{
inputSource = "SYSTEM";
}
}
else
{
inputSource = Conversions.ToString(Operators.AddObject(Operators.AddObject(Operators.AddObject(Operators.AddObject("PRE-SEND " + Constants.vbNewLine + "By: ", row["User Name"]), Constants.vbNewLine), "Date/Time: "), ediorgTimeDate.ToString("dd-MMM-yyyy hh:mm tt")));
}
}
else if (row["Input Source"] == DBNull.Value)
{
if (row["In Gate EDI Date Time"] == DBNull.Value)
{
inputSource = "";
}
else
{
inputSource = "SYSTEM";
}
}
else
{
inputSource = Conversions.ToString(Operators.AddObject(Operators.AddObject(Operators.AddObject(Operators.AddObject("RESEND " + Constants.vbNewLine + "By: ", row["User Name"]), Constants.vbNewLine), "Date/Time: "), ediorgTimeDate.ToString("dd-MMM-yyyy hh:mm tt")));
}
if (row["TARE Weight"] != DBNull.Value)
{
tareWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["TARE Weight"]));
}
else
{
tareWeight = 0m;
}
// GrossWeight = DoFunctions.CVS(row["Gross Weight"])
if (row["Gross Weight"] != DBNull.Value)
{
GrossWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["Gross Weight"]));
}
else
{
GrossWeight = 0m;
}
ediDataGrid.Rows.Add(row["Unique ID"], null, Strings.Trim(Conversions.ToString(row["Container Number"])), location, datimeTineInsideFileStr, confHandshakeEdi, gateDate + " " + gateTime, dTRequestSentStr, inputSource, ssLineCode, bkgnRelNumb, contSize, (object)GrossWeight, (object)tareWeight, carrierCode, TruckNumber, TruckDriverName);
}
}
public static void saveClearance(BunifuDataGridView employeDataGridView)
{
var clearanceTreeView = My.MyProject.Forms.FrmClearance.TreeView1;
int selectedRow = employeDataGridView.CurrentRow.Index;
int selectedEmployee = Conversions.ToInteger(employeDataGridView.Rows[selectedRow].Cells[6].Value);
string tableName;
string columnName;
// loop through root nodes
foreach (TreeNode rootNode in clearanceTreeView.Nodes)
{
tableName = "Main_Menu_Clearance";
columnName = rootNode.Text;
int childNodeIndex = 0;
if (rootNode.Checked)
{
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 1);
columnName = rootNode.Text;
// loop through child nodle
foreach (TreeNode node in rootNode.Nodes)
{
columnName = Conversions.ToString(node.Text);
tableName = rootNode.Text.Replace(" ", "_") + "_Clearance";
var anode = rootNode.Nodes;
if (anode[childNodeIndex].Checked)
{
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 1);
}
else
{
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
}
if (node.Nodes is object)
{
tableName = Conversions.ToString(Operators.AddObject(node.Text.Replace(" ", "_"), "_Clearance"));
TreeNodeCollection childNode = (TreeNodeCollection)node.Nodes;
for (int i = 0, loopTo = childNode.Count - 1; i <= loopTo; i++)
{
var chNodes = childNode[i];
if (chNodes.Checked)
{
columnName = childNode[i].Text;
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 1);
if (chNodes.Nodes.Count > 0)
{
var lastNodes = chNodes.Nodes;
for (int x = 0, loopTo1 = lastNodes.Count - 1; x <= loopTo1; x++)
{
if (lastNodes[x].Text.Equals("See sensitive information"))
{
columnName = lastNodes[x].Text;
if (lastNodes[x].Checked)
{
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 1);
}
else
{
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
}
}
}
}
}
else
{
columnName = Conversions.ToString(node.Nodes[i].Text);
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
if (chNodes.Nodes.Count > 0)
{
var lastNodes = chNodes.Nodes;
for (int x = 0, loopTo2 = lastNodes.Count - 1; x <= loopTo2; x++)
{
if (lastNodes[x].Text.Equals("See sensitive information"))
{
columnName = lastNodes[x].Text;
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
}
}
}
}
}
}
childNodeIndex += 1;
}
}
else
{
childNodeIndex = 0;
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
foreach (TreeNode node in rootNode.Nodes)
{
// columnName = node.Text.Replace(" ", "_") + "_Clearance"
columnName = Conversions.ToString(node.Text);
tableName = rootNode.Text.Replace(" ", "_") + "_Clearance";
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
if (node.Nodes is object)
{
for (int i = 0, loopTo3 = Conversions.ToInteger(Operators.SubtractObject(node.Nodes.Count, 1)); i <= loopTo3; i++)
{
tableName = Conversions.ToString(Operators.AddObject(node.Text.Replace(" ", "_"), "_Clearance"));
columnName = Conversions.ToString(node.Nodes[i].Text);
TreeNode chNodes = (TreeNode)node.Nodes[i];
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 1);
if (chNodes.Nodes.Count > 0)
{
var lastNodes = chNodes.Nodes;
for (int x = 0, loopTo4 = lastNodes.Count - 1; x <= loopTo4; x++)
{
if (lastNodes[x].Text.Equals("See sensitive information"))
{
columnName = lastNodes[x].Text;
db.updateClearance(selectedEmployee, tableName, columnName.Replace(" ", "_"), 0);
}
}
}
}
}
childNodeIndex += 1;
}
}
}
}
public static void reassignCardID(string cardID)
{
employeDataGridView = My.MyProject.Forms.FrmEmployeeManagement.BunifuDataGridView1;
int selectedRow = employeDataGridView.CurrentRow.Index;
string firstName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[1].Value);
string lasttName = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[2].Value);
string aliaas = Conversions.ToString(employeDataGridView.Rows[selectedRow].Cells[0].Value);
employeeID = Conversions.ToInteger(employeDataGridView.Rows[selectedRow].Cells[6].Value);
// db._ID = employeeID
if (Conversions.ToBoolean(db.cardAlreadyAssigned(cardID)))
{
string device = "";
if (My.MyProject.Forms.FrmCardAssignment.isPhoneID)
{
device = "device";
}
else
{
device = "card";
}
int result = (int)MessageBox.Show("This " + device + " is already assigned to " + My.MyProject.Forms.FrmLoginWindow._employeeName + ". Would you like to reassign it to " + aliaas + " " + lasttName + "?", "Warning", MessageBoxButtons.YesNo);
if (result == (int)DialogResult.Yes)
{
db.dissociateCardID();
db.reassignCard(employeeID.ToString(), cardID);
My.MyProject.Forms.FrmCardAssignment.reassignCardTitleLabel.ForeColor = Color.Green;
My.MyProject.Forms.FrmCardAssignment.reassignCardTitleLabel.Text = device.Substring(0, 1).ToUpper() + device.Substring(1, device.Length - 1) + " assigned to " + firstName + " " + lasttName;
My.MyProject.Forms.FrmCardAssignment.PictureBox1.Image = My.Resources.Resources.icon_available;
My.MyProject.Forms.FrmCardAssignment.BackColor = Color.White;
MdlControllerModifier.pause(2000);
My.MyProject.Forms.FrmCardAssignment.Close();
}
else
{
My.MyProject.Forms.FrmCardAssignment._cardID = "";
}
}
else
{
string device = "";
if (My.MyProject.Forms.FrmCardAssignment.isPhoneID)
{
device = "device";
}
else
{
device = "card";
}
int result = (int)MessageBox.Show("This " + device + " is not in use yet " + ". Would you like to assign it to " + aliaas + " " + lasttName + "?", "Warning", MessageBoxButtons.YesNo);
if (result == (int)DialogResult.Yes)
{
db.reassignCard(employeeID.ToString(), cardID);
My.MyProject.Forms.FrmCardAssignment.reassignCardTitleLabel.ForeColor = Color.Green;
My.MyProject.Forms.FrmCardAssignment.reassignCardTitleLabel.Text = device + " assigned to " + firstName + " " + lasttName;
My.MyProject.Forms.FrmCardAssignment.PictureBox1.Image = My.Resources.Resources.icon_available;
My.MyProject.Forms.FrmCardAssignment.BackColor = Color.White;
MdlControllerModifier.pause(2000);
My.MyProject.Forms.FrmCardAssignment.Close();
}
else
{
My.MyProject.Forms.FrmCardAssignment._cardID = "";
}
}
}
public static void populateTimeSheetList()
{
summaryList = My.MyProject.Forms.FrmTimeSheet.summaryBunifuDataGridView;
string payMethod = Conversions.ToString(My.MyProject.Forms.FrmTimeSheet.payMethodComboBox.SelectedItem.ToString().Substring(0, 1));
string selectField = "";
if (payMethod.Equals("P"))
{
payMethod = "Punch_Type = 'PW' and ";
selectField = "Punch_Type,";
}
else if (payMethod.Equals("A"))
{
payMethod = "";
}
else
{
payMethod = "Punch_Type = '" + payMethod + "' and ";
selectField = "Punch_Type,";
}
My.MyProject.Forms.FrmTimeSheet.timeSheetDescriptionLabel.Text = Conversions.ToString(Operators.AddObject("Time Sheet for period ending ", My.MyProject.Forms.FrmTimeSheet.endPeriodComboBox.SelectedItem));
ComboBox endPeriodComboBox = My.MyProject.Forms.FrmTimeSheet.endPeriodComboBox;
string endDate = Conversions.ToString(Convert.ToDateTime(Operators.AddObject(Operators.AddObject(endPeriodComboBox.SelectedItem, " "), My.MyProject.Forms.FrmTimeSheet.yearComboBox.SelectedItem.ToString())));
endPeriodDate = Convert.ToDateTime(endDate + " 23:59:59");
if (endPeriodComboBox.SelectedIndex == 0)
{
startPeriodDate = Conversions.ToDate(_firstDayOfMonth);
startPeriodDate = new DateTime(Convert.ToInt32(My.MyProject.Forms.FrmTimeSheet.yearComboBox.SelectedItem), startPeriodDate.Month, startPeriodDate.Day, 0, 0, 0, 0);
}
else
{
startPeriodDate = Convert.ToDateTime(endPeriodComboBox.Items[0]);
startPeriodDate = new DateTime(Convert.ToInt32(My.MyProject.Forms.FrmTimeSheet.yearComboBox.SelectedItem), startPeriodDate.Month, 16, 0, 0, 0, 0, 0);
}
int totalHours = 0;
int totalMinutes = 0;
string totalTime = "";
int remainder = 0;
bool employeeWorked = false;
summaryList.Rows.Clear();
// clearDataGrid(summaryList)
DataTable showEmployees = (DataTable)db.getHourlyEmpIdOfCurrentPeriod(startPeriodDate, endPeriodDate);
int uid;
string fname;
string lname;
string aliasName;
// Dim firstEntry = True
string columnsEmployees = "UserID, Alias, First_Name, Last_Name, " + selectField + " sum(totalMinutes) as totalMinutes, Type";
string tables = @"(select Alias, First_Name, Last_Name, userID, Type,
Start_Time_Date, End_Time_Date, " + selectField + @"
DATEDIFF(minute,Start_Time_Date, End_Time_Date) as totalMinutes from
Time_Sheet, Employees e";
string columnsTimeSheet = " Alias, " + selectField + @" sum(totalMinutes)from
(select Alias, Last_Name, userID, Start_Time_Date, End_Time_Date, Punch_Type,
DATEDIFF(minute,Start_Time_Date, End_Time_Date) as totalMinutes from
Time_Sheet, Employees e) k";
string conditions = "where " + payMethod + " Start_Time_Date >= '" + startPeriodDate.ToString("yyyy-MM-dd 00:00:00") + @"' and
Start_Time_Date <= '" + endPeriodDate.ToString("yyyy-MM-dd 23:59:59") + @"' and UserID = e.ID) s
group by UserID, Alias, First_Name, Last_Name, " + selectField + " Type order by Alias";
foreach (DataRow row in db.getTableInfo(tables, columnsEmployees, conditions).Rows)
{
// empid = row["ID")
uid = Conversions.ToInteger(row["userID"]);
fname = Conversions.ToString(row["First_Name"]);
lname = Conversions.ToString(row["Last_Name"]);
aliasName = Conversions.ToString(row["Alias"]);
if (Information.IsDBNull(row["totalMinutes"]))
{
totalMinutes = 0;
}
else
{
totalMinutes = Conversions.ToInteger(row["totalMinutes"]);
}
remainder = totalMinutes % 60;
if (totalMinutes >= 60)
{
totalHours += totalMinutes / 60;
}
totalTime = totalHours + ":" + remainder.ToString("D2");
conditions = "where " + payMethod + " UserID = " + uid.ToString() + " and End_Time_Date is null and Start_Time_Date >= '" + startPeriodDate.ToString("yyyy-MM-dd 00:00:00") + @"' and
Start_Time_Date <= '" + endPeriodDate.ToString("yyyy-MM-dd 23:59:59") + "'";
string punchType = "";
if (string.IsNullOrEmpty(selectField))
{
punchType = "";
}
else
{
punchType = Conversions.ToString(row["Punch_Type"]);
}
if (db.getTableInfo("Time_Sheet", "*", conditions).Rows.Count > 0)
{
summaryList.Rows.Add((object)false, aliasName, lname, fname, totalTime, "working", uid.ToString(), punchType, row["Type"]);
}
else
{
summaryList.Rows.Add((object)false, aliasName, lname, fname, totalTime, "complete", uid.ToString(), punchType, row["Type"]);
}
totalHours = 0;
totalMinutes = 0;
totalTime = "";
employeeWorked = false;
}
}
private void containersBunifuDataGridView1_SelectionChanged(object sender, EventArgs e)
{
BunifuDataGridView s = (BunifuDataGridView)sender;
totalContainersLabel.Text = s.Rows.Count.ToString() + " of " + totalNumberOfCans.ToString();
}
public void getInOutGates(BunifuDataGridView dataGrid, string gateMode)
{
dataGrid.Rows.Clear();
string collumns;
string condition;
int RecordCount = 0;
decimal GrossWeight = 0m;
string EDICan = "";
string InGateStatus;
string TempLine = "";
string ThisLine = "";
string TruckDriverName = "";
string TruckNumber = "";
DataRow InGateRow;
string contSize = "";
decimal tareWeight;
string comments;
string ediInfo;
string gateAction = "";
DateTime gateTimeDate;
DateTime ediTimeDate;
string ssLineCode;
string carrierCode;
collumns = @"[Unique ID], [Container Number], [In Gate EDI],[Out Gate EDI], [Should Send InGate EDI],[Yard Code In], [Trouble In-Gate],
[SS Line Code In], [Release Number], [Gate Date In],[Container Size], [Gross Weight], [TARE Weight],
[Carrier Code In], [Carrier Truck In], [Carrier DriverName In], [Comments In], [Gate Date Out],[In Gate EDI Date Time]
,[Out Gate EDI Date Time], [Carrier Truck Out], [SS Line Code Out], [Carrier Code Out], [Carrier Truck out],
[Carrier DriverName Out], [Gross Weight Out], [Booking Number], [Hold Out-Gate], [Should Send OutGate EDI], [ContainerSize]";
if (gateMode.Equals("ingate"))
{
condition = "Where Convert(date,[Gate Date In]) >= '" + fromInBunifuDatePicker.Value.Date + "' And Convert(date,[Gate Date In]) <= '" + toInBunifuDatePicker.Value.Date + "' Order By [Gate Date In] DESC";
gateAction = "IN-GATE";
}
else
{
condition = " Where Convert(date,[Gate Date Out]) >= '" + fromOutBunifuDatePicker.Value.Date + "' And Convert(date,[Gate Date Out]) <= '" + toOutBunifuDatePicker.Value.Date + "' Order By [Gate Date Out] DESC";
gateAction = "OUT-GATE";
}
if (isRefresh)
{
InOutDT = dbCeres.getTableInfo("[Containers In-Out]", collumns, condition);
searchTable = InOutDT;
// EDIRecordsDt = dbCeres.getTableInfo("[EDI Records]", "*", "where [Date and Time] >= '" & fromInBunifuDatePicker.Value.Date & "' And [Date and Time] <= '" &
// toInBunifuDatePicker.Value.Date & "' Order By [Date and Time] DESC")
}
foreach (DataRow row in searchTable.Rows)
{
// If row["Container Size") = ChrW(0) Then
// contSize = "20 FT"
// ElseIf row["Container Size") = ChrW(1) Then
// contSize = "40 FT"
// ElseIf row["Container Size") = ChrW(2) Then
// contSize = "40 FT HC"
// ElseIf row["Container Size") = ChrW(3) Then
// contSize = "53 FT"
// End If
// Stop
if (row["ContainerSize"] != DBNull.Value)
{
contSize = Conversions.ToString(row["ContainerSize"]);
}
else
{
contSize = "";
}
DateTime tempDate;
object tempDateTime;
DateTime tempTime;
string ediTimeDateStr = "";
if (gateMode.Equals("ingate"))
{
gateTimeDate = Conversions.ToDate(row["Gate Date In"]);
if (row["In Gate EDI Date Time"] != DBNull.Value)
{
ediTimeDate = Conversions.ToDate(row["In Gate EDI Date Time"]);
ediTimeDateStr = ediTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else
{
ediTimeDateStr = "N/A";
}
if (row["Trouble In-Gate"] == DBNull.Value && row["Trouble In-Gate"] == DBNull.Value)
{
InGateStatus = "TROUBLE";
}
else
{
InGateStatus = "VALID";
}
if (row["Carrier Truck In"] == DBNull.Value)
{
TruckNumber = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(' '), 10);
}
else
{
TruckNumber = MdlContainerManagement.DoFunctions.PadToString(Conversions.ToString(row["Carrier Truck In"]), 10);
}
if (row["Carrier DriverName In"] == DBNull.Value)
{
TruckDriverName = Strings.Trim("N/A");
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName In"]));
}
GrossWeight = Conversions.ToDecimal(Strings.Trim(MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["Gross Weight"])).ToString()));
if (row["TARE Weight"] == DBNull.Value)
{
tareWeight = 0m;
}
else
{
tareWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["TARE Weight"]));
}
comments = Strings.Trim(Conversions.ToString(row["Comments In"]));
if (row["SS Line Code In"] != DBNull.Value)
{
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code In"]));
}
else
{
ssLineCode = "N/A";
}
if (row["Carrier Code In"] != DBNull.Value)
{
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code In"]));
}
else
{
carrierCode = "N/A";
}
string relNumb = "";
string yardIn = "";
string canNumb = "";
if (row["Release Number"] != DBNull.Value)
{
relNumb = Strings.Trim(Conversions.ToString(row["Release Number"]));
}
else
{
}
if (row["Yard Code In"] != DBNull.Value)
{
yardIn = Strings.Trim(Conversions.ToString(row["Yard Code In"]));
}
if (row["Container Number"] != DBNull.Value)
{
canNumb = Strings.Trim(Conversions.ToString(row["Container Number"]));
}
dataGrid.Rows.Add(row["Unique ID"], (object)false, canNumb, gateAction, yardIn, EDICan, ediTimeDateStr, "", InGateStatus, ssLineCode, relNumb, gateTimeDate.ToString("dd-MMM-yyyy"), gateTimeDate.ToString("HH:mm"), contSize, (object)GrossWeight, (object)tareWeight, carrierCode, TruckNumber, TruckDriverName);
}
else
{
gateTimeDate = Conversions.ToDate(row["Gate Date Out"]);
if (row["Out Gate EDI Date Time"] != DBNull.Value)
{
ediTimeDate = Conversions.ToDate(row["Out Gate EDI Date Time"]);
ediTimeDateStr = ediTimeDate.ToString("dd-MMM-yyyy HH:mm");
}
else
{
ediTimeDateStr = "N/A";
}
if (row["Hold Out-Gate"] != DBNull.Value && Convert.ToBoolean(row["Hold Out-Gate"]) == true)
{
InGateStatus = "HOLD";
}
else
{
InGateStatus = "VALID";
}
if (row["Carrier Truck Out"] == DBNull.Value)
{
TruckNumber = "N/A";
}
else
{
TruckNumber = Strings.Trim(Conversions.ToString(row["Carrier Truck Out"]));
}
if (row["Carrier DriverName Out"] == DBNull.Value)
{
TruckDriverName = "N/A";
}
else
{
TruckDriverName = Strings.Trim(Conversions.ToString(row["Carrier DriverName Out"]));
}
GrossWeight = Conversions.ToDecimal(Strings.Trim(MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["Gross Weight Out"])).ToString()));
if (row["TARE Weight"] != DBNull.Value)
{
tareWeight = (decimal)MdlContainerManagement.DoFunctions.CVS(Conversions.ToString(row["TARE Weight"]));
}
else
{
tareWeight = 0m;
}
string bkgNumb;
if (row["Booking Number"] != DBNull.Value)
{
bkgNumb = Strings.Trim(Conversions.ToString(row["Booking Number"]));
}
else
{
bkgNumb = "N/A";
}
string yardIn;
if (row["Yard Code In"] != DBNull.Value)
{
yardIn = Strings.Trim(Conversions.ToString(row["Yard Code In"]));
}
else
{
yardIn = "N/A";
}
if (row["SS Line Code Out"] != DBNull.Value)
{
ssLineCode = Strings.Trim(Conversions.ToString(row["SS Line Code Out"]));
}
else
{
ssLineCode = "N/A";
}
if (row["Carrier Code Out"] != DBNull.Value)
{
carrierCode = Strings.Trim(Conversions.ToString(row["Carrier Code Out"]));
}
else
{
carrierCode = "N/A";
}
dataGrid.Rows.Add(row["Unique ID"], (object)false, Strings.Trim(Conversions.ToString(row["Container Number"])), gateAction, yardIn, EDICan, ediTimeDateStr, "", InGateStatus, ssLineCode, bkgNumb, gateTimeDate.ToString("dd-MMM-yyyy"), gateTimeDate.ToString("HH:mm"), contSize, (object)GrossWeight, (object)tareWeight, carrierCode, TruckNumber, TruckDriverName);
}
}
}
public ChartForm(BunifuDataGridView dgv)
{
InitializeComponent();
dgvForChart = dgv;
}
public static void populateDetails(int selectedID)
{
MdlLoadingSetting.waitForm.Show();
detailedEntires.Clear();
detailsDataGridView.Rows.Clear();
detailedEntires.Columns.Add("date");
detailedEntires.Columns.Add("clockIn");
detailedEntires.Columns.Add("clockOut");
detailedEntires.Columns.Add("hoursWorked");
detailedEntires.Columns.Add("punchID");
detailedEntires.Columns.Add("shift");
summaryList = My.MyProject.Forms.FrmTimeSheet.summaryBunifuDataGridView;
detailsDataGridView = My.MyProject.Forms.FrmTimeSheet.detailsBunifuDataGridView;
DateTime d1;
var d2 = default(DateTime);
string hours;
string payMethod = My.MyProject.Forms.FrmTimeSheet.payMethodComboBox.Text.Substring(0, 1);
if (payMethod.Equals("P"))
{
payMethod = "and Punch_Type = 'PW'";
}
else if (payMethod.Equals("A"))
{
payMethod = "";
}
else
{
payMethod = "and Punch_Type = '" + payMethod + "'";
}
string fields = "ID, userID, Start_Time_Date, End_Time_Date, Punch_Type";
string condition = "where Start_Time_Date >= '" + Conversions.ToString(startPeriodDate) + "' and " + "Start_Time_Date <= '" + Conversions.ToString(endPeriodDate) + "' and UserID = " + selectedID.ToString() + " " + payMethod + " order by Start_Time_Date";
foreach (DataRow entry in db.getTableInfo("Time_Sheet", fields, condition).Rows)
{
string punchType;
if (entry["Punch_Type"].Equals("H"))
{
punchType = "Hourly";
}
else if (entry["Punch_Type"].Equals("S"))
{
punchType = "Salary";
}
else
{
punchType = "Piece Work";
}
if (db.isStatPunch(Conversions.ToString(entry["ID"])))
{
punchType = "Statutory";
}
d1 = Convert.ToDateTime(entry["Start_Time_Date"]);
if (!Information.IsDBNull(entry["End_Time_Date"]))
{
d2 = Convert.ToDateTime(entry["End_Time_Date"]);
hours = Conversions.ToString(MdlControllerModifier.hoursWorked(Conversions.ToString(entry["Start_Time_Date"]), Conversions.ToString(entry["End_Time_Date"])));
detailedEntires.Items.Add(new ListViewItem(new[] { Strings.Format(d1, "MM/dd/yyyy"), Strings.Format(d1, "HH:mm "), Strings.Format(d2, "HH:mm "), Conversions.ToString(MdlControllerModifier.hoursWorked(Conversions.ToString(entry["Start_Time_Date"]), Conversions.ToString(entry["End_Time_Date"]))), Conversions.ToString(entry["ID"]), Conversions.ToString(entry["Punch_Type"]) }));
detailsDataGridView.Rows.Add(Strings.Format((object)d1, "MM/dd/yyyy"), Strings.Format((object)d1, "HH:mm "), Strings.Format((object)d2, "HH:mm "), MdlControllerModifier.hoursWorked(Conversions.ToString(entry["Start_Time_Date"]), Conversions.ToString(entry["End_Time_Date"])), punchType, "", entry["ID"], entry["Punch_Type"]);
}
else
{
detailsDataGridView.Rows.Add(Strings.Format((object)d1, "MM/dd/yyyy"), Strings.Format((object)d1, "HH:mm "), "", "", punchType, "", entry["ID"], entry["Punch_Type"]);
detailedEntires.Items.Add(new ListViewItem(new[] { Strings.Format(d1, "MM/dd/yyyy"), Strings.Format(d1, "HH:mm "), Strings.Format(d2, "HH:mm "), "", Conversions.ToString(entry["ID"]), Conversions.ToString(entry["Punch_Type"]) }));
}
}
showModifiedPunches();
MdlLoadingSetting.waitForm.Close();
}
