public DataTable ValidateDriverCredentials(DriverLogin b)
{
LogTraceWriter traceWriter = new LogTraceWriter();
SqlConnection conn = new SqlConnection();
DataTable dt = new DataTable();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials....");
StringBuilder str = new StringBuilder();
str.Append("@DriverNo" + b.Mobilenumber + ",");
str.Append("@Password" + b.Password + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials Input sent...." + str.ToString());
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "drivercredentials";
cmd.Connection = conn;
SqlParameter ss = new SqlParameter();
ss.ParameterName = "@DriverNo";
ss.SqlDbType = SqlDbType.VarChar;
ss.Value = b.Mobilenumber;
cmd.Parameters.Add(ss);
SqlParameter dd = new SqlParameter();
dd.ParameterName = "@Password";
dd.SqlDbType = SqlDbType.VarChar;
dd.Value = b.Password;
cmd.Parameters.Add(dd);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "ValidateDriverCredentials successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "ValidateDriverCredentials...." + ex.Message.ToString());
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}
public DriverFeedback()
{
InitializeComponent();
if (tNetUserLoginData.Contains("UserLoginData"))
{
userData = new DriverLogin();
userData = (DriverLogin)tNetUserLoginData["UserLoginData"];
pwmd5 = (string)tNetUserLoginData["PasswordMd5"];
userId = (string)tNetUserLoginData["UserId"];
}
}
public DriverMyTrip()
{
InitializeComponent();
//Get User data from login
if (tNetUserLoginData.Contains("UserLoginData"))
{
userData = new DriverLogin();
userData = (DriverLogin)tNetUserLoginData["UserLoginData"];
password = (string)tNetUserLoginData["PasswordMd5"];
userId = (string)tNetUserLoginData["UserId"];
}
GetMyTripData();
//Load My trip
}
public DriverCarList()
{
InitializeComponent();
if (tNetUserLoginData.Contains("UserLoginData"))
{
userData = (DriverLogin)tNetUserLoginData["UserLoginData"];
userId = (string)tNetUserLoginData["UserId"];
}
if (tNetUserLoginData.Contains("PushChannelURI"))
{
pushChannelURI = (string)tNetUserLoginData["PushChannelURI"];
}
GetCarListToLLS();
}
public DriverProfile()
{
InitializeComponent();
//Load drver profile
if (tNetUserLoginData.Contains("UserLoginData"))
{
userData = new DriverLogin();
cityNamesDB = new Dictionary<string, DriverGetCityList>();
userData = (DriverLogin)tNetUserLoginData["UserLoginData"];
pwmd5 = (string)tNetUserLoginData["PasswordMd5"];
preOlmd = (long)tNetUserLoginData["UserLmd"];
cityNamesDB = (IDictionary<string, DriverGetCityList>)tNetUserLoginData["CityNamesDB"];
userId = (string)tNetUserLoginData["UserId"];
}
tbl_OfficeAddress_Show.Text = tbl_OfficeAddress.Text;
txt_HomeAddress.Text = tbl_HomeAddress.Text;
LoadDriverProfile();
}
public HomePage()
{
InitializeComponent();
//Get User data from login
if (tNetUserLoginData.Contains("UserLoginData"))
{
mySelectedVehicle = new VehicleInfo();
userData = (DriverLogin)tNetUserLoginData["UserLoginData"];
userId = (string)tNetUserLoginData["UserId"];
pwmd5 = (string)tNetUserLoginData["PasswordMd5"];
mySelectedVehicle = (VehicleInfo)tNetUserLoginData["MySelectedVehicle"];
rawPass = (string)tNetUserLoginData["RawPassword"];
}
updateLocationTimer = new DispatcherTimer();
updateLocationTimer.Tick += new EventHandler(updateLocationTimer_Tick);
updateLocationTimer.Interval = new TimeSpan(0, 0, 0, 20); //Sau năm dây sẽ chạy cập nhật nếu như lần cập nhật trước không thành công
//Tạo kênh Notification
CreatePushChannel();
//get First Local Position
GetCurrentCorrdinate();
UpdateCurrentLocation(currentLat, currentLng);
//Open Status Screen
ShowLoadingScreen();
LoadDriverProfile();
UpdateDriverStatus(ConstantVariable.dStatusNotAvailable); //"NA"
LoadCityNameDataBase();
TripTrackingOnMap(); //Chuẩn bị cho việc tracking
}
