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)); }