protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int id = (int)GridView1.DataKeys[e.RowIndex].Value;
workStation = dataWorkStation.readWorkStationEDIT(id);
dataWorkStation.deleteWorkStation(id, workStation.IdLab);
Response.Redirect("/CRUDWorkStation.aspx");
}
protected void gvResults_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit")
{
int index = Convert.ToInt32(e.CommandArgument);
int i = (int)GridView1.DataKeys[index].Value;
workStation = dataWorkStation.readWorkStationEDIT(i);
Session["workStationSession"] = workStation;
Response.Redirect("/EditWorkStation.aspx");
}
}
public DataTable readWorkStation()
{
DataTable dt = new DataTable();
WorkStation workStation = new WorkStation();
Lab lab = new Lab();
SqlConnection con = DatabaseConnection("open");
SqlCommand cmd = new SqlCommand("readWorkStation", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
cmd.Dispose();
DatabaseConnection("close");
return dt;
}
public List<WorkStation> selectBusy(int idlab, string startTime, string date)
{
int pos = 1;
List<WorkStation> ws = new List<WorkStation>();
WorkStation wsD = new WorkStation();
idLab = dataLab.changeNameToId(ddlLab.SelectedValue);
int contCode = dataReservation.SelectLabCode(idLab);
int cont = 30 * (contCode - 1) + 1;
for (int i = cont; i < 30 * contCode; i++)
{
ws.Add(dataWS.readWorkStationBusy(i, startTime, date));
pos++;
}
ws.Add(wsD);
return ws;
}
public WorkStation readWorkStationBusy(int id, string startTime, string date)
{
DataReservation dataReservation = new DataReservation();
WorkStation workStation = new WorkStation();
SqlConnection con = DatabaseConnection("open");
SqlCommand cmd = new SqlCommand("readWorkStationEDIT", con);
cmd.Parameters.AddWithValue("@id", id);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
workStation.Id = reader.GetInt32(reader.GetOrdinal("id"));
workStation.Description = reader.GetString(reader.GetOrdinal("description"));
workStation.IdLab = reader.GetInt32(reader.GetOrdinal("idLab"));
workStation.Busy = dataReservation.SelectAvailabilityStation(id, startTime, date);
}
cmd.Dispose();
DatabaseConnection("close");
return workStation;
}
public void updateWorkStation(WorkStation workStation) { }