public Driver GetDriver(Guid id)
 {
     Driver driver = new Driver();
     SqlService sql = new SqlService(_sqlConnection);
     sql.AddParameter("@pDriverKey", System.Data.SqlDbType.UniqueIdentifier, id);
     using (SqlDataReader reader = sql.ExecuteSPReader("ICMS_spGetDriver"))
     {
         if (reader.HasRows)
         {
             while (reader.Read())
             {
                 driver.Id = id; // reader.SafeGetGuid(reader.GetOrdinal("DriverKey")).Value;
                 driver.DriverName = reader.SafeGetString(reader.GetOrdinal("DriverName"));
                 driver.DriverMobileNo = reader.SafeGetString(reader.GetOrdinal("DriverMobile"));
                 driver.AssignedTT = reader.SafeGetString(reader.GetOrdinal("AssignedTT"));
             }
         }
     }
     return driver;
 }
 private void CreateUpdateDriver(Driver driver)
 {
     //		MMD_spUpdateDriver]
     //@pDriverKey as uniqueidentifier = NULL,
     //@pTTKey as uniqueidentifier = NULL,
     //@pTTNo as varchar(20),
     //@pDriverName as varchar(250),
     //@pDriverMobile as bigint
     SqlService sql = new SqlService(_sqlConnection);
     if (driver.Id != null)
         sql.AddParameter("@pDriverKey", System.Data.SqlDbType.UniqueIdentifier, driver.Id);
     sql.AddParameter("@pTTNo", System.Data.SqlDbType.VarChar, driver.AssignedTT);
     sql.AddParameter("@pDriverName", System.Data.SqlDbType.VarChar, driver.DriverName);
     sql.AddParameter("@pDriverMobile", System.Data.SqlDbType.VarChar, driver.DriverMobileNo);
     sql.ExecuteSP("MMD_spUpdateDriver");
 }
 public void UpdateDriver(Driver driver)
 {
     CreateUpdateDriver(driver);
 }