private void FormManageGS_Load(object sender, EventArgs e)
{
SetDgvGSColumns();
SetDgvGasDeliverColumns();
//SetDgvStaffColumns();
string selectGS = "select * from gas_station";
GlobalConnection.ExecReader(selectGS);
FillDGVFromReader(dgvGS);
GlobalConnection.CloseReader();
dgvGS.RowHeaderMouseDoubleClick += DgvGS_RowHeaderMouseDoubleClick;
dgvGS.CellEndEdit += DgvGS_CellEndEdit;
dgvGasDeliveries.CellEndEdit += dgvGasDeliveriesCellEndEdit;
//dgvStaff.CellEndEdit += dgvStaffCellEndEdit;
if (GasStation != null) // if GasStation was selected earlie imitate selection by double click
{
int rowNum = 0;
for (int i = 0; i < dgvGS.Rows.Count; i++)
{
if (Convert.ToInt32(dgvGS.Rows[i].Cells[0].Value) == GasStation.ID)
{
rowNum = i;
break;
}
}
DgvGS_RowHeaderMouseDoubleClick(dgvGS, new DataGridViewCellMouseEventArgs(-1, rowNum, 0, 0, new MouseEventArgs(MouseButtons.Left, 2, 0, 0, 0)));
}
}
private void RefreshDgvServicing()
{
// select all servicing with cars only from selected GS
GlobalConnection.ExecReader("select * from servicing where gas_deliver_id in (select id from gas_deliver where gas_station_id = " + GasStation.ID + ")");
dgvServicing.Columns.Clear();
dgvServicing.Refresh();
for (int j = 0; j < GlobalConnection.Reader.FieldCount; j++)
{
dgvServicing.Columns.Add(GlobalConnection.Reader.GetName(j), GlobalConnection.Reader.GetName(j));
}
dgvServicing.Columns[3].Width = 150; // columns for data must be wider
dgvServicing.Columns[4].Width = 150;
if (GlobalConnection.Reader.HasRows)
{
for (int i = 0; GlobalConnection.Reader.Read(); i++)
{
dgvServicing.Rows.Add();
for (int j = 0; j < GlobalConnection.Reader.FieldCount; j++)
{
dgvServicing.Rows[i].Cells[j].Value = GlobalConnection.Reader[j];
}
}
}
GlobalConnection.Reader.Close();
}
public static void SetSQLConnection(SqlConnection con)
{
if (instance == null)
{
instance = new GlobalConnection();
Connection = con;
}
}
private void dgvGasDeliveriesCellEndEdit(object sender, DataGridViewCellEventArgs e)
{
GlobalConnection.UpdateGasDeliver(
dgvGasDeliveries.Rows[e.RowIndex].Cells[1].Value != null ?
dgvGasDeliveries.Rows[e.RowIndex].Cells[1].Value.ToString() :
"",
selectedGSID,
dgvGasDeliveries.Rows[e.RowIndex].Cells[3].Value != null ?
Convert.ToInt32(dgvGasDeliveries.Rows[e.RowIndex].Cells[1].Value) :
-1,
Convert.ToInt32(dgvGasDeliveries.Rows[e.RowIndex].Cells[0].Value));
}
private void SelectGS(int rowInd)
{
string GSid = dgvGS.Rows[rowInd].Cells[0].Value.ToString();
string selectGasDelivers = "select * from gas_deliver where gas_deliver.gas_station_id = " + GSid;
GlobalConnection.ExecReader(selectGasDelivers);
FillDGVFromReader(dgvGasDeliveries);
GlobalConnection.CloseReader();
selectedGSID = Convert.ToInt32(GSid);
HighlightSelectedGS();
}
private void button1_Click(object sender, EventArgs e)
{
dgv.Rows.Add(null, textBox1.Text, null);
GlobalConnection.InsertGasDeliver(
dgv.Rows[dgv.RowCount - 1].Cells[1].Value != null ? dgv.Rows[dgv.RowCount - 1].Cells[1].Value.ToString() : "",
GSID);
SqlCommand cmd = new SqlCommand("select MAX(id) from gas_deliver", GlobalConnection.Connection);
int ID = Convert.ToInt32(cmd.ExecuteScalar());
dgv.Rows[dgv.RowCount - 1].Cells[0].Value = ID; // set id
this.Close();
}
private void DgvGS_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
//if (_isInsertNeeded) // if there is new line added insert new line into database, else update this line
//{
// GlobalConnection.InsertGasStation(
// dgvGS.Rows[e.RowIndex].Cells[1].Value != null ? dgvGS.Rows[e.RowIndex].Cells[1].Value.ToString() : "",
// dgvGS.Rows[e.RowIndex].Cells[2].Value != null ? dgvGS.Rows[e.RowIndex].Cells[2].Value.ToString() : "");
// _isInsertNeeded = false;
//}
//else
//{
GlobalConnection.UpdateGasStation(
dgvGS.Rows[e.RowIndex].Cells[1].Value != null ? dgvGS.Rows[e.RowIndex].Cells[1].Value.ToString() : "",
dgvGS.Rows[e.RowIndex].Cells[2].Value != null ? dgvGS.Rows[e.RowIndex].Cells[2].Value.ToString() : "",
Convert.ToInt32(dgvGS.Rows[e.RowIndex].Cells[0].Value));
//}
}
private void FormShowServicing_Load(object sender, EventArgs e)
{
GlobalConnection.ExecReader("select * from servicing where gas_deliver_id in (select id from gas_deliver where gas_station_id = " + GS.ID + ")");
for (int j = 0; j < GlobalConnection.Reader.FieldCount; j++)
{
dgvServicing.Columns.Add(GlobalConnection.Reader.GetName(j), GlobalConnection.Reader.GetName(j));
}
if (GlobalConnection.Reader.HasRows)
{
for (int i = 0; GlobalConnection.Reader.Read(); i++)
{
dgvServicing.Rows.Add();
for (int j = 0; j < GlobalConnection.Reader.FieldCount; j++)
{
dgvServicing.Rows[i].Cells[j].Value = GlobalConnection.Reader[j];
}
}
}
GlobalConnection.Reader.Close();
}
private GasStation GetSelectedGasStation()
{
int rowNum = GetRowNumFromGSID();
if (rowNum == -1)
{
return(null);
}
GasStation GS = new GasStation(selectedGSID, dgvGS.Rows[rowNum].Cells[1].Value.ToString(), dgvGS.Rows[rowNum].Cells[2].Value.ToString());
List <GasDeliver> GDList = new List <GasDeliver>();
List <object[]> tmpGDList = GlobalConnection.ExecReaderToList("select * from gas_deliver where gas_deliver.gas_station_id = " + selectedGSID);
for (int i = 0; i < tmpGDList.Count; i++)
{
GDList.Add(new GasDeliver(Convert.ToInt32(tmpGDList[i][0]), tmpGDList[i][1].ToString())); // 0 - id, 1 - type, 2 - gas_station_id
}
GS.GasDeliverys = GDList;
//GS.Employees = employeeList;
return(GS);
}
private void MainForm_Load(object sender, EventArgs e)
{
//List<Car> cars = new List<Car>();
//cars.Add(new Car(1));
//cars.Add(new Car(2));
//cars.Add(new Car(3));
//List<Car> tmp = cars.Where(car => car.LeaveTime != DateTime.MinValue).ToList();
//Car res = tmp.Find(car => car.LeaveTime == tmp.Min(c => c.LeaveTime));
////Car cc = cars.Find(c => c.LeaveTime == cars.Min(car => car.LeaveTime));
//dgvServicing.Rows.Add();
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder.IntegratedSecurity = true;
builder.DataSource = "localhost";
builder.InitialCatalog = "AZS";
GlobalConnection.SetSQLConnection(new SqlConnection(builder.ConnectionString));
GlobalConnection.Connection.Open();
SqlCommand cmd = new SqlCommand("delete from servicing where car_leave_time is null", GlobalConnection.Connection);
cmd.ExecuteNonQuery();
try
{
//get id from file
int gsID;
using (StreamReader sr = new StreamReader("Help.txt"))
{
gsID = Convert.ToInt32(sr.ReadLine().Split('=')[1]);
}
// create gas station (select)
string loc = "";
string brand = "";
string selectGS = "select * from gas_station where id = " + gsID;
GlobalConnection.ExecReader(selectGS);
if (GlobalConnection.Reader.HasRows)
{
for (int i = 0; GlobalConnection.Reader.Read(); i++)
{
loc = GlobalConnection.Reader.GetValue(1).ToString();
brand = GlobalConnection.Reader.GetValue(2).ToString();
}
}
GlobalConnection.CloseReader();
GasStation = new GasStation(gsID, loc, brand);
List <GasDeliver> GDList = new List <GasDeliver>();
List <object[]> tmpGDList = GlobalConnection.ExecReaderToList("select * from gas_deliver where gas_deliver.gas_station_id = " + gsID);
for (int i = 0; i < tmpGDList.Count; i++)
{
GDList.Add(new GasDeliver(Convert.ToInt32(tmpGDList[i][0]), tmpGDList[i][1].ToString())); // 0 - id, 1 - type, 2 - gas_station_id
}
GasStation.GasDeliverys = GDList;
GasStationSelectedEvent();
RefreshDgvServicing();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}