public List <VehicleMaster> VehicleMaster_Update(VehicleMaster input)
{
List <VehicleMaster> listArea = new List <VehicleMaster>();
using (MySqlDataReader reader = ExecuteDataReader("VehicleMaster_InsertUpdateDelete",
CreateParameter("VehicleId_", MySqlDbType.Int32, input.VehicleId),
CreateParameter("VehicleTypeId_", MySqlDbType.Int32, input.VehicleTypeId),
CreateParameter("CompanyId_", MySqlDbType.Int32, input.CompanyId),
CreateParameter("PurchaseDate_", MySqlDbType.DateTime, input.PurchaseDate),
CreateParameter("VehicleNo_", MySqlDbType.VarChar, input.VehicleNo),
CreateParameter("Color_", MySqlDbType.VarChar, input.Color),
CreateParameter("Type_", MySqlDbType.Int32, 2)))
{
while (reader.Read())
{
VehicleMaster obj = new VehicleMaster();
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleId = Convert.ToInt32(reader["VehicleId"].ToString());
obj.CompanyId = Convert.ToInt32(reader["CompanyId"].ToString());
obj.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]);
obj.VehicleNo = reader["VehicleNo"].ToString();
obj.Color = reader["Color"].ToString();
obj.IsActive = Convert.ToBoolean(reader["IsActive"]);
listArea.Add(obj);
}
}
return(listArea);
}
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;
}
}
public ActionResult DeleteConfirmed(int id)
{
VehicleMaster vehiclemaster = db.VehicleMasters.Find(id);
db.VehicleMasters.Remove(vehiclemaster);
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully Deleted Vehicle.";
return(RedirectToAction("Index"));
}
public VehicleMaster Update(VehicleMaster VM, string userid)
{
var sqlQuery =
string.Format(@"UPDATE VEHICLE SET IDVEHICLE = '{0}', VEHICLENAME = '{1}', VEHICLEGROUP = '{2}', OWNERSHIP = '{3}', FIXEDASSET = '{4}', PURCHASEDATE = '{5}', PURCHASECOST = '{6}', ISACTIVE = '{7}', ISACTIVEDATE = '{8}', COMPANYSITE = '{9}', UPDATEBY = {10}, UPDATEDATE = '{11}' WHERE SID = {12}",
VM.IDVEHICLE, VM.VEHICLENAME, VM.VEHICLEGROUP, VM.OWNERSHIP, VM.FIXEDASSET, VM.PURCHASEDATE, VM.PURCHASECOST, VM.ISACTIVE, VM.ISACTIVEDATE, VM.COMPANYSITE, Convert.ToInt32(userid), DateTime.Now, VM.SID);
this._db.Execute(sqlQuery, VM);
return(VM);
}
public VehicleMaster Add(VehicleMaster VM, string userid)
{
var sqlQuery = @"INSERT INTO VEHICLE (IDVEHICLE, VEHICLENAME, VEHICLEGROUP, OWNERSHIP, FIXEDASSET, PURCHASEDATE, PURCHASECOST, ISACTIVE, ISACTIVEDATE, COMPANYSITE, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES
('" + VM.IDVEHICLE + @"', '" + VM.VEHICLENAME + "', '" + VM.VEHICLEGROUP + "', '" + VM.OWNERSHIP + "', '" + VM.FIXEDASSET + "', '" + VM.PURCHASEDATE + "', '" + VM.PURCHASECOST + "', '" + VM.ISACTIVE + "', '" + VM.ISACTIVEDATE + "', '" + VM.COMPANYSITE + "', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)";
var SID = _db.Query <int>(sqlQuery, VM).Single();
VM.SID = SID;
return(VM);
}
//
// GET: /VehicleMaster/Details/5
public ActionResult Details(int id = 0)
{
VehicleMaster vehiclemaster = db.VehicleMasters.Find(id);
if (vehiclemaster == null)
{
return(HttpNotFound());
}
return(View(vehiclemaster));
}
//
// GET: /Vehicle/Create
public ActionResult Create()
{
var model = new VehicleMaster();
model.ISACTIVE = true;
model.GetSelectListVehicleGroup = GetSelectListVehicleGroup();
model.GetSelectListFixedAsset = GetSelectListFixedAsset();
model.GetSelectListOwnership = GetSelectListOwnership();
return(View(model));
}
public bool SaveVehicleMaster(VehicleMasterModel model)
{
try
{
VehicleMaster master = new VehicleMaster();
master.vehiclecategory = model.vehiclecategory;
master.vehicleNo = model.vehicleNo;
master.vehicleType = model.vehicleType;
master.manufacturer = model.manufacturer;
master.vehiclemodel = model.vehiclemodel;
master.yearofmanufacturing = model.yearofmanufacturing;
master.GPSID = model.GPSID;
master.drivername = model.drivername;
master.ownerdetails = model.ownerdetails;
master.chassisNo = model.chassisNo;
master.engineNo = model.engineNo;
master.trollychassisNo = model.trollychassisNo;
master.fueltankCapacity = model.fueltankCapacity;
master.vehicleweightinMT = model.vehicleweightinMT;
master.unladenweightinMT = model.unladenweightinMT;
master.vehicleCapacity = model.vehicleCapacity;
master.wheelbaseinMM = model.wheelbaseinMM;
master.lengthinFt = model.lengthinFt;
master.widthinft = model.widthinft;
master.heightinft = model.heightinft;
master.powerinCC = model.powerinCC;
master.paintCode = model.paintCode;
master.paintColour = model.paintColour;
master.ignitionkey = model.ignitionkey;
master.doorkeycode = model.doorkeycode;
master.bankfanainstuName = model.bankfanainstuName;
master.loanaccountNo = model.loanaccountNo;
master.fileUpload = model.fileUpload;
master.wheelsize = model.wheelsize;
master.tyresize = model.tyresize;
master.psi = model.psi;
master.registrationDate = model.registrationDate;
master.fitnessDate = model.fitnessDate;
master.permitfromdate = model.permitfromdate;
master.insurancefromdate = model.insurancefromdate;
//master.fileuploadimage = model.fileuploadimage;
master.isActive = true;
tRSEntities4.VehicleMasters.Add(master);
tRSEntities4.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
public HttpResponseMessage AmendVehicleStatus(VehicleMaster objVehicleMaster, string Token, string AppKey)
{
string strJson = string.Empty;
var response = this.Request.CreateResponse(HttpStatusCode.OK);
try
{
Accountmeg objaccountmegment = new Accountmeg();
string result = objaccountmegment.Getresult(AppKey, Token);
if (result == "true")
{
using (TTPAPIDataContext DB = new TTPAPIDataContext())
{
var objVehicleMasters = DB.VehicleMasters.Where(x => x.AccountId == objVehicleMaster.AccountId).FirstOrDefault();
if (objVehicleMasters != null)
{
VehicleMaster objvehicaldata = new VehicleMaster();
objVehicleMasters.IsActive = false;
// DB.VehicleMasters.InsertOnSubmit(objVehicleMasters);
DB.SubmitChanges();
strJson = "{\"Result\":\"204\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
else
{
strJson = "{\"Result\":\"100\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
}
else
{
strJson = "{\"Result\":\"Invalide AppKey\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
catch (Exception ex)
{
strJson = "{\"Result\":\"" + ex.Message + "\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
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 HttpResponseMessage CreateVehicle(VehicleMaster objVehicleMaster, string Token, string AppKey)
{
string strJson = string.Empty;
var response = this.Request.CreateResponse(HttpStatusCode.OK);
try
{
Accountmeg objaccountmegment = new Accountmeg();
string result = objaccountmegment.Getresult(AppKey, Token);
if (result == "true")
{
using (TTPAPIDataContext DB = new TTPAPIDataContext())
{
VehicleMaster objVehicleMasters = new VehicleMaster();
objVehicleMasters.AccountId = objVehicleMaster.AccountId;
objVehicleMasters.VehicleID = objVehicleMaster.VehicleID;
objVehicleMasters.VehicleRegNo = objVehicleMaster.VehicleRegNo;
objVehicleMasters.Make = objVehicleMaster.Make;
objVehicleMasters.AccountId = objVehicleMaster.AccountId;
objVehicleMasters.IsActive = true;
DB.VehicleMasters.InsertOnSubmit(objVehicleMasters);
DB.SubmitChanges();
strJson = "{\"Result\":\"204\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
else
{
strJson = result;
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
catch (Exception ex)
{
strJson = "{\"Result\":\"" + ex.Message + "\"}";
response.Content = new StringContent(strJson, Encoding.UTF8, "application/json");
return(response);
}
}
public ActionResult Edit(VehicleMaster vehicle)
{
if (ModelState.IsValid)
{
vehicle.COMPANYSITE = int.Parse(Session["companysite"].ToString());
vehicle.ISACTIVEDATE = DateTime.Now;
vehicle.UPDATEDATE = DateTime.Now;
VM.Update(vehicle, Session["userid"].ToString());
TempData["successmessage"] = "Saved successfully";
return(RedirectToAction("Index"));
}
else
{
vehicle.GetSelectListVehicleGroup = GetSelectListVehicleGroup();
vehicle.GetSelectListFixedAsset = GetSelectListFixedAsset();
vehicle.GetSelectListOwnership = GetSelectListOwnership();
return(View(vehicle));
}
}
public VehicleMaster VehicleMaster_Retrieve(int id)
{
VehicleMaster obj = new VehicleMaster();
using (MySqlDataReader reader = ExecuteDataReader("VehicleMaster_Retrieve",
CreateParameter("VehicleId_", MySqlDbType.Int32, id)
))
{
while (reader.Read())
{
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleId = Convert.ToInt32(reader["VehicleId"].ToString());
obj.CompanyId = Convert.ToInt32(reader["CompanyId"].ToString());
obj.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]);
obj.VehicleNo = reader["VehicleNo"].ToString();
obj.Color = reader["Color"].ToString();
obj.IsActive = Convert.ToBoolean(reader["IsActive"]);
}
}
return(obj);
}
public VehicleMaster[] GetVehicle()
{
DataTable dt = new DataTable();
VehicleMaster[] vehicleMasters;
Query = "exec proc_GetVehicle";
dt = caObjects.ExecuteQueryReturnDataTable(Query);
vehicleMasters = new VehicleMaster[dt.Rows.Count];
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
VehicleMaster vehicleMaster = new VehicleMaster();
vehicleMaster.vm_Vehicle_Id = Convert.ToInt32(dt.Rows[i]["vm_Vehicle_Id"]);
vehicleMaster.vm_Vehicle_Number = Convert.ToString(dt.Rows[i]["vm_Vehicle_Number"]);
vehicleMaster.vm_Vehicle_desc = Convert.ToString(dt.Rows[i]["vm_Vehicle_desc"]);
vehicleMaster.vm_Status = Convert.ToBoolean(dt.Rows[i]["vm_Status"]);
// vehicleMaster.vm_user = Convert.ToInt32(dt.Rows[i]["vm_user"]);
vehicleMasters[i] = vehicleMaster;
}
return(vehicleMasters);
}
public List <VehicleMaster> VehicleMaster_RetrieveAll()
{
List <VehicleMaster> listArea = new List <VehicleMaster>();
using (MySqlDataReader reader = ExecuteDataReader("VehicleMaster_Retrieve",
CreateParameter("VehicleId_", MySqlDbType.Int32, -1)
))
{
while (reader.Read())
{
VehicleMaster obj = new VehicleMaster();
obj.VehicleTypeId = Convert.ToInt32(reader["VehicleTypeId"]);
obj.VehicleId = Convert.ToInt32(reader["VehicleId"].ToString());
obj.CompanyId = Convert.ToInt32(reader["CompanyId"].ToString());
obj.PurchaseDate = Convert.ToDateTime(reader["PurchaseDate"]);
obj.VehicleNo = reader["VehicleNo"].ToString();
obj.Color = reader["Color"].ToString();
obj.IsActive = Convert.ToBoolean(reader["IsActive"]);
listArea.Add(obj);
}
}
return(listArea);
}
public async Task <int> CreateVehicle(VehicleMaster vehicleMaster)
{
Int32 i = await _httpClient.PostJsonAsync <Int32>("api/VehicleMaster/CreateVehicle", vehicleMaster);
return(i);
}
public int CreateVehicle(VehicleMaster vehicleMaster)
{
Query = "exec proc_Vehicle_Master '" + vehicleMaster.vm_Vehicle_Id + "','" + vehicleMaster.vm_Vehicle_Number + "','" + vehicleMaster.vm_Vehicle_desc + "','" + vehicleMaster.vm_Status + "','" + vehicleMaster.vm_user + "'";
return(Convert.ToInt32(caObjects.ExecuteQuery(Query)));
}
public int CreateVehicle(VehicleMaster vehicleMaster)
{
return(_clsAccessVehiclemaster.CreateVehicle(vehicleMaster));
}
/// <summary>
/// Method to add vehicle master - SS
/// </summary>
/// <param name="addVehicleMaster">vehicle detail</param>
/// <param name="loggedInUser">logged in user</param>
/// <returns>response</returns>
public async Task <VehicleMasterManagementResponse> AddVehicleMasterAsync(AddVehicleMasterManagementAc addVehicleMaster,
ApplicationUser loggedInUser)
{
if (string.IsNullOrEmpty(addVehicleMaster.VehicleCode) && string.IsNullOrEmpty(addVehicleMaster.VehicleCode.Trim()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Vehicle code can't be empty", ErrorType = VehicleMasterManagementResponseType.VehicleCode
}
}
;
else if (string.IsNullOrEmpty(addVehicleMaster.VehicleType) && string.IsNullOrEmpty(addVehicleMaster.VehicleType.Trim()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Vehicle type can't be empty", ErrorType = VehicleMasterManagementResponseType.VehicleType
}
}
;
else if (string.IsNullOrEmpty(addVehicleMaster.FuelType) && string.IsNullOrEmpty(addVehicleMaster.FuelType.Trim()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Fuel type can't be empty", ErrorType = VehicleMasterManagementResponseType.FuelType
}
}
;
else if (string.IsNullOrEmpty(addVehicleMaster.VehicleRegistrationNumber) && string.IsNullOrEmpty(addVehicleMaster.VehicleRegistrationNumber.Trim()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Vehicle registration number can't be empty", ErrorType = VehicleMasterManagementResponseType.VehicleRegistrationNumber
}
}
;
else if (string.IsNullOrEmpty(addVehicleMaster.EngineNumber) && string.IsNullOrEmpty(addVehicleMaster.EngineNumber.Trim()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Engine number can't be empty", ErrorType = VehicleMasterManagementResponseType.EngineNumber
}
}
;
else
{
var instituteId = await _instituteUserMappingHelperService.GetUserCurrentSelectedInstituteIdAsync(loggedInUser.Id, true);
if (await _iMSDbContext.VehicleMasters.AnyAsync(x => x.InstituteId == instituteId && x.VehicleCode.ToLowerInvariant() == addVehicleMaster.VehicleCode.ToLowerInvariant()))
{
return new VehicleMasterManagementResponse()
{
HasError = true, Message = "Vehicle code already exist. Please use unique one", ErrorType = VehicleMasterManagementResponseType.VehicleCode
}
}
;
else
{
var vehicle = new VehicleMaster()
{
AverageKMPL = addVehicleMaster.AverageKMPL,
ChasisNumber = addVehicleMaster.ChasisNumber,
CreatedOn = DateTime.UtcNow,
EngineNumber = addVehicleMaster.EngineNumber,
ExtraFittings = addVehicleMaster.ExtraFittings,
FitnessExpDate = addVehicleMaster.FitnessExpDate,
FuelType = EnumHelperService.GetValueFromDescription <VehicleMasterFuelTypeEnum>(addVehicleMaster.FuelType),
InstituteId = instituteId,
InsuranceDate = addVehicleMaster.InsuranceDate,
InsuranceExpDate = addVehicleMaster.InsuranceExpDate,
InsuranceNumber = addVehicleMaster.InsuranceNumber,
NextMaintenanceDate = addVehicleMaster.NextMaintenanceDate,
PermitValidityDate = addVehicleMaster.PermitValidityDate,
UpdatedById = loggedInUser.Id,
UpdatedOn = DateTime.UtcNow,
VehicleCode = addVehicleMaster.VehicleCode,
VehicleRegistrationNumber = addVehicleMaster.VehicleRegistrationNumber,
VehicleType = EnumHelperService.GetValueFromDescription <VehicleMasterTypeEnum>(addVehicleMaster.VehicleType)
};
_iMSDbContext.VehicleMasters.Add(vehicle);
await _iMSDbContext.SaveChangesAsync();
return(new VehicleMasterManagementResponse()
{
HasError = false, Message = "Vehicle added successfully", Data = new { Id = vehicle.Id }
});
}
}
}
public ActionResult Create(VehiclesVM vm)
{
int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int depotId = Convert.ToInt32(Session["CurrentDepotID"].ToString());
int companyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
VehicleMaster v = new VehicleMaster();
int?max = (from d in db.VehicleMasters orderby d.VehicleID descending select d.VehicleID).FirstOrDefault();
if (vm.VehicleID == 0)
{
if (max == null)
{
v.VehicleID = 1;
}
else
{
v.VehicleID = Convert.ToInt32(max) + 1;
}
}
else
{
v = db.VehicleMasters.Find(vm.VehicleID);
}
//v.SupplierTypeID = vm.SupplierTypeId;
v.SupplierID = vm.SupplierID;
//v.DriverID = vm.DriverID;
v.VehicleDescription = vm.VehicleDescription;
v.RegistrationNo = vm.RegistrationNo;
v.Model = vm.Model;
v.Category = vm.Category;
v.PurchaseValue = vm.PurchaseValue;
v.PurchaseDate = vm.PurchaseDate;
v.InsuranceExpDate = vm.InsuranceExpDate;
v.DepreciationDate = vm.DepreciationDate;
v.RegExpirydate = vm.RegExpirydate;
//if (vm.PurchaseDate.Date.ToString() != "01-01-0001 00:00:00")
// v.PurchaseDate = vm.PurchaseDate;
//if (vm.InsuranceExpDate.Date.ToString() != "01-01-0001 00:00:00")
// v.InsuranceExpDate = vm.InsuranceExpDate;
//if (vm.RegExpirydate.Date.ToString() != "01-01-0001 00:00:00")
v.AcCompanyID = companyId;
v.Category = vm.Category;
v.RegistrationNo = vm.RegistrationNo;
//if (vm.DepreciationDate.Date.ToString() != "01-01-0001 00:00:00")
// v.DepreciationDate = vm.DepreciationDate;
v.ScrapValue = vm.ScrapValue;
v.BranchID = branchid;
v.InsuranceCompName = vm.InsuranceCompName;
v.PolicyNo = vm.PolicyNo;
v.InsuredValue = vm.InsuredValue;
v.Mode = vm.Mode;
v.FinanceCompany = vm.FinanceCompany;
v.VehicleTypeID = vm.VehicleTypeID;
v.RegisteredUnder = vm.RegisteredUnder;
v.MakeYear = vm.MakeYear;
v.AcheadId = vm.AcheadId;
v.ContractExpDate = vm.ContractExpDate;
v.ContractIssuedDate = vm.ContractIssuedDate;
v.ContractNo = vm.ContractNo;
v.ContractRate = vm.ContractRate;
v.FreeKM = vm.FreeKM;
v.RateExtraKM = vm.RateExtraKM;
v.VehicleMaintenance = vm.VehicleMaintenance;
v.VehicleOwner = vm.VehicleOwner;
if (vm.VehicleID == 0)
{
db.VehicleMasters.Add(v);
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully added Vehicle.";
return(RedirectToAction("Index"));
}
else
{
db.Entry(v).State = EntityState.Modified;
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully updated Vehicle.";
return(RedirectToAction("Index"));
}
}
public int CreateVehicle(VehicleMaster vehicleMaster)
{
return(_vehicleMaster.CreateVehicle(vehicleMaster));
}
