public static tbl_finalStock DALGetOtherStocksDetailsSummary(int pumpid)
{
tbl_finalStock tblobj = new tbl_finalStock();
//decimal?[] cashquantity = new decimal?[] { model.cashquanity_diesel, model.cashquanity_petrol };
// UpdaeCashQuantity(cashquantity,model.pumpid);
try
{
using (var item = new GMOUMISEntity())
{
DateTime startDate = DateTime.Now.Date;
DateTime endDate = DateTime.Now.AddDays(1).Date;
tblobj = item.tbl_finalStock.Where(m => m.pumpid == pumpid && m.summary_date >= startDate && m.summary_date < endDate).FirstOrDefault();
}
}
catch (Exception ex)
{
return(null);
}
return(tblobj);
}
public static bool CheckIfBusavailable(string busnumber)
{
using (var item = new GMOUMISEntity())
{
var count = item.tblBus.Where(i => i.bus_number == busnumber).Count();
if (count > 0)
{
return(true);
}
return(false);
}
}
public static List <StationDetailModel> GetStatiionDetail(int stationid)
{
List <StationDetailModel> lstStatio = new List <StationDetailModel>();
using (var item = new GMOUMISEntity())
{
lstStatio = item.tblBusDetails.Select(m => new StationDetailModel {
BusNumber = m.bus_number, Date = m.registration_date, busID = m.bus_id
}).ToList();
//var data = item.tblBusDetails.Join();
}
return(lstStatio);
}
public static List <BusListModel> GetAllBusesBySearch(string condition, string type)
{
int con = 0;
if (type == "seats" || type == "setid")
{
con = Convert.ToInt32(condition);
}
List <BusListModel> employeeList = new List <BusListModel>();
try
{
using (var item = new GMOUMISEntity())
{
employeeList = (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
select new BusListModel {
busEncrpNumber = b.bus_number, bus_number = b.bus_number, bus_id = b.busid, bus_operating_center = bd.bus_operating_center, seats = bd.seats, bus_owner_name = bo.bus_owner_name, model = bd.model
}).ToList();
if (type == "seats")
{
employeeList = employeeList.Where(m => m.seats == con).ToList();
}
else if (type == "setid")
{
employeeList = employeeList.Where(m => m.setid == con).ToList();
}
else
{
employeeList = employeeList.Where(m => m.model == condition).ToList();
}
return(employeeList);
}
}
catch (Exception ex)
{
string msg = ex.Message;
return(employeeList);
}
}
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 List <BusDipo> GetAllDipo()
{
List <BusDipo> dipomodel = new List <BusDipo>();
try
{
using (var item = new GMOUMISEntity())
{
dipomodel = item.tbl_masterDepo.Select(m => new BusDipo {
DipoID = m.dipoid, DipoName = m.diponame
}).ToList();
}
return(dipomodel);
}
catch (Exception ex)
{
string msg = ex.Message;
return(dipomodel);
}
}
public static List <BusInsuranceNotification> InsuranceDatesNear()
{
List <BusInsuranceNotification> employeeList = new List <BusInsuranceNotification>();
var expecteddate = DateTime.Now.AddDays(10);
using (var item = new GMOUMISEntity())
{
employeeList = (from bI in item.tblBusInsuranceDeatils
join bs in item.tblBus on bI.bus_id equals bs.busid
join bd in item.tblBusDetails on bs.busid equals bd.bus_id
join bo in item.tblBusOwnerDetails on bs.busid equals bo.bus_id
where bI.validity <= expecteddate
select new BusInsuranceNotification
{
bus_number = bs.bus_number,
bus_id = bs.busid,
bus_owner_name = bo.bus_owner_name,
InsuranceCompany = bI.company_name,
InsuranceValidity = bI.validity,
}).ToList();
return(employeeList);
}
}
public static List <BusListModel> GetAllBuses()
{
List <BusListModel> employeeList = new List <BusListModel>();
try
{
using (var item = new GMOUMISEntity())
{
employeeList = (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
select new BusListModel {
busEncrpNumber = b.bus_number, bus_number = b.bus_number, bus_id = b.busid, bus_operating_center = bd.bus_operating_center, seats = bd.seats, bus_owner_name = bo.bus_owner_name, registration_date = bd.registration_date
}).ToList();
return(employeeList);
}
}
catch (Exception ex)
{
string msg = ex.Message;
return(employeeList);
}
}
public static MontlyBusReport GetVivraniReports(int busnumber, int month, int year)
{
MontlyBusReport montllybusreoprt = new MontlyBusReport();
List <VivraniReports> lstreports = new List <VivraniReports>();
List <FuleReopts> lstfule = new List <FuleReopts>();
using (var item = new GMOUMISEntity())
{
lstreports = (from r in item.tmp_cashvivrani
where r.bus_number == busnumber && r.vivrani_inserted_date.Month == month && r.vivrani_inserted_date.Year == year
group r by new
{
r.cash_vivrani_id,
r.vivrani_inserted_date
} into g
select new VivraniReports
{
VivraniNumber = g.Key.cash_vivrani_id,
VivraniDate = g.Key.vivrani_inserted_date,
Amount = g.Sum(m => m.amount)
}).ToList(); // lstreports = item.tmp_cashvivrani.Where(m => m.bus_number == busnumber && m.vivrani_inserted_date.Month == month && m.vivrani_inserted_date.Year == year).GroupBy(m => m.cash_vivrani_id).Select(ml => new VivraniReports { Amount = ml.Sum(c => c.amount), VivraniNumber = ml.First().cash_vivrani_id }).ToList();
montllybusreoprt.lstVivraniReports = lstreports;
var data = (from r in item.tbl_ChitFuel
where r.vechilenumber == busnumber && r.inserteddate.Value.Month == month && r.inserteddate.Value.Year == year
group r by new
{
r.dieselchitno
} into g
select new FuleReopts
{
ChitNumber = g.Key.dieselchitno,
FuleDate = g.Select(m => m.inserteddate.Value).FirstOrDefault(),
Amount = g.Sum(m => m.price)
}).ToList();
montllybusreoprt.lstFuleReposrts = data;
}
try
{
using (var item = new GMOUMISEntity())
{
var data = (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 == 205
select new MontlyBusReport
{
BusNumber = b.bus_number,
AccountName = "",
AccountNumber = "",
BankName = "",
Dipo = item.tblSets.Where(m => m.setid == bd.bus_operating_center).Select(m => m.station).FirstOrDefault()
}).FirstOrDefault();
montllybusreoprt.BusNumber = data.BusNumber;
montllybusreoprt.Dipo = data.Dipo;
}
}
catch (Exception)
{
throw;
}
// select m.bus_number,k.bus_owner_name, (select station from dbo.tblSets where setid=l.bus_operating_center) as Station
//from dbo.tblBus m join dbo.tblBusOwnerDetails K on ( m.busid=K.bus_id) join
//dbo.tblBusDetails l on ( m.busid=l.bus_id)
//where m.busid=205
return(montllybusreoprt);
}
public static List <DebitStatus> GetBusDebitStatus()
{
List <DebitStatus> st = new List <DebitStatus>();
DebitStatus obj = null;
DebitStatus resu = null;
using (var item = new GMOUMISEntity())
{
var data = item.sp_GetButDebitStatusByDate().ToList();;
int count = 0;
foreach (var itema in data)
{
if (count == 0)
{
if (itema.description.Equals("Fuel Filling"))
{
obj = new DebitStatus()
{
FuelFilling = itema.description, FuelFillingAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
if (itema.description.Equals("Vivrani Generated"))
{
obj = new DebitStatus()
{
vivrani = itema.description, VivraniAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
if (itema.description.Equals("Advance"))
{
obj = new DebitStatus()
{
Advance = itema.description, AdvanceAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
count++;
}
else
{
if (st.Where(m => m.Busid == itema.busid).Count() > 0)
{
resu = st.Where(m => m.Busid == itema.busid).FirstOrDefault();
if (itema.description.Equals("Fuel Filling"))
{
resu.FuelFilling = itema.description;
resu.FuelFillingAmount = itema.Amount; resu.Busid = itema.busid;
resu.Busnumber = itema.bus_number;
}
if (itema.description.Equals("Vivrani Generated"))
{
resu.vivrani = itema.description; resu.VivraniAmount = itema.Amount;
resu.Busid = itema.busid;
resu.Busnumber = itema.bus_number;
}
if (itema.description.Equals("Advance"))
{
resu.Advance = itema.description; resu.AdvanceAmount = itema.Amount;
resu.Busid = itema.busid;
resu.Busnumber = itema.bus_number;
}
}
else
{
if (itema.description.Equals("Fuel Filling"))
{
obj = new DebitStatus()
{
FuelFilling = itema.description, FuelFillingAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
if (itema.description.Equals("Vivrani Generated"))
{
obj = new DebitStatus()
{
vivrani = itema.description, VivraniAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
if (itema.description.Equals("Advance"))
{
obj = new DebitStatus()
{
Advance = itema.description, AdvanceAmount = itema.Amount, Busid = itema.busid, Busnumber = itema.bus_number
};
}
}
}
if (resu != null)
{
st.Add(resu);
resu = null;
}
else
{
st.Add(obj);
resu = null;
}
}
var d = st.DistinctBy(m => m.Busid).ToList();
return(st);
}
}
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;
}
}
