public async Task <ActionResult> CreateUpdateVehicle([FromBody] VehiclesModel obj)
{
var md = _mapper.Map <Vehicles>(obj);
var res = _vehicleRepository.CreateVehicle(md);
return(Ok(res));
}
public static DataTable SaveVehicle(VehiclesModel vehiclemodel, string Action)
{
try
{
string ConnectionString = Common.GetConnectionString();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@UserId", vehiclemodel.UserId));
parameters.Add(new SqlParameter("@VehicleId", vehiclemodel.VehicleId));
parameters.Add(new SqlParameter("@Make", vehiclemodel.Make));
parameters.Add(new SqlParameter("@Model", vehiclemodel.Model));
parameters.Add(new SqlParameter("@Year", vehiclemodel.Year));
parameters.Add(new SqlParameter("@Color", vehiclemodel.Color));
parameters.Add(new SqlParameter("@LicensePlate", vehiclemodel.LicencePlate));
parameters.Add(new SqlParameter("@SpecialNotes", vehiclemodel.SpecialNotes));
parameters.Add(new SqlParameter("@VehicleImageURL", vehiclemodel.VehicleImageURL));
parameters.Add(new SqlParameter("@ImageType", vehiclemodel.ImageType));
parameters.Add(new SqlParameter("@Action", Action));
using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spSaveVehicle", parameters.ToArray()).Tables[0])
{
return(dt);
//int rowsAffected = SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "spSaveVehicle", parameters.ToArray());
//return rowsAffected;
}
}
catch (Exception e)
{
//loggerErr.Error(e.Message + " - " + e.StackTrace);
throw e;
}
}
/// <summary>
/// Vehicles page
/// </summary>
/// <returns>Page with list of vehicles in incidents</returns>
public IActionResult Vehicles()
{
VehiclesModel model = new VehiclesModel();
model.Vehicles = _context.Vehicles.ToList();
return(View(model));
}
public void Update(VehiclesModel vehicle)
{
var vehicleRecord = _modelContext.VehicleRecordsProperties.Include("VehicleRecords").Where(i => i.VrId == vehicle.VRId).ToList();
foreach (var record in vehicleRecord)
{
if (record.VpmId == 2)
{
record.Value = vehicle.Engine;
}
if (record.VpmId == 3)
{
record.Value = vehicle.Doors;
}
if (record.VpmId == 4)
{
record.Value = vehicle.Wheels;
}
if (record.VpmId == 5)
{
record.Value = vehicle.BodyType;
}
if (record.VpmId == 6)
{
record.Value = vehicle.Colour;
}
var entry = _modelContext.VehicleRecordsProperties.Update(record);
entry.State = EntityState.Modified;
_modelContext.SaveChanges();
}
}
public List <VehiclesModel> GetFilteredVehicleSummariesByDateRange(int id, string startDate, string endDate)
{
string cs = CONNECTIONSTRING;
var conn = new NpgsqlConnection(cs);
conn.Open();
string sql = "SELECT * FROM bookings WHERE (bookingdate >= cast('" + startDate + "' AS DATE) AND bookingdate <= cast('" + endDate + "' AS DATE)) && vehicleid = " + id;
var cmd = new NpgsqlCommand(sql, conn);
NpgsqlDataReader dr = cmd.ExecuteReader();
var vehicles = new List <VehiclesModel>();
while (dr.Read())
{
var Vehicle = new VehiclesModel
{
VehicleId = dr.GetInt32(0),
Model = dr.GetString(1)
};
vehicles.Add(Vehicle);
}
conn.Close();
return(vehicles);
}
public List <VehiclesModel> GetVehicleDetails()
{
string cs = CONNECTIONSTRING;
var conn = new NpgsqlConnection(cs);
conn.Open();
string sql = @"SELECT * FROM vehicles";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
NpgsqlDataReader dr = cmd.ExecuteReader();
var vehicles = new List <VehiclesModel>();
while (dr.Read())
{
var vehicleModel = new VehiclesModel
{
VehicleId = dr.GetInt32(0),
Model = dr.GetString(1),
CreatedOn = dr.GetDateTime(2)
};
vehicles.Add(vehicleModel);
}
conn.Close();
return(vehicles);
}
private void Validation(VehiclesModel vehicles)
{
if (vehicles.VtId == 0)
{
ModelState.AddModelError("", "Select Vehicle");
}
else if (vehicles.VmakeId == 0)
{
ModelState.AddModelError("", "Select Make");
}
else if (vehicles.VmodelId == 0)
{
ModelState.AddModelError("", "Select Model");
}
else if (string.IsNullOrEmpty(vehicles.Engine))
{
ModelState.AddModelError("", "Select Engine");
}
else if (string.IsNullOrEmpty(vehicles.Doors))
{
ModelState.AddModelError("", "Select Doors");
}
else if (string.IsNullOrEmpty(vehicles.Wheels))
{
ModelState.AddModelError("", "Select Wheels");
}
else if (string.IsNullOrEmpty(vehicles.BodyType))
{
ModelState.AddModelError("", "Select Body Type");
}
else if (string.IsNullOrEmpty(vehicles.Colour))
{
ModelState.AddModelError("", "Select Colour");
}
}
public VehiclesModel GetVehicleDetailsById(int id)
{
string cs = CONNECTIONSTRING;
var conn = new NpgsqlConnection(cs);
conn.Open();
string sql = @"SELECT vehicleid, model FROM vehicles WHERE vehicleid = " + id;
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
NpgsqlDataReader dr = cmd.ExecuteReader();
var vehicle = new VehiclesModel();
while (dr.Read())
{
var vehicleModel = new VehiclesModel
{
VehicleId = dr.GetInt32(0),
Model = dr.GetString(1)
};
vehicle = vehicleModel;
}
conn.Close();
return(vehicle);
}
public void InsertIntoVehicleRecordProperties(VehiclesModel vehicles, decimal id)
{
if (!string.IsNullOrEmpty(vehicles.Engine))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 2,
Value = vehicles.Engine
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Doors))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 3,
Value = vehicles.Doors
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Wheels))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 4,
Value = vehicles.Wheels
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.BodyType))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 5,
Value = vehicles.BodyType
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
if (!string.IsNullOrEmpty(vehicles.Colour))
{
var recordProperty = new VehicleRecordsProperties()
{
VrId = id,
VpmId = 6,
Value = vehicles.Colour
};
_modelContext.VehicleRecordsProperties.Add(recordProperty);
_modelContext.SaveChanges();
}
}
public int UpdateVehicle(VehiclesModel model)
{
try
{
return(MembersBAL.UpdateVehicle(model));
}
catch (Exception exc)
{
throw new FaultException <FuneralServiceFault>(new FuneralServiceFault(exc.Message));
}
}
public static string SaveUpdateVehicle([FromBody] VehiclesModel vehiclemodel, string Action)
{
string Result = "";
try
{
//if(vehiclemodel.ImageType == "")
//{
// Result = "Please enter Image Type";
//}
//else if (vehiclemodel.VehicleImage.ToString() != "")
//{
// vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result;
//}
//if (vehiclemodel.LicensePlate == "")
//{
// Result = "Please enter License Plate" ;
//}
//else if (vehiclemodel.UserId <= 0)
//{
// Result = "Please enter UserId";
//}
//else
//{
DataTable dt = Data.Vehicles.SaveVehicle(vehiclemodel, Action);
//VehiclesDetails vechile = new VehiclesDetails();
if (dt.Rows[0]["VehicleId"].ToString() != "")
{
Result = (dt.Rows[0]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["VehicleId"]).ToString();
}
else
{
Result = "Error Updating the Vehicle";
}
//}
return(Result);
}
catch (Exception e)
{
throw e;
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
VehiclesModel = await _context.VehiclesModel.FirstOrDefaultAsync(m => m.ID == id);
if (VehiclesModel == null)
{
return(NotFound());
}
return(Page());
}
public IActionResult Create(VehiclesModel vehicles, IFormCollection formCollection)
{
IActionResult returnpath = View(vehicles);
VehicleMakemodelMapping mapping = new VehicleMakemodelMapping();
//var _modelContext = new VehiclesContext();
try
{
Validation(vehicles);
decimal VmakeId = Convert.ToDecimal(HttpContext.Request.Form["VmakeId"]);
decimal VmodelId = Convert.ToDecimal(HttpContext.Request.Form["VmodelId"]);
mapping = _vehicleService.GetMakeModelIDList(mapping, VmakeId, VmodelId);
if (ModelState.IsValid)
{
if (mapping != null)
{
var record = new VehicleRecords()
{
VmmpId = mapping.VmmpId
};
_modelContext.VehicleRecords.Add(record);
_modelContext.SaveChanges();
decimal id = record.VrId;
if (id != 0)
{
_vehicleService.InsertIntoVehicleRecordProperties(vehicles, id);
}
}
returnpath = RedirectToAction("Index");
}
else
{
ViewBag.ListOfVehicles = _vehicleService.LoadVehicleTypeList();
returnpath = View(vehicles);
}
}
catch (Exception ex)
{
_logger.LogError(" Exception on creating new record: " + ex);
}
return(returnpath);
}
protected void btnUpdateVehicle_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
VehiclesModel ObjVehicleModel = new VehiclesModel();
ObjVehicleModel = new VehiclesModel();
ObjVehicleModel.VehicleMake = txtVehicleMake.Text;
ObjVehicleModel.VehicleModel = txtVehicleModel.Text;
ObjVehicleModel.VehicleYear = txtVehicleYear.Text;
ObjVehicleModel.VehicleColor = txtVehicleYear.Text;
ObjVehicleModel.VehicleTrackingCompany = txtVehicleTrackingCompany.Text;
ObjVehicleModel.VehicleRegNo = txtVehicleRegNo.Text;
ObjVehicleModel.VehicleVinNo = txtVehicleVinNo.Text;
ObjVehicleModel.VehicleEngNo = txtVehicleEngNo.Text;
ObjVehicleModel.FkiMemberID = this.MemberId;
ObjVehicleModel.ParlourID = this.ParlourId;
ObjVehicleModel.StartDate = DateTime.Now;
ObjVehicleModel.LastModified = DateTime.Now;
ObjVehicleModel.ModifiedUser = this.User.Identity.Name;
ObjVehicleModel.PkiVehicleID = Convert.ToInt32(hfVehicleId.Value);
int documentid = client.UpdateVehicle(ObjVehicleModel);
btnAddVehicle.Visible = true;
btnUpdateVehicle.Visible = false;
bindVehicles();
ClearVehiclesControl();
ShowMessage(ref lblMessage, MessageType.Success, "Vehicle udpated successfully");
Response.Redirect("~/admin/managemember.aspx?tabid=5&id=" + ObjVehicleModel.PkiVehicleID.ToString());
ScriptManager.RegisterStartupScript(this, this.GetType(), "gototab51", "gototab(5);", true);
}
catch (FaultException <FuneralServiceFault> fault)
{
lblMessage.Text = "<div class='ibox-content'><div class='alert alert-danger'>" + fault.Detail.Message + "</div>";
}
catch (Exception ex)
{
ShowMessage(ref lblMessage, MessageType.Danger, ex.Message);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "gototab51", "gototab(5);", true);
}
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
VehiclesModel = await _context.VehiclesModel.FindAsync(id);
if (VehiclesModel != null)
{
_context.VehiclesModel.Remove(VehiclesModel);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
private void SelectVehicleByVehicleId(int VehicleID)
{
DateTime dt = new DateTime(1900, 01, 01);
VehiclesModel objvehiclesmodel = new VehiclesModel();
objvehiclesmodel = client.SelectVehicleByVehicleId(VehicleID);
txtVehicleMake.Text = objvehiclesmodel.VehicleMake;
txtVehicleModel.Text = objvehiclesmodel.VehicleModel;
txtVehicleYear.Text = objvehiclesmodel.VehicleYear;
txtVehicleColor.Text = objvehiclesmodel.VehicleColor;
txtVehicleTrackingCompany.Text = objvehiclesmodel.VehicleTrackingCompany;
txtVehicleVinNo.Text = objvehiclesmodel.VehicleVinNo;
txtVehicleRegNo.Text = objvehiclesmodel.VehicleRegNo;
txtVehicleEngNo.Text = objvehiclesmodel.VehicleEngNo;
hfVehicleId.Value = objvehiclesmodel.PkiVehicleID.ToString();
btnAddVehicle.Visible = false;
btnUpdateVehicle.Visible = true;
}
/// <summary>
/// Returns a view of all of the available vehicles
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public VehiclesModel GetAllVehicles()
{
var vehicles = new VehiclesModel
{
Next = "https://swapi.co/api/vehicles/",
Vehicles = new List <VehicleModel>()
};
while (vehicles.Next != null)
{
var result = JsonConvert.DeserializeObject <VehiclesModel>(request.GetResponse(vehicles.Next));
// Update the planets object
vehicles.Count = result.Count;
vehicles.Next = result.Next;
vehicles.Vehicles.AddRange(result.Vehicles.ToList());
}
return(vehicles);
}
protected void gvVehicles_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
VehiclesModel rowView = (VehiclesModel)e.Row.DataItem;
// Retrieve the key value for the current row. Here it is an int.
//int myDataKey = Convert.ToInt32(rowView["pkiVehicleID"]);
if (rowView.PkiVehicleID == 0)
{
LinkButton lbtnEditVehicle = e.Row.FindControl("lbtnEditVehicle") as LinkButton;
if (lbtnEditVehicle != null)
{
lbtnEditVehicle.Enabled = true;
}
LinkButton lbtnDeleteVehicle = e.Row.FindControl("lbtnDeleteVehicle") as LinkButton;
if (lbtnDeleteVehicle != null)
{
lbtnDeleteVehicle.Enabled = false;
}
}
}
}
public async Task <IActionResult> Get()
{
var vehicles = await _context.Vehicles
.Include(m => m.Model)
.Include(m => m.Model.Make)
.ToListAsync();
var model = new VehiclesModel();
vehicles.ForEach(v => model.Vehicles.Add(new VehicleModel
{
VehicleId = v.VehicleId,
MakeId = v.Model.MakeId,
MakeName = v.Model.Make.Name,
ModelId = v.ModelId,
ModelName = v.Model.Name,
Description = v.Description,
Year = v.Year,
Vin = v.Vin
}));
return(Ok(model));
}
public ActionResult <VehiclesModel> Get(string id)
{
try
{
if (string.IsNullOrWhiteSpace(id))
{
return(new StatusCodeResult((int)HttpStatusCode.BadRequest));
}
int.TryParse(id, out int Id);
VehiclesModel vehiclesModel = _vehicleService.GetVehicleDetailsById(Id);
return(Ok(vehiclesModel));
}
catch (ArgumentNullException ane)
{
return(BadRequest(ane.Message));
}
catch (Exception ex)
{
_logger?.LogCritical("There was an error on '{0}' invocation: {1}", nameof(Get), ex);
return(new StatusCodeResult((int)HttpStatusCode.InternalServerError));
}
}
protected void btnAddVehicle_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
string VehicleVinNo = txtVehicleVinNo.Text;
if (VehicleVinNo == "" || VehicleVinNo == string.Empty)
{
VehicleVinNo = "0";
}
else
{
VehicleVinNo = txtVehicleVinNo.Text;
}
VehiclesModel ObjVehicleModel;
ObjVehicleModel = client.GetVehicleByVinNo(VehicleVinNo, ParlourId, MemberId);
if (ObjVehicleModel != null)
{
ShowMessage(ref lblMessage, MessageType.Danger, "Vehicle Already Exists.");
}
else
{
ObjVehicleModel = new VehiclesModel();
ObjVehicleModel.VehicleMake = txtVehicleMake.Text;
ObjVehicleModel.VehicleModel = txtVehicleModel.Text;
ObjVehicleModel.VehicleYear = txtVehicleYear.Text;
ObjVehicleModel.VehicleColor = txtVehicleColor.Text;
ObjVehicleModel.VehicleTrackingCompany = txtVehicleTrackingCompany.Text;
ObjVehicleModel.VehicleRegNo = txtVehicleRegNo.Text;
ObjVehicleModel.VehicleVinNo = txtVehicleVinNo.Text;
ObjVehicleModel.VehicleEngNo = txtVehicleEngNo.Text;
ObjVehicleModel.FkiMemberID = this.MemberId;
ObjVehicleModel.ParlourID = this.ParlourId;
ObjVehicleModel.StartDate = DateTime.Now;
ObjVehicleModel.LastModified = DateTime.Now;
ObjVehicleModel.ModifiedUser = this.User.Identity.Name;
int documentId;
if (ObjVehicleModel.FkiMemberID != 0)
{
documentId = client.SaveVehicle(ObjVehicleModel);
// bindVehicles();
}
if (ObjVehicleModel.FkiMemberID == 0)
{
List <VehiclesModel> modelList = new List <VehiclesModel>();
if (Session["Vehicle"] == null)
{
modelList.Add(ObjVehicleModel);
}
else
{
modelList = (List <VehiclesModel>)Session["Vehicle"];
modelList.Add(ObjVehicleModel);
}
Session["Vehicle"] = modelList;
}
bindVehicles();
ClearVehiclesControl();
ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab5", "goToTab(5);", true);
ShowMessage(ref lblMessage, MessageType.Success, "Vehicle successfully saved");
IncrementVehicle++;
}
}
catch (FaultException <FuneralServiceFault> fault)
{
lblMessage.Text = "<div class='ibox-content'><div class='alert alert-Danger'>" + fault.Detail.Message + "</div>";
}
catch (Exception ex)
{
ShowMessage(ref lblMessage, MessageType.Danger, ex.Message);
}
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "goToTab5", "goToTab(5);", true);
ShowMessage(ref lblMessage, MessageType.Danger, "Vehicle not saved");
}
}
public IActionResult UpdateVehicle([FromBody] VehiclesModel vehiclemodel)
{
string Action = "Update";
try
{
string Result = "";
//if (vehiclemodel.ImageType == "")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } });
//}
//else
if (vehiclemodel.VehicleImage != null && vehiclemodel.VehicleImage.Length > 0)
{
if (vehiclemodel.ImageType == "")
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } }));
}
else
{
vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result;
}
}
if (vehiclemodel.LicencePlate == "")
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } }));
}
else if (vehiclemodel.UserId <= 0)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } }));
}
//if (Result == "Please enter LicensePlate")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } });
//}
//else if (Result == "Please enter Image Type")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } });
//}
//else if (Result == "Please enter UserId")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } });
//}
string Results = SaveUpdateVehicle(vehiclemodel, Action);
if (Results != "Error Updating the Vehicle")
{
int VehicleId = Convert.ToInt32(Results);
return(StatusCode((int)HttpStatusCode.OK, new { VehicleId, message = vehiclemodel.LicencePlate + " is updated successfully" }));
}
else //if (Results == "Error Updating the Vehicle")
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("UpdateVehicle", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } }));
}
}
public IActionResult GetVehicleDetailedList(int VehicleId)
{
List <ServiceInfo> ServiceList = new List <ServiceInfo>();
PaymentDetails paymentinfo = new PaymentDetails();
PlanInfo planInfo = new PlanInfo();
List <PlanInfo> planInfoList = new List <PlanInfo>();
try
{
//var SearchRes = "";
//if (Search == null)
//{
// SearchRes = "";
//}
//else
//{
// SearchRes = Search;
//}
DataSet ds = Data.Vehicles.GetVehicleDetailedList(VehicleId);
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
DataTable dt3 = new DataTable();
UserInfo userInfo = new UserInfo();
VehiclesModel vehicleInfo = new VehiclesModel();
// DataTable dt = Data.Vehicles.GetVehicleDetailedList(VehicleId);
//if (ds.Tables.Count > 0)
//{
dt = ds.Tables[0];
dt1 = ds.Tables[1];
dt2 = ds.Tables[2];
dt3 = ds.Tables[3];
if (dt.Rows.Count > 0)
{
userInfo.UserId = (dt.Rows[0]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserId"]);
userInfo.Email = (dt.Rows[0]["Email"] == DBNull.Value ? "" : dt.Rows[0]["Email"].ToString());
userInfo.Name = (dt.Rows[0]["Name"] == DBNull.Value ? "" : dt.Rows[0]["Name"].ToString());
userInfo.PhoneNumber = (dt.Rows[0]["PhoneNumber"] == DBNull.Value ? "" : dt.Rows[0]["PhoneNumber"].ToString());
userInfo.IsEmailVerified = (dt.Rows[0]["IsEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsEmailVerified"]);
userInfo.IsPhoneNumVerified = (dt.Rows[0]["IsPhoneNumVerified"] == DBNull.Value ? false : (bool)dt.Rows[0]["IsPhoneNumVerified"]);
userInfo.LocationID = (dt.Rows[0]["LocationID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["LocationID"]);
userInfo.LocationLatitude = (dt.Rows[0]["LocationLatitude"] == DBNull.Value ? "-" : dt.Rows[0]["LocationLatitude"].ToString());
userInfo.LocationLongitude = (dt.Rows[0]["LocationLongitude"] == DBNull.Value ? "-" : dt.Rows[0]["LocationLongitude"].ToString());
userInfo.LocationFullAddress = (dt.Rows[0]["LocationFullAddress"] == DBNull.Value ? "" : dt.Rows[0]["LocationFullAddress"].ToString());
vehicleInfo.VehicleId = (dt.Rows[0]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["VehicleId"]);
vehicleInfo.UserId = (dt.Rows[0]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserId"]);
vehicleInfo.Make = (dt.Rows[0]["Make"] == DBNull.Value ? "" : dt.Rows[0]["Make"].ToString());
vehicleInfo.Model = (dt.Rows[0]["Model"] == DBNull.Value ? "" : dt.Rows[0]["Model"].ToString());
vehicleInfo.Year = (dt.Rows[0]["Year"] == DBNull.Value ? 0 :(int)dt.Rows[0]["Year"]);
vehicleInfo.Color = (dt.Rows[0]["Color"] == DBNull.Value ? "" : dt.Rows[0]["Color"].ToString());
vehicleInfo.LicencePlate = (dt.Rows[0]["LicensePlate"] == DBNull.Value ? "" : dt.Rows[0]["LicensePlate"].ToString());
vehicleInfo.VehicleImageURL = (dt.Rows[0]["VehicleImageURL"] == DBNull.Value ? "" : dt.Rows[0]["VehicleImageURL"].ToString());
if (dt2.Rows.Count > 0)
{
// planInfo.PlanType = (dt.Rows[0]["PlanType"] == DBNull.Value ? "" : dt.Rows[0]["PlanType"].ToString());
for (int i = 0; i < dt2.Rows.Count; i++)
{
PlanInfo planInfo1 = new PlanInfo();
planInfo1.PlanType = (dt.Rows[0]["PlanType"] == DBNull.Value ? "" : dt.Rows[0]["PlanType"].ToString());
planInfo1.ServiceNameList = (dt2.Rows[i]["ServiceName"] == DBNull.Value ? "" : dt2.Rows[i]["ServiceName"].ToString());
planInfo1.ServiceDescription = (dt2.Rows[i]["ServiceDescription"] == DBNull.Value ? "" : dt2.Rows[i]["ServiceDescription"].ToString());
planInfoList.Add(planInfo1);
}
}
for (int i = 0; i < dt3.Rows.Count; i++)
{
ServiceInfo vechiles = new ServiceInfo();
//vechiles.UserId = (dt.Rows[i]["UserId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["UserId"]);
//vechiles.Email = (dt.Rows[i]["Email"] == DBNull.Value ? "" : dt.Rows[i]["Email"].ToString());
//vechiles.Name = (dt.Rows[i]["Name"] == DBNull.Value ? "" : dt.Rows[i]["Name"].ToString());
//vechiles.PhoneNumber = (dt.Rows[i]["PhoneNumber"] == DBNull.Value ? "" : dt.Rows[i]["PhoneNumber"].ToString());
//vechiles.LocationID = (dt.Rows[i]["LocationID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["LocationID"]);
//vechiles.LocationLatitude = (dt.Rows[i]["LocationLatitude"] == DBNull.Value ? "" : dt.Rows[i]["LocationLatitude"].ToString());
//vechiles.LocationLongitude = (dt.Rows[i]["LocationLongitude"] == DBNull.Value ? "" : dt.Rows[i]["LocationLongitude"].ToString());
//vechiles.LocationFullAddress = (dt.Rows[i]["LocationFullAddress"] == DBNull.Value ? "" : dt.Rows[i]["LocationFullAddress"].ToString());
//vechiles.IsDeleted = (dt.Rows[i]["IsDeleted"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsDeleted"]);
//vechiles.VehicleId = (dt.Rows[i]["VehicleId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["VehicleId"]);
//vechiles.Make = (dt.Rows[i]["Make"] == DBNull.Value ? "" : dt.Rows[i]["Make"].ToString());
//vechiles.Model = (dt.Rows[i]["Model"] == DBNull.Value ? "" : dt.Rows[i]["Model"].ToString());
//vechiles.Color = (dt.Rows[i]["Color"] == DBNull.Value ? "" : dt.Rows[i]["Color"].ToString());
//vechiles.LicensePlate = (dt.Rows[i]["LicensePlate"] == DBNull.Value ? "" : dt.Rows[i]["LicensePlate"].ToString());
//vechiles.VehicleImage = ((byte[])dt.Rows[i]["VehicleImage"]);
//vechiles.VehicleImageURL = (dt.Rows[0]["VehicleImageURL"] == DBNull.Value ? "" : dt.Rows[0]["VehicleImageURL"].ToString());
//vechiles.ServiceDescription = (dt.Rows[i]["ServiceDescription"] == DBNull.Value ? "" : dt.Rows[i]["ServiceDescription"].ToString());
//vechiles.PlanType = (dt.Rows[i]["PlanType"] == DBNull.Value ? "" : dt.Rows[i]["PlanType"].ToString());
vechiles.ServicePlanID = (dt.Rows[i]["ServicePlanID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePlanID"]);
vechiles.ServiceID = (dt.Rows[i]["ServiceID"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServiceID"]);
vechiles.ServiceName = (dt.Rows[1]["ServiceNameList"] == DBNull.Value ? "" : dt.Rows[1]["ServiceNameList"].ToString());
vechiles.ServiceAmount = (dt3.Rows[i]["Amount"] == DBNull.Value ? 00 : (decimal)dt3.Rows[i]["Amount"]);
//(dt.Rows[i]["IsEmailVerified"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsEmailVerified"]);
vechiles.RequestedServiceDate = (dt3.Rows[i]["RequestedServiceDate"] == DBNull.Value ? "" : dt3.Rows[i]["RequestedServiceDate"].ToString());
vechiles.RemainderMinutes = (dt.Rows[i]["RemainderMinutes"] == DBNull.Value ? 0 : (int)dt.Rows[i]["RemainderMinutes"]);
vechiles.ActualServiceDate = (dt.Rows[i]["ActualServiceDate"] == DBNull.Value ? "" : dt.Rows[i]["ActualServiceDate"].ToString());
vechiles.ServiceOutDate = (dt3.Rows[i]["ServiceOutDate"] == DBNull.Value ? "" : dt3.Rows[i]["ServiceOutDate"].ToString());
vechiles.Status = (dt3.Rows[i]["Status"] == DBNull.Value ? "" : dt3.Rows[i]["Status"].ToString());
vechiles.IsTeamsandConditionsAccepted = (dt.Rows[i]["IsTeamsandConditionsAccepted"] == DBNull.Value ? false : (bool)dt.Rows[i]["IsTeamsandConditionsAccepted"]);
vechiles.ServicePriceChartId = (dt.Rows[i]["ServicePriceChartId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["ServicePriceChartId"]);
vechiles.ScheduleID = (dt3.Rows[i]["ScheduleID"] == DBNull.Value ? 0 : (int)dt3.Rows[i]["ScheduleID"]);
vechiles.Comments = (dt3.Rows[i]["Comments"] == DBNull.Value ? "-" : dt3.Rows[i]["Comments"].ToString());
//vechiles.PaymentDetailId = (dt.Rows[i]["PaymentDetailId"] == DBNull.Value ? 0 : (int)dt.Rows[i]["PaymentDetailId"]);
//vechiles.PaymentType = (dt.Rows[i]["PaymentType"] == DBNull.Value ? "" : dt.Rows[i]["PaymentType"].ToString());
//vechiles.Amount = (dt.Rows[i]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[i]["Amount"]);
//vechiles.Promocode_ReducedAmount = (dt.Rows[i]["Promocode_ReducedAmount"] == DBNull.Value ? 00 : (decimal)dt.Rows[i]["Promocode_ReducedAmount"]);
//vechiles.PaymentDate = (dt.Rows[i]["PaymentDate"] == DBNull.Value ? "" : dt.Rows[i]["PaymentDate"].ToString());
//vechiles.PaymentStatus = (dt.Rows[i]["PaymentStatus"] == DBNull.Value ? "" : dt.Rows[i]["PaymentStatus"].ToString());
ServiceList.Add(vechiles);
}
if (dt1.Rows.Count > 0)
{
paymentinfo.PaymentDetailId = (dt.Rows[0]["PaymentDetailId"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PaymentDetailId"]);
paymentinfo.PaymentType = (dt.Rows[0]["PaymentType"] == DBNull.Value ? "" : dt.Rows[0]["PaymentType"].ToString());
paymentinfo.TotalAmount = (dt1.Rows[0]["TotalAmount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["TotalAmount"]);
paymentinfo.Paid = (dt.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[0]["Amount"]);
paymentinfo.Due = ((dt1.Rows[0]["TotalAmount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["TotalAmount"]) - (dt.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt.Rows[0]["Amount"]));
//(dt1.Rows[0]["Amount"] == DBNull.Value ? 00 : (decimal)dt1.Rows[0]["Amount"]);
paymentinfo.Promocode_ReducedAmount = (dt.Rows[0]["Promocode_ReducedAmount"] == DBNull.Value ? "" : dt.Rows[0]["Promocode_ReducedAmount"].ToString());
paymentinfo.PaymentDate = (dt.Rows[0]["PaymentDate"] == DBNull.Value ? "" : dt.Rows[0]["PaymentDate"].ToString());
paymentinfo.PaymentStatus = (dt.Rows[0]["PaymentStatus"] == DBNull.Value ? "" : dt.Rows[0]["PaymentStatus"].ToString());
}
return(StatusCode((int)HttpStatusCode.OK, new { userInfo, vehicleInfo, planInfoList, ServiceList, paymentinfo }));
}
else
{
string[] data = new string[0];
return(StatusCode((int)HttpStatusCode.OK, data));
// return StatusCode((int)HttpStatusCode.OK, new { });
}
//}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("VehicleDetailsList", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } }));
}
}
public static int SaveVehicle(VehiclesModel model)
{
return(MembersDAL.SaveVehicle(model));
}
public void InsertIntoVehicleRecordProperties(VehiclesModel vehicles, decimal id)
{
_vehicleRepository.InsertIntoVehicleRecordProperties(vehicles, id);
}
public static int UpdateVehicle(VehiclesModel model)
{
return(MembersDAL.UpdateVehicle(model));
}
public IActionResult SaveVehicle([FromBody] VehiclesModel vehiclemodel) //int VehicleId, int UserId, string Make, string Model, int Year, string Color, string LicensePlate, string SpecialNotes
{
//string GetConnectionString = VehiclesController.GetConnectionString();
string Action = "Add";
try
{
if (vehiclemodel.VehicleImage != null && vehiclemodel.VehicleImage.Length > 0)
{
if (vehiclemodel.ImageType == "")
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } }));
}
else
{
vehiclemodel.VehicleImageURL = AzureStorage.UploadImage(vehiclemodel.VehicleImage, Guid.NewGuid() + "." + vehiclemodel.ImageType, "vehicleimages").Result;
}
}
if (vehiclemodel.LicencePlate == "")
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } }));
}
else if (vehiclemodel.UserId <= 0)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } }));
}
// string Results = SaveUpdateVehicle(vehiclemodel, Action);
string Results = SaveUpdateVehicle(vehiclemodel, Action);
if (Results != "Error Updating the Vehicle")
{
int VehicleId = Convert.ToInt32(Results);
return(StatusCode((int)HttpStatusCode.OK, new { VehicleId, message = vehiclemodel.LicencePlate + " is saved successfully" }));
}
else //if (Results == "Error Updating the Vehicle")
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } }));
}
//if (Results == "Please enter LicensePlate")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter LicensePlate" } });
//}
//else if (Results == "Please enter Image Type")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Image Type" } });
//}
//else if (Results == "Success")
//{
// return StatusCode((int)HttpStatusCode.OK, "Saved Successfully");
//}
//else if (Results == "Please enter UserId")
//{
// return StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter UserId" } });
//}
//else //if (Results == "Error Updating the Vehicle")
//{
// return StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Vehicle not saved" } });
//}
}
catch (Exception e)
{
if (e.Message.Contains("UNIQUE KEY constraint") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "LicensePlate is already exists" } }));
}
else
{
string SaveErrorLog = Data.Common.SaveErrorLog("SaveVehicle", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message.ToString() } }));
}
}
}
