public bool UpdateDriverStatus(DriverData driver) { cmd = new SqlCommand("proc_UpdateDriversStatus", con); cmd.CommandType = CommandType.StoredProcedure; try { cmd.Parameters.AddWithValue("@eId", driver.Id); cmd.Parameters.AddWithValue("@eStatus", driver.Status); if (con.State == ConnectionState.Open) { con.Close(); } con.Open(); int result = cmd.ExecuteNonQuery(); if (result > 0) { return(true); } else { return(false); } } catch (Exception e) { throw e; } finally { con.Close(); } }
public ICollection <DriverData> SelectAllDrivers() { List <DriverData> drivers = new List <DriverData>(); SqlCommand cmd = new SqlCommand("proc_GetAllDrivers", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter daDriver = new SqlDataAdapter(cmd); DataSet ds = new DataSet();//collection of datatables try { daDriver.Fill(ds, "Driver"); DriverData driver; foreach (DataRow dr in ds.Tables[0].Rows) { driver = new DriverData(); driver.Id = Convert.ToInt32(dr[0]); driver.Name = dr[1].ToString(); driver.Phone = dr[2].ToString(); driver.Status = dr[3].ToString(); driver.Area = dr[3].ToString(); drivers.Add(driver); } return(drivers); } catch (Exception e) { throw e; } }