public JsonResult AssignBike([FromBody] AssignVehicleModel Driver)
{
Driver.AssignBy = Constant.GetUserID();
var Response = SQL.AssignBike(Driver);
return(Json(Response, JsonRequestBehavior.AllowGet));
}
public MessageResult AssignBike(AssignVehicleModel Driver)
{
int i = 0;
Guid ID = Guid.NewGuid(); //DriverID
MessageResult swResponse = new MessageResult();
SQLExecutor(string.Format("UPDATE VehicleAssignmentHistory SET Status=0 WHERE Status=1 AND DriverID='{0}'", Driver.DriverID));
try
{
using (SqlConnection conn = new SqlConnection(DBConn))
{
string sql = "INSERT INTO [dbo].[VehicleAssignmentHistory] ([ID],[VehicleID],[DriverID],[AddedBy],[AddedAt])" +
"VALUES ( @ID,@VehicleID,@DriverID,@AddedBy,@AddedAt)";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
cmd.Parameters.AddWithValue("@ID", ID.ToString().ToUpper());
cmd.Parameters.AddWithValue("@VehicleID", Driver.VehicleID);
cmd.Parameters.AddWithValue("@DriverID", Driver.DriverID);
cmd.Parameters.AddWithValue("@AddedBy", Driver.AssignBy);
cmd.Parameters.AddWithValue("@AddedAt", DateTime.Now);
i = cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
i = 0;
}
if (i == 0)
{
swResponse.Status = "warning";
swResponse.Message = "Failed to Assign. Try Again";
}
else
{
swResponse.Status = "success";
swResponse.Message = "Rider Assigned Vehicle Successfully";
}
return(swResponse);
}
public JsonResult AssignVehicle([FromBody] AssignVehicleModel assign)
{
var Response = SQL.AssignBike(assign);
return(Json(Response, JsonRequestBehavior.AllowGet));
}
