public static bool DALInsertDailySummary(tbl_finalStock model) { decimal ?[] cashquantity = new decimal?[] { model.cashquanity_diesel, model.cashquanity_petrol }; // UpdaeCashQuantity(cashquantity,model.pumpid); try { using (var item = new GMOUMISEntity()) { item.tbl_finalStock.Add(model); item.SaveChanges(); return(true); } } catch (Exception ex) { return(false); } }
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); } }