public string SaveUpdateVehicleTenanat(VehicleModel model, long UserId) { ShomaRMEntities db = new ShomaRMEntities(); string msg = ""; var applyNow = db.tbl_ApplyNow.Where(co => co.UserId == UserId).FirstOrDefault(); if (applyNow != null) { if (model.Vehicle_ID == 0) { var saveVehicle = new tbl_Vehicle() { VehicleRegistration = model.VehicleRegistration, OriginalVehicleReg = model.OriginalVehicleRegistation, Vehicle_ID = model.Vehicle_ID, TenantID = applyNow.ID, Make = model.Make, Model = model.VModel, Year = model.Year, Color = model.Color, License = model.License, State = model.State, OwnerName = model.OwnerName, Notes = model.Notes, VehicleType = model.VehicleType }; db.tbl_Vehicle.Add(saveVehicle); db.SaveChanges(); msg = "Vehicle Saved Successfully"; } else { var getVehdata = db.tbl_Vehicle.Where(p => p.Vehicle_ID == model.Vehicle_ID).FirstOrDefault(); if (getVehdata != null) { getVehdata.VehicleRegistration = model.VehicleRegistration; getVehdata.OriginalVehicleReg = model.OriginalVehicleRegistation; getVehdata.Vehicle_ID = model.Vehicle_ID; getVehdata.TenantID = applyNow.ID; getVehdata.Make = model.Make; getVehdata.Model = model.VModel; getVehdata.Year = model.Year; getVehdata.Color = model.Color; getVehdata.License = model.License; getVehdata.State = model.State; getVehdata.OwnerName = model.OwnerName; getVehdata.Notes = model.Notes; getVehdata.VehicleType = model.VehicleType; } db.SaveChanges(); msg = "Vehicle Updated Successfully"; } } db.Dispose(); return(msg); }
public string SaveUpdateVehicle(VehicleModel model) { ShomaRMEntities db = new ShomaRMEntities(); string msg = ""; int userid = ShomaRM.Models.ShomaGroupWebSession.CurrentUser != null ? ShomaRM.Models.ShomaGroupWebSession.CurrentUser.UserID : 0; var tenantProperty = db.tbl_ApplyNow.Where(p => p.ID == model.TenantID).FirstOrDefault(); var propertyUnit = db.tbl_PropertyUnits.Where(p => p.UID == tenantProperty.PropertyId).FirstOrDefault(); int? TotalSpace = 0; int? newAvailSpace = 0; if (tenantProperty != null) { if (propertyUnit != null) { if (propertyUnit.Bedroom == 1) { newAvailSpace = 1; } else if (propertyUnit.Bedroom == 2) { newAvailSpace = 1; } else if (propertyUnit.Bedroom == 3) { newAvailSpace = 2; } TotalSpace = tenantProperty.AdditionalParking + newAvailSpace; } } var availableList = db.tbl_Vehicle.Where(p => p.TenantID == model.TenantID).ToList(); if (availableList.Count < TotalSpace) { if (model.Vehicle_ID == 0) { var saveVehicle = new tbl_Vehicle() { VehicleRegistration = model.VehicleRegistration, OriginalVehicleReg = model.OriginalVehicleRegistation, Vehicle_ID = model.Vehicle_ID, TenantID = model.TenantID, Make = model.Make, Model = model.VModel, Year = model.Year, Color = model.Color, License = model.License, State = model.State, OwnerName = model.OwnerName, Notes = model.Notes, Tag = model.Tag, ParkingID = model.ParkingID, AddedBy = userid, VehicleType = model.VehicleType }; db.tbl_Vehicle.Add(saveVehicle); db.SaveChanges(); var ParkingInfo = db.tbl_Parking.Where(p => p.ParkingID == model.ParkingID).FirstOrDefault(); ParkingInfo.Status = 1; ParkingInfo.AddedBy = userid; db.SaveChanges(); msg = "Vehicle Saved Successfully"; } } else { msg = "You can not add Vehicle Due to Un-available Vehicle Space"; } if (model.Vehicle_ID != 0) { var getVehdata = db.tbl_Vehicle.Where(p => p.Vehicle_ID == model.Vehicle_ID).FirstOrDefault(); if (getVehdata != null) { getVehdata.VehicleRegistration = model.VehicleRegistration; getVehdata.OriginalVehicleReg = model.OriginalVehicleRegistation; getVehdata.Vehicle_ID = model.Vehicle_ID; getVehdata.TenantID = model.TenantID; getVehdata.Make = model.Make; getVehdata.Model = model.VModel; getVehdata.Year = model.Year; getVehdata.Color = model.Color; getVehdata.License = model.License; getVehdata.State = model.State; getVehdata.OwnerName = model.OwnerName; getVehdata.Notes = model.Notes; // getVehdata.Tag = model.Tag; getVehdata.ParkingID = model.ParkingID; getVehdata.VehicleType = model.VehicleType; } db.SaveChanges(); msg = "Vehicle Updated Successfully"; } db.Dispose(); return(msg); }