public ActionResult SaveBusDetail(SaveBusModel obj) { if (obj.busId > 0) { Gmou.BusinessAccessLayer.BusBAL.UpdateBusDeatils(obj); return(Json(new { statusCode = 200, status = "Save Sucessfully" }, JsonRequestBehavior.AllowGet)); } else { if (!BusinessAccessLayer.BusBAL.CheckIfBusAvailable(obj.bus_number)) { if (BusinessAccessLayer.BusBAL.AddBusRecords(obj)) { return(Json(new { statusCode = 200, status = "Save Sucessfully" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { statusCode = 500, status = "Some Error", }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { statusCode = 404, status = "Bus is already there", }, JsonRequestBehavior.AllowGet)); } } }
public static bool AddBusDetails(SaveBusModel model) { try { using (var item = new GMOUMISEntity()) { tblBu bs = new tblBu() { bus_number = model.bus_number, setid = model.setid }; item.tblBus.Add(bs); item.SaveChanges(); int id = bs.busid; //int id = Convert.ToInt32(item.tblBus.Select(m => m.busid).FirstOrDefault()); tblBusInsuranceDeatil businsurancedetails = new tblBusInsuranceDeatil() { bus_id = id, company_name = model.company_name, company_address = model.company_address, validity = model.validity }; item.tblBusInsuranceDeatils.Add(businsurancedetails); item.SaveChanges(); tblBusOwnerDetail busownerDetails = new tblBusOwnerDetail() { bus_owner_name = model.bus_owner_name, owner_father_name = model.owner_father_name, owner_address = model.owner_address, owner_contact_number = model.owner_contact_number, bus_id = id, entry_amount = model.entry_amount, entry_reciept_number = model.entry_reciept_number, payment_date = model.payment_date, security_amount = model.security_amount, security_money_reciept = model.security_money_reciept, remaining_amount = model.remaining_amount, gauranter1 = model.gauranter1, gauranter1_bus = model.gauranter1_bus, gauranter2 = model.gauranter2, gauranter2_bus = model.gauranter2_bus, building_fund = model.building_fund, old_bus_number = model.old_bus_number, old_bus_owner_name = model.old_bus_owner_name, previous_building_fund = model.previous_building_fund, emi = model.emi }; item.tblBusOwnerDetails.Add(busownerDetails); tblBusDetail busdetails = new tblBusDetail() { bus_id = id, bus_number = model.bus_number, bus_operating_center = model.bus_operating_center, chesis_number = model.chesis_number, engine_number = model.engine_number, fitness = model.fitness, last_modified_date = DateTime.Now, registration_date = model.registration_date, permit_number = model.permit_number, model = model.model, seats = model.seats, road_tax = model.road_tax, isDeleted = false, last_modified_by = "Admin", bus_registration_type = model.bus_registration_type, bus_registration_number = model.bus_registration_number }; item.tblBusDetails.Add(busdetails); item.SaveChanges(); } return(true); } catch (Exception ex) { string err = ex.Message; return(false); } }
public static bool UpdateBusDetails(SaveBusModel model) { try { using (var item = new GMOUMISEntity()) { var resulytblbus = item.tblBus.Single(c => c.busid == model.busId); resulytblbus.setid = model.setid; item.SaveChanges(); //int id = Convert.ToInt32(item.tblBus.Select(m => m.busid).FirstOrDefault()); // var busdetails = item.tblBusDetails.Single(c => c.bus_id == model.bus_id); //tblBusInsuranceDeatil businsurancedetails = new tblBusInsuranceDeatil() //{ var busInsurance = item.tblBusInsuranceDeatils.Single(c => c.bus_id == model.busId); busInsurance.company_name = model.company_name; busInsurance.company_address = model.company_address; busInsurance.validity = model.validity; item.SaveChanges(); //}; //item.tblBusInsuranceDeatils.Add(businsurancedetails); //item.SaveChanges(); var busOwner = item.tblBusOwnerDetails.Single(c => c.bus_id == model.busId); //tblBusOwnerDetail busownerDetails = new tblBusOwnerDetail() //{ busOwner.bus_owner_name = model.bus_owner_name; busOwner.owner_father_name = model.owner_father_name; busOwner.owner_address = model.owner_address; busOwner.owner_contact_number = model.owner_contact_number; busOwner.entry_reciept_number = model.entry_reciept_number; busOwner.entry_amount = model.entry_amount; busOwner.payment_date = model.payment_date; busOwner.security_amount = model.security_amount; busOwner.security_money_reciept = model.security_money_reciept; busOwner.remaining_amount = model.remaining_amount; busOwner.gauranter1 = model.gauranter1; busOwner.gauranter1_bus = model.gauranter1_bus; busOwner.gauranter2 = model.gauranter2; busOwner.gauranter2_bus = model.gauranter2_bus; busOwner.old_bus_number = model.old_bus_number; busOwner.old_bus_owner_name = model.old_bus_owner_name; busOwner.building_fund = model.building_fund; busOwner.previous_building_fund = model.previous_building_fund; busOwner.emi = model.emi; item.SaveChanges(); // }; //item.tblBusOwnerDetails.Add(busownerDetails); var busDeatils = item.tblBusDetails.Single(c => c.bus_id == model.busId); busDeatils.bus_number = model.bus_number; busDeatils.bus_operating_center = model.bus_operating_center; busDeatils.chesis_number = model.chesis_number; busDeatils.engine_number = model.engine_number; busDeatils.fitness = model.fitness; busDeatils.last_modified_date = DateTime.Now; busDeatils.registration_date = model.registration_date; busDeatils.permit_number = model.permit_number; busDeatils.model = model.model; busDeatils.seats = model.seats; busDeatils.road_tax = model.road_tax; busDeatils.isDeleted = false; busDeatils.last_modified_by = "Admin"; busDeatils.bus_registration_type = model.bus_registration_type; busDeatils.bus_registration_number = model.bus_registration_number; item.SaveChanges(); } return(true); } catch (Exception ex) { string err = ex.Message; return(false); } }
public static SaveBusModel EditBusDetails(int id) { SaveBusModel savebusmodel; try { savebusmodel = new SaveBusModel(); using (var item = new GMOUMISEntity()) { //var busID = item.tblBus.Where(i => i.bus_number == busnumber).Select(i => i.busid).SingleOrDefault(); savebusmodel = (from b in item.tblBus join bd in item.tblBusDetails on b.busid equals bd.bus_id join bo in item.tblBusOwnerDetails on b.busid equals bo.bus_id join bins in item.tblBusInsuranceDeatils on b.busid equals bins.bus_id where b.busid == id select new SaveBusModel { bus_number = b.bus_number, bus_operating_center = bd.bus_operating_center, registration_date = bd.registration_date, permit_number = bd.permit_number, model = bd.model, seats = bd.seats, chesis_number = bd.chesis_number, engine_number = bd.engine_number, road_tax = bd.road_tax, fitness = bd.fitness, company_name = bins.company_name, company_address = bins.company_address, validity = bins.validity, bus_owner_name = bo.bus_owner_name, owner_father_name = bo.owner_father_name, owner_address = bo.owner_address, owner_contact_number = bo.owner_contact_number, entry_amount = bo.entry_amount, entry_reciept_number = bo.entry_reciept_number, payment_date = bo.payment_date, security_amount = bo.security_amount, security_money_reciept = bo.security_money_reciept, remaining_amount = bo.remaining_amount, gauranter1 = bo.gauranter1, gauranter2 = bo.gauranter2, gauranter1_bus = bo.gauranter1_bus, gauranter2_bus = bo.gauranter2_bus, building_fund = bo.building_fund, previous_building_fund = bo.previous_building_fund, old_bus_owner_name = bo.old_bus_owner_name, old_bus_number = bo.old_bus_number, bus_registration_type = bd.bus_registration_type, emi = bo.emi, bus_registration_number = bd.bus_registration_number }).FirstOrDefault(); } return(savebusmodel); } catch (Exception ex) { throw; } }
public static bool UpdateBusDeatils(SaveBusModel model) { return(BusRepository.UpdateBusDetails(model)); }
public static bool AddBusRecords(SaveBusModel model) { return(BusRepository.AddBusDetails(model)); }