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);
}
}