public ReturnData UpdateUserProfile()
{
ReturnData rd = new ReturnData();
SqlConnection usercon = new SqlConnection(user_db_connection_string);
UserAccess ua = new UserAccess();
int count = 0;
string sql = "update user_profile set first_name=@first_name,last_name=@last_name,email=@email,mobile_phone=@mobile_phone where user_id=@user_id";
SqlCommand cmd = new SqlCommand(sql, usercon);
cmd.Parameters.AddWithValue("@first_name", this.FirstName);
cmd.Parameters.AddWithValue("@last_name", this.LastName);
cmd.Parameters.AddWithValue("@email", this.Email);
cmd.Parameters.AddWithValue("@mobile_phone", this.MobilePhone);
cmd.Parameters.AddWithValue("@user_id", ua.getLoggedUser(this.Token));
usercon.Open();
try
{
count = (int)cmd.ExecuteNonQuery();
}
catch (Exception e)
{
rd.status = 0;
rd.message = "Something went wrong! " + e.Message;
}
usercon.Close();
if (count > 0)
{
rd.status = 1;
rd.message = "Data updated!";
}
else
{
rd.status = 0;
rd.message = rd.message + "Cannot update data";
}
return(rd);
}
public List <Hirings> GetHirings()
{
UserAccess ua = new UserAccess();
string sqlPart = "";
SqlCommand cmd = new SqlCommand();
if (this.Token == null || this.Token == "")
{
sqlPart = " where Status='ONLINE' ";
}
else if (ua.validateFunctions(this.Token, "ALL_HIRES"))
{
sqlPart = "";
}
else if (ua.validateFunctions(this.Token, "USER_HIRES"))
{
sqlPart = " where Status<>'DELETED' and UserID=@UserID ";
cmd.Parameters.AddWithValue("@UserID", ua.getLoggedUser(this.Token));
}
else
{
sqlPart = " where Status='ONLINE' ";
}
List <Hirings> list = new List <Hirings>();
SqlConnection con = new SqlConnection(connection_string);
string sql = "Select * from V_Hirings " + sqlPart +
" order by RecordRef Desc ";
cmd.CommandText = sql;
cmd.Connection = con;
con.Open();
try
{
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Hirings h = new Hirings();
h.VehicleId = rdr["VehicleId"].ToString();
h.HireID = rdr["HireID"].ToString(); //Sa
h.Rate = Convert.ToDouble(rdr["Rate"]);
h.WithDriver = Convert.ToBoolean(rdr["WithDriver"]);
h.WithoutDriver = Convert.ToBoolean(rdr["WithoutDriver"]);
h.IsAvailable = Convert.ToBoolean(rdr["IsAvailable"]);
h.Location = Convert.ToString(rdr["Location"]);
h.UserID = Convert.ToString(rdr["UserId"]);
h.Brand = Convert.ToString(rdr["Brand"]);
h.Model = Convert.ToString(rdr["Model"]);
h.IsAC = Convert.ToBoolean(rdr["WithAC"]);
h.NoOfSeats = Convert.ToInt32(rdr["NoOfSeats"]);
h.OtherOptions = Convert.ToString(rdr["OtherOption"]);
h.Name = Convert.ToString(rdr["first_name"]);
h.Email = Convert.ToString(rdr["Email"]);
h.TelNo1 = Convert.ToString(rdr["mobile_phone"]);
h.TelNo2 = Convert.ToString(rdr["mobile_phone2"]);
h.Status = rdr["Status"].ToString();
list.Add(h);
}
}
catch (Exception e)
{
string err = e.Message;
}
con.Close();
//cmd.CommandText = sql;
//cmd.Connection = con;
return(list);
}
public ReturnData SetVehicle() //Sa
{
ReturnData rd = new ReturnData();
UserAccess ua = new UserAccess();
CommonFunctions cf = new CommonFunctions();
if (!ua.validateFunctions(this.Token, "MNG_VEHICLE"))
{
rd.status = 0;
rd.message = "Access denied! ";
return(rd);
}
if (this.VehicleId == "" || this.VehicleId == null)
{
this.VehicleId = "VID" + cf.getNextId("VEHICLE_ID");
}
SqlConnection con = new SqlConnection(connection_string);
string sql = "Begin " + //Sa
"IF exists(select * from Vehical where VehicleId=@VehicleId) " +
"begin " +
"Update Vehical set Brand=@Brand,Model=@Model,WithAC=@WithAC,NoOfSeats=@NoOfSeats, OtherOption=@OtherOption " +
"where VehicleId=@VehicleId and UserId=@UserId; " +
"end; " +
"else " +
"begin " +
"insert into Vehical (UserId,VehicleId,Brand,Model,WithAC,NoOfSeats, OtherOption) " +
"values(@UserId,@VehicleId,@Brand,@Model,@WithAC,@NoOfSeats, @OtherOption ) " +
"end; " +
"end; ";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@UserId", ua.getLoggedUser(this.Token));
cmd.Parameters.AddWithValue("@VehicleId", this.VehicleId);
cmd.Parameters.AddWithValue("@Brand", this.Brand);
cmd.Parameters.AddWithValue("@Model", this.Model);
cmd.Parameters.AddWithValue("@WithAC", this.WithAC);
cmd.Parameters.AddWithValue("@NoOfSeats", this.NoOfSeats);
cmd.Parameters.AddWithValue("@OtherOption", this.OtherOptions);
//cmd.Parameters.AddWithValue("@ImagePath", this.ImagePath);
con.Open();
try
{
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
rd.status = 1;
rd.message = "successd";
}
else
{
rd.status = 0;
rd.message = "Not inserted";
}
}
catch (Exception e)
{
rd.status = 0;
rd.message = "Something went wrong " + e.Message;
}
con.Close();
return(rd);
}
public ReturnData SetHiring()
{
ReturnData rd = new ReturnData();
CommonFunctions cf = new CommonFunctions();
UserAccess ua = new UserAccess();
if (!ua.validateFunctions(this.Token, "MNG_HIRE"))
{
rd.status = 0;
rd.message = "Access denied! ";
return(rd);
}
if (this.VehicleId == "" || this.VehicleId == null)
{
rd.status = 0;
rd.message = "Must select and vehicle!";
return(rd);
}
if (this.HireID == "" || this.HireID == null)
{
if (ValidateVehicle(this.VehicleId))
{
rd.status = 0;
rd.message = "This vehicle is in another hire!";
return(rd);
}
this.HireID = "HI" + cf.getNextId("HIRE_NO");
}
SqlConnection con = new SqlConnection(connection_string);
string sql = "Begin " +
"IF exists (Select * from Hiring where VehicleId=@VehicleId) " +
"begin " +
"Update Hiring set Rate=@Rate,WithDriver=@WithDriver,WithoutDriver=@WithoutDriver,IsAvailable=@IsAvailable,Location=@Location,Status=@Status " +
"where HireID=@HireID and UserID=@UserID; " +
"end; " +
"else " +
"begin " +
"Insert into Hiring (HireID,VehicleId,Rate,WithDriver,WithoutDriver,IsAvailable,Location,UserID,Status) " +
"Values(@HireID,@VehicleId,@Rate,@WithDriver,@WithoutDriver,@IsAvailable,@Location,@UserID,@Status); " +
"end; " +
"end; ";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@HireID", this.HireID);
cmd.Parameters.AddWithValue("@VehicleId", this.VehicleId);
cmd.Parameters.AddWithValue("@Rate", this.Rate);
cmd.Parameters.AddWithValue("@WithDriver", this.WithDriver);
cmd.Parameters.AddWithValue("@WithoutDriver", this.WithoutDriver);
cmd.Parameters.AddWithValue("@IsAvailable", this.IsAvailable);
cmd.Parameters.AddWithValue("@Location", this.Location);
cmd.Parameters.AddWithValue("@UserID", ua.getLoggedUser(this.Token));
cmd.Parameters.AddWithValue("@Status", this.Status);
con.Open();
try
{
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
rd.status = 1; rd.message = "Success!";
}
else
{
rd.status = 0; rd.message = "Not Success";
}
}
catch (Exception e)
{
rd.status = 0;
rd.message = "Something went wrong! " + e.Message;
}
con.Close();
return(rd);
}
