public int Insert(VehicleItem model, PetrolCardItem model1)
{
try
{
Mapper.CreateMap <VehicleItem, VehicleMaster>();
VehicleMaster objVehicle = Mapper.Map <VehicleMaster>(model);
DbContext.VehicleMasters.Add(objVehicle);
DbContext.SaveChanges();
int Vid = DbContext.VehicleMasters.Max(item => item.VID);
if (Vid != null || Vid != '0')
{
model1.VID = Vid;
model1.Status = "Active";
Mapper.CreateMap <PetrolCardItem, Petrol_Card>();
Petrol_Card objPetrol = Mapper.Map <Petrol_Card>(model1);
DbContext.Petrol_Card.Add(objPetrol);
return(DbContext.SaveChanges());
}
return(DbContext.VehicleMasters.Max(item => item.VID));
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="id"></param>
/// <param name="vehicleItem"></param>
public void Put(int id, [FromBody] VehicleItem vehicleItem)
{
var readPreference = new ReadPreference(ReadPreferenceMode.SecondaryPreferred);
MongoDatabaseSettings mdSetting = new MongoDatabaseSettings();
mdSetting.ReadPreference = readPreference;
var connectionString = ConfigurationManager.AppSettings["dbCon"];
var database = ConfigurationManager.AppSettings["dbName"];
MongoClient client = new MongoClient(connectionString); //连接mogodb数据库
IMongoDatabase db = client.GetDatabase(database, mdSetting); //数据库
List <WriteModel <BsonDocument> > requests = new List <WriteModel <BsonDocument> >();
BsonDocument query = new BsonDocument("citycode", id);
//var update = new BsonDocument() { { "$set", BsonDocumentWrapper.Create(new { citycode = vehicleItem.citycode , speed = vehicleItem.speed}) } };
var update = new BsonDocument()
{
{ "$set", BsonDocumentWrapper.Create(vehicleItem) }
};
//requests.Add(new UpdateOneModel<BsonDocument>(query, update) { IsUpsert = true });//存在则更新，不存在则新增,更新单个符合查询条件的数据
requests.Add(new UpdateManyModel <BsonDocument>(query, update)
{
IsUpsert = true
}); //存在则更新，不存在则新增，更新多个符合查询条件的数据
if (requests.Count > 0)
{
db.GetCollection <BsonDocument>("tblCrud").BulkWrite(requests);
}
}
public static async Task Change(this VehicleItem vehicleItem, ApplicationDbContext db)
{
var oldVehicleItem = await db.VehicleItems.FirstOrDefaultAsync(
vi => vi.VehicleId.Equals(vehicleItem.OldVehicleId) &&
vi.ItemId.Equals(vehicleItem.OldItemId));
var newVehicleItem = await db.VehicleItems.FirstOrDefaultAsync(
vi => vi.VehicleId.Equals(vehicleItem.VehicleId) &&
vi.ItemId.Equals(vehicleItem.ItemId));
if (oldVehicleItem != null && newVehicleItem == null)
{
newVehicleItem = new VehicleItem
{
ItemId = vehicleItem.ItemId,
VehicleId = vehicleItem.VehicleId
};
using (var transaction = new TransactionScope(
TransactionScopeAsyncFlowOption.Enabled))
{
try
{
db.VehicleItems.Remove(oldVehicleItem);
db.VehicleItems.Add(newVehicleItem);
await db.SaveChangesAsync();
transaction.Complete();
}
catch
{ transaction.Dispose(); }
}
}
}
public ActionResult FillVData(string FID)
{
List <VehicleItem> lstVehicle = new List <VehicleItem>();
VehicleMasterService objVehicle = new VehicleMasterService();
int cid = 0;
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
lstVehicle = objVehicle.VehicleListData(FID, cid);
VehicleItem objVehicleItem = new VehicleItem();
objVehicleItem.ListVehicle = new List <VehicleItem>();
objVehicleItem.ListVehicle.AddRange(lstVehicle);
////string strCompCode = Convert.ToString(Compid);
//List<EmpAllItem> lstEmp = new List<EmpAllItem>();
//EmpAllItem objEmpItem = new EmpAllItem();
//EmployeeService objEmp = new EmployeeService();
//lstEmp = objEmp.GetALLDetails(FID);
//objEmpItem.EmployeeALLDetails = new List<EmpAllItem>();
////objBranchItem.ListBranch.Add(new BranchItem { id = 0, BranchName = "--Select Branch--" });
//objEmpItem.EmployeeALLDetails.AddRange(lstEmp);
//var e = new { BranchItem = objBranchItem.ListBranch, EmployeeItem = objBranchItem.ListBranch };
//return Json(objEmpItem.EmployeeALLDetails, JsonRequestBehavior.AllowGet);
return(PartialView("_Grid", objVehicleItem.ListVehicle));
}
public ActionResult getData(int id)
{
//string strCompCode = Convert.ToString(Compid);
//VehicleItem objmasterdata = new VehicleItem();
//List<VehicleItem> objmasterdatalst = new List<VehicleItem>();
//VehicleMasterService objmasterdatamethod = new VehicleMasterService();
//objmasterdatalst = objmasterdatamethod.GetById(id);
////objBranchItem.ListBranch.Add(new BranchItem { id = 0, BranchName = "--Select Branch--" });
////// objBranchItem.ListBranch.AddRange(lstBranch);
//objmasterdata.ListVehicle = new List<VehicleItem>();
//objmasterdata.ListVehicle.AddRange(objmasterdatalst);
//return PartialView("_DataList", objmasterdata.ListVehicle);
VehicleMasterService objmethod = new VehicleMasterService();
VehicleItem objVehicleItem = new VehicleItem();
List <VehicleItem> lstmasterp = new List <VehicleItem>();
lstmasterp = objmethod.getByIDVehicle(id);
objVehicleItem.ListVehicle = new List <VehicleItem>();
objVehicleItem.ListVehicle.AddRange(lstmasterp);
return(PartialView("_DataList", objVehicleItem.ListVehicle));
}
public async Task CreateVehicleAsync()
{
var vehicle = new VehicleItem()
{
};
await _vehicleRespository.AddAsync(vehicle);
}
public async Task <ActionResult> DeleteConfirmed(int itemId, int vehicleId)
{
VehicleItem vehicleItem = await GetVehicleItem(itemId, vehicleId);
db.VehicleItems.Remove(vehicleItem);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void CanGetVehicleDetails()
{
var repo = new VehicleRepositoryADO();
VehicleItem vehicle = repo.GetDetails(1);
Assert.AreEqual(1, vehicle.VehicleID);
Assert.AreEqual("Impreza", vehicle.ModelName);
Assert.AreEqual(4, vehicle.CarColor);
}
private void AddVehicle(int id, MigrationBuilder migrationBuilder, GetRequest <VehicleItem> client)
{
Console.WriteLine(id);
VehicleItem vehicle = client.GetById(id).GetAwaiter().GetResult();
migrationBuilder.InsertData(
table: "Vehicles",
columns: new string[] { "id", "name", "vehicle_class", "manufacturer", "length", "cost_in_credits", "crew", "passengers", "max_atmosphering_speed", "cargo_capacity", "consumables" },
values: new object[] { id, vehicle.name, vehicle.vehicle_class, vehicle.manufacturer, vehicle.length, vehicle.cost_in_credits, vehicle.crew, vehicle.passengers, vehicle.max_atmosphering_speed, vehicle.cargo_capacity, vehicle.consumables }
);
}
public ActionResult FillVehicle(int Compid)
{
int CompCode = Compid;
List<VehicleItem> lstVehicle = new List<VehicleItem>();
VehicleItem objVehicleItem = new VehicleItem();
VehicleMasterService objVehicle = new VehicleMasterService();
lstVehicle = objVehicle.GetVehicleByComp(CompCode);
objVehicleItem.ListVehicle = new List<VehicleItem>();
objVehicleItem.ListVehicle.AddRange(lstVehicle);
return Json(objVehicleItem.ListVehicle, JsonRequestBehavior.AllowGet);
}
public async Task <ActionResult> Create([Bind(Include = "VehicleId,ItemId")] VehicleItem vehicleItem)
{
if (ModelState.IsValid)
{
db.VehicleItems.Add(vehicleItem);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(vehicleItem));
}
public static async Task <bool> CanChange
(this VehicleItem vehicleItem, ApplicationDbContext db)
{
var oldVI = await db.VehicleItems.CountAsync(vi =>
vi.VehicleId.Equals(vehicleItem.OldVehicleId) &&
vi.ItemId.Equals(vehicleItem.OldItemId));
var newVI = await db.VehicleItems.CountAsync(vi =>
vi.VehicleId.Equals(vehicleItem.VehicleId) &&
vi.ItemId.Equals(vehicleItem.ItemId));
return(oldVI.Equals(1) && newVI.Equals(0));
}
public bool SaveItem(VehicleItem item)
{
var rowsAffected = database.Update(item);
if (rowsAffected == 0)
{
// The item does not exist in the database so lets insert it
rowsAffected = database.Insert(item);
}
var success = rowsAffected > 0;
return(success);
}
// GET: Admin/VehicleItem/Edit/5
public async Task <ActionResult> Edit(int?itemId, int?vehicleId)
{
if (itemId == null || vehicleId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VehicleItem vehicleItem = await GetVehicleItem(itemId, vehicleId);
if (vehicleItem == null)
{
return(HttpNotFound());
}
return(View(await vehicleItem.Convert(db)));
}
public async Task <ActionResult> Edit([Bind(Include = "VehicleId,ItemId,OldVehicleId,OldItemId")] VehicleItem vehicleItem)
{
if (ModelState.IsValid)
{
var canChange = await vehicleItem.CanChange(db);
if (canChange)
{
await vehicleItem.Change(db);
}
return(RedirectToAction("Index"));
}
return(View(vehicleItem));
}
public int Update(VehicleItem model, PetrolCardItem model1)
{
Mapper.CreateMap <VehicleItem, VehicleMaster>();
VehicleMaster objVehicle = DbContext.VehicleMasters.SingleOrDefault(m => m.VID == model.VID);
objVehicle = Mapper.Map(model, objVehicle);
DbContext.SaveChanges();
model1.VID = model.VID;
Mapper.CreateMap <PetrolCardItem, Petrol_Card>();
Petrol_Card objPetrol = DbContext.Petrol_Card.SingleOrDefault(m => m.VID == model1.VID);
objPetrol = Mapper.Map(model1, objPetrol);
return(DbContext.SaveChanges());
}
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
var townlist = (await _townService.GetAvailableTownsEagerAsync(HttpContext.User));
ViewData["TownList"] = new SelectList(townlist, "Id", "Name");
if (townlist.Any())
{
var groups = (await _groupService.ListGroupsForTownEagerAsync(HttpContext.User, townlist.First().Id));
ViewData["GroupList"] = new SelectList(groups, "Id", "Name");
}
return(Page());
}
var user = await _userManager.GetUserAsync(HttpContext.User);
var vehicle = _context.Vehicles.FirstOrDefault(v => v.Id == VehicleItem.Id);
if (vehicle == null)
{
return(NotFound());
}
await VehicleItem.FillVehicleItem(vehicle);
vehicle.FrontImage = VehicleItem.PhotoFront.UpdateUserFile(vehicle.FrontImage, _context, VisibilityType.CurrentVehicle, "车头部照片", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.RearImage = VehicleItem.PhotoRear.UpdateUserFile(vehicle.RearImage, _context, VisibilityType.CurrentVehicle, "车尾部照片", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.GpsImage = VehicleItem.PhotoGps.UpdateUserFile(vehicle.GpsImage, _context, VisibilityType.CurrentVehicle, "GPS照片", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.LicenseImage = VehicleItem.PhotoLicense.UpdateUserFile(vehicle.LicenseImage, _context, VisibilityType.CurrentVehicle, "行驶证照片", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.ExtraImage1 = VehicleItem.ExtraPhoto1.UpdateUserFile(vehicle.ExtraImage1, _context, VisibilityType.CurrentVehicle, "附加图片1", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.ExtraImage2 = VehicleItem.ExtraPhoto2.UpdateUserFile(vehicle.ExtraImage2, _context, VisibilityType.CurrentVehicle, "附加图片2", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.ExtraImage3 = VehicleItem.ExtraPhoto3.UpdateUserFile(vehicle.ExtraImage3, _context, VisibilityType.CurrentVehicle, "附加图片1", VehicleItem.TownId, VehicleItem.GroupId);
vehicle.ModifyBy = user.Id;
vehicle.ModificationDate = DateTime.Now;
vehicle.Status = StatusType.OK;
vehicle.VersionNumber += 1;
_context.Entry(vehicle).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(Redirect(Url.GetLocalUrl(ReturnUrl)));
}
//in the below convert method I take a vehicle item and conert it in to a vehicle item model using the application
//db context to fill the collections and use the vehicle item thats sent in to fill the item id and vehicle id properties
//and then return the model
public static async Task <VehicleItemModel> Convert(this VehicleItem vehicleItem, ApplicationDbContext db,
bool addListData = true)
{
var model = new VehicleItemModel
{
ItemId = vehicleItem.ItemId,
VehicleId = vehicleItem.VehicleId,
Items = addListData ? await db.Items.ToListAsync() : null,
Vehicles = addListData ? await db.Vehicles.ToListAsync() : null,
ItemTitle = (await db.Items.FirstOrDefaultAsync(i =>
i.Id.Equals(vehicleItem.ItemId))).Title,
VehicleTitle = (await db.Vehicles.FirstOrDefaultAsync(v =>
v.Id.Equals(vehicleItem.VehicleId))).Title
};
return(model);
}
public IEnumerable <VehicleItem> VehicleDetails()
{
List <VehicleItem> vehicles = new List <VehicleItem>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehicleDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleItem row = new VehicleItem();
row.VehicleID = (int)dr["VehicleID"];
row.VIN = dr["VIN"].ToString();
row.ModelID = (int)dr["ModelID"];
row.ModelName = dr["ModelName"].ToString();
row.MakeName = dr["MakeName"].ToString();
row.ConditionID = (int)dr["ConditionID"];
row.ConditionName = dr["ConditionName"].ToString();
row.VehicleTypeID = (int)dr["VehicleTypeID"];
row.VehicleTypeName = dr["VehicleTypeName"].ToString();
row.Year = dr["Year"].ToString();
row.TransmissionTypeID = (int)dr["TransmissionTypeID"];
row.TransmissionTypeName = dr["TransmissionTypeName"].ToString();
row.CarColor = (int)dr["CarColor"];
row.CarColorName = dr["Color"].ToString();
row.Interior = (int)dr["Interior"];
row.InteriorColorName = dr["Interior"].ToString();
row.Mileage = dr["Mileage"].ToString();
row.MSRP = (decimal)dr["MSRP"];
row.SalesPrice = (decimal)dr["SalesPrice"];
row.Description = dr["Description"].ToString();
row.Picture = dr["Picture"].ToString();
//row.Featured = (bool)dr["Featured"];
vehicles.Add(row);
}
}
}
return(vehicles);
}
private void Switch_Toggled(object sender, ToggledEventArgs e)
{
VehicleItem vehicleItem = new VehicleItem
{
Id = vehicle.Id,
HasBeenPurchased = e.Value
};
if (App.Database.SaveItem(vehicleItem))
{
DependencyService.Get <Toast>().Show("Data updated successfully");
vehicle.HasBeenPurchased = e.Value;
}
else
{
DependencyService.Get <Toast>().Show("Unable to update data");
}
}
public VehicleItem GetDetails(int vehicleId)
{
VehicleItem vehicle = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehicleDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleID", vehicleId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
vehicle = new VehicleItem();
vehicle.VehicleID = (int)dr["VehicleID"];
vehicle.VIN = dr["VIN"].ToString();
vehicle.ModelID = (int)dr["ModelID"];
vehicle.ModelName = dr["ModelName"].ToString();
vehicle.MakeName = dr["MakeName"].ToString();
vehicle.ConditionID = (int)dr["ConditionID"];
vehicle.ConditionName = dr["ConditionName"].ToString();
vehicle.VehicleTypeID = (int)dr["VehicleTypeID"];
vehicle.VehicleTypeName = dr["VehicleTypeName"].ToString();
vehicle.Year = dr["Year"].ToString();
vehicle.TransmissionTypeID = (int)dr["TransmissionTypeID"];
vehicle.TransmissionTypeName = dr["TransmissionTypeName"].ToString();
vehicle.CarColor = (int)dr["CarColor"];
vehicle.CarColorName = dr["Color"].ToString();
vehicle.Interior = (int)dr["Interior"];
vehicle.InteriorColorName = dr["InteriorColor"].ToString();
vehicle.Mileage = dr["Mileage"].ToString();
vehicle.MSRP = (decimal)dr["MSRP"];
vehicle.SalesPrice = (decimal)dr["SalesPrice"];
vehicle.Description = dr["Description"].ToString();
vehicle.Picture = dr["Picture"].ToString();
}
}
}
return(vehicle);
}
public VehicleItem GetDetails(int vehicleId)
{
VehicleItem vehicle = null;
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("VehicleSelectDetails", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleId", vehicleId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
vehicle = new VehicleItem();
vehicle.VehicleId = (int)dr["VehicleId"];
vehicle.Type = dr["Type"].ToString();
vehicle.BodyStyle = dr["BodyStyle"].ToString();
vehicle.Year = dr["Year"].ToString();
vehicle.Transmission = dr["Transmission"].ToString();
vehicle.Color = dr["Color"].ToString();
vehicle.Interior = dr["Interior"].ToString();
vehicle.Miles = dr["Miles"].ToString();
vehicle.Vin = dr["Vin"].ToString();
vehicle.Price = (decimal)dr["Price"];
vehicle.Msrp = (decimal)dr["Msrp"];
vehicle.Description = dr["Description"].ToString();
vehicle.Featured = (bool)dr["Featured"];
vehicle.MakeName = dr["MakeName"].ToString();
vehicle.ModelName = dr["ModelName"].ToString();
if (dr["ImageFileName"] != DBNull.Value)
{
vehicle.ImageFileName = dr["ImageFileName"].ToString();
}
}
}
}
return(vehicle);
}
public ActionResult VehicalReport()
{
ViewBag.Menuid = Request.QueryString["menuId"];
VehicleItem objAllItem = new VehicleItem();
ReportService objclsmethod = new ReportService();
int cid = 0;
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
List <VehicleItem> objMaster = objclsmethod.getvehicalDetails(cid);
objAllItem.ListVehicle = new List <VehicleItem>();
objAllItem.ListVehicle.AddRange(objMaster);
return(View("VehicalReport", objAllItem));
//return View();
}
public VehicleListViewModel(VehicleItem t = null)
{
if (t != null)
{
Id = t.Id;
Name = t.Name;
Brand = t.Brand;
Color = t.Color;
License = t.LicenceNumber;
LastRegisterDate = t.LastRegisterDate;
YearlyAuditDate = t.YearlyAuditDate;
AuditExpiredDate = t.AuditExpiredDate;
DriverName = t.Driver?.Name;
TownName = t.Town?.Name;
GroupName = t.Group?.Name;
Type = t.Type;
Usage = t.Usage;
IsValid = t.IsValid();
DumpDate = t.DumpDate;
}
}
public ActionResult FillEmp()
{
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
List <VehicleItem> lstVhcl = new List <VehicleItem>();
VehicleItem objVhclModel = new VehicleItem();
ChallanService objEmp = new ChallanService();
lstVhcl = objEmp.getVehicle(rid, cid);
objVhclModel.ListVehicle = new List <VehicleItem>();
objVhclModel.ListVehicle.AddRange(lstVhcl);
return(Json(objVhclModel.ListVehicle, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="vehicleItem"></param>
public void PostOne([FromBody] VehicleItem vehicleItem)
{
var readPreference = new ReadPreference(ReadPreferenceMode.SecondaryPreferred);
MongoDatabaseSettings mdSetting = new MongoDatabaseSettings();
mdSetting.ReadPreference = readPreference;
var connectionString = ConfigurationManager.AppSettings["dbCon"];
var database = ConfigurationManager.AppSettings["dbName"];
MongoClient client = new MongoClient(connectionString); //连接mogodb数据库
IMongoDatabase db = client.GetDatabase(database, mdSetting); //数据库
var vehicle = db.GetCollection <VehicleItem>("tblCrud"); //表
#region 创建或者更新 批量 似乎没有什么参考意义，但不建议删除
//List<WriteModel<BsonDocument>> requests = new List<WriteModel<BsonDocument>>();
//var key = new Random(Environment.TickCount).Next(100000, 999999);
//BsonDocument query = new BsonDocument("key", key);
//var update = new BsonDocument() { { "$set", BsonDocumentWrapper.Create(new { key = key }) } };
//requests.Add(new UpdateOneModel<BsonDocument>(query, update) { IsUpsert = true });//存在则更新，不存在则新增
//var update0 = new BsonDocument() { { "$addToSet",new BsonDocument() { {"111", BsonDocumentWrapper.Create(BsonDocument.Parse(JsonConvert.SerializeObject(vehicleItem))) } } } };
//requests.Add(new UpdateOneModel<BsonDocument>(query, update0) { IsUpsert = true });
////var update0 = new BsonDocument() { { "$addToSet", BsonDocumentWrapper.Create(BsonDocument.Parse(JsonConvert.SerializeObject(vehicleItem))) } };
////requests.Add(new UpdateOneModel<BsonDocument>(new BsonDocument(), update0) { IsUpsert = true });
//if (requests.Count > 0)
//{
// db.GetCollection<BsonDocument>("tblCrud").BulkWrite(requests);
//}
#endregion
vehicle.InsertOne(vehicleItem);
}
public async Task FillVehicleItem(VehicleItem vehicle)
{
vehicle.Name = this.Name;
vehicle.Brand = this.Brand;
vehicle.Color = this.Color;
vehicle.Comment = this.Comment;
vehicle.AuditExpiredDate = this.AuditExpiredDate;
vehicle.LicenceNumber = this.License;
vehicle.DumpDate = this.DumpDate;
vehicle.ProductionDate = this.ProductionDate;
vehicle.RealOwner = this.RealOwner;
vehicle.LastRegisterDate = this.RegisterDate;
vehicle.Type = this.Type;
vehicle.Usage = this.Usage;
vehicle.YearlyAuditDate = this.YearlyAuditDate;
vehicle.VehicleStatus = this.VehicleStatus;
vehicle.GroupId = this.GroupId;
vehicle.TownId = this.TownId;
vehicle.DriverId = this.DriverId;
vehicle.GpsEnabled = this.GpsEnabled;
vehicle.Agent = this.Agent;
}
public VehicleViewModel(VehicleItem vehicle)
{
OriginalModel = vehicle;
Id = vehicle.Id;
Brand = vehicle.Brand;
Color = vehicle.Color;
Comment = vehicle.Comment;
DriverId = vehicle.DriverId;
GroupId = vehicle.GroupId;
AuditExpiredDate = vehicle.AuditExpiredDate;
LastRegisterDate = vehicle.LastRegisterDate;
RegisterDate = vehicle.LastRegisterDate;
License = vehicle.LicenceNumber;
Name = vehicle.Name;
ProductionDate = vehicle.ProductionDate;
RealOwner = vehicle.RealOwner;
Type = vehicle.Type;
Usage = vehicle.Usage;
VehicleStatus = vehicle.VehicleStatus;
YearlyAuditDate = vehicle.YearlyAuditDate;
Agent = vehicle.Agent;
DumpDate = vehicle.DumpDate;
GroupName = vehicle.Group?.Name;
TownName = vehicle.Town?.Name;
DriverName = vehicle.Driver?.Name;
DriverTel = vehicle.Driver?.Tel;
PhotoLicenseBase64 = vehicle.LicenseImage.ToBase64String();
PhotoGpsBase64 = vehicle.GpsImage.ToBase64String();
PhotoFrontBase64 = vehicle.FrontImage.ToBase64String();
PhotoRearBase64 = vehicle.RearImage.ToBase64String();
ExtraPhoto1Base64 = vehicle.ExtraImage1.ToBase64String();
ExtraPhoto2Base64 = vehicle.ExtraImage2.ToBase64String();
ExtraPhoto3Base64 = vehicle.ExtraImage3.ToBase64String();
}
public ActionResult Create()
{
//int Empid = 0;
//if (Url.RequestContext.RouteData.Values["id"].ToString() != null)
//{
// Empid = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
//}
int cid = 0;
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
List <VehicleItem> lstVehicle = new List <VehicleItem>();
VehicleMasterService objVehicle = new VehicleMasterService();
lstVehicle = objVehicle.VehicleListData("Active", cid);
VehicleItem objVehicleItem = new VehicleItem();
objVehicleItem.ListVehicle = new List <VehicleItem>();
objVehicleItem.ListVehicle.AddRange(lstVehicle);
List <VehicleTypeModel> lstVType = new List <VehicleTypeModel>();
lstVType = objVehicle.getActiveVType();
objVehicleItem.ListVType = new List <VehicleTypeModel>();
objVehicleItem.ListVType.AddRange(lstVType);
//#region Bind DropDown comp
List <CompanyItem> objCompany = new List <CompanyItem>();
CompanyService objListCompany = new CompanyService();
objCompany = objListCompany.GetALL();
objVehicleItem.ListCompany = new List <CompanyItem>();
objVehicleItem.ListCompany.AddRange(objCompany);
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
//#endregion
#region Bind DropDown Branch
List <BranchItem> lstBranch = new List <BranchItem>();
lstBranch = objVehicle.GetBranch();
objVehicleItem.ListBranch = new List <BranchItem>();
objVehicleItem.ListBranch.AddRange(lstBranch);
#endregion
#region Bind DropDown Emp
List <EmployeeItem> lstEmp = new List <EmployeeItem>();
lstEmp = objVehicle.GetEmp(cid);
objVehicleItem.ListEmp = new List <EmployeeItem>();
objVehicleItem.ListEmp.AddRange(lstEmp);
#endregion
PetrolCardService objPCard = new PetrolCardService();
PetrolCardItem objPCardItem = new PetrolCardItem();
#region DDL PaymentType
List <clsMasterData> lstMasters1 = new List <clsMasterData>();
lstMasters1 = objPCard.GetPaymentType();
objPCardItem.ListMaster = new List <clsMasterData>();
objPCardItem.ListMaster.AddRange(lstMasters1);
objVehicleItem.ListMasterTablePayment = objPCardItem.ListMaster;
#endregion
#region DDL PCardType
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objPCard.GetPCardType();
objPCardItem.ListMaster1 = new List <clsMasterData>();
objPCardItem.ListMaster1.AddRange(lstMasters);
objVehicleItem.ListMasterTableCard = objPCardItem.ListMaster1;
#endregion
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objVehicleItem));
}
public ActionResult View(int id)
{
VehicleMasterService objVService = new VehicleMasterService();
VehicleItem objVItem = new VehicleItem();
List <VehicleItem> lstVItem = new List <VehicleItem>();
objVItem = objVService.GetById(id);
//Session["Empid"] = objPassItem.EmpId;
objVItem.ListVehicle = new List <VehicleItem>();
objVItem.ListVehicle.AddRange(lstVItem);
List <VehicleTypeModel> lstVType = new List <VehicleTypeModel>();
lstVType = objVService.getActiveVType();
objVItem.ListVType = new List <VehicleTypeModel>();
objVItem.ListVType.AddRange(lstVType);
//Bind Doc Grid
List <VehicleDocumentItem> ListVehicle = new List <VehicleDocumentItem>();
ListVehicle = objVService.getVehicleDoc(id);
objVItem.ListVehicleDocument = new List <VehicleDocumentItem>();
objVItem.ListVehicleDocument.AddRange(ListVehicle);
List <CompanyItem> objCompany = new List <CompanyItem>();
CompanyService objListCompany = new CompanyService();
objCompany = objListCompany.GetALL();
objVItem.ListCompany = new List <CompanyItem>();
objVItem.ListCompany.AddRange(objCompany);
int cid = 0;
if (Session["CompID"] != null)
{
cid = Convert.ToInt32(Session["CompID"].ToString());
}
#region Bind DropDown Emp
List <EmployeeItem> lstEmp = new List <EmployeeItem>();
lstEmp = objVService.GetEmp(cid);
objVItem.ListEmp = new List <EmployeeItem>();
objVItem.ListEmp.AddRange(lstEmp);
#endregion
#region Bind DropDown Branch
List <BranchItem> lstBranch = new List <BranchItem>();
lstBranch = objVService.GetBranch();
objVItem.ListBranch = new List <BranchItem>();
objVItem.ListBranch.AddRange(lstBranch);
#endregion
PetrolCardService objPCard = new PetrolCardService();
PetrolCardItem objPCardItem = new PetrolCardItem();
#region DDL PaymentType
List <clsMasterData> lstMasters1 = new List <clsMasterData>();
lstMasters1 = objPCard.GetPaymentType();
objPCardItem.ListMaster = new List <clsMasterData>();
objPCardItem.ListMaster.AddRange(lstMasters1);
objVItem.ListMasterTablePayment = objPCardItem.ListMaster;
#endregion
#region DDL PCardType
List <clsMasterData> lstMasters = new List <clsMasterData>();
lstMasters = objPCard.GetPCardType();
objPCardItem.ListMaster1 = new List <clsMasterData>();
objPCardItem.ListMaster1.AddRange(lstMasters);
objVItem.ListMasterTableCard = objPCardItem.ListMaster1;
#endregion
ViewBag.Menuid = Request.QueryString["menuId"];
var aa = ViewBag.Menuid;
return(View(objVItem));
}
