public static SupplyDTO GetSupply(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.SupplyCasting.CastToDTO(db.Supplies.FirstOrDefault(s => s.supplyId == id)));
}
}
public static int getTrans()
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(db.Transactions.Count());
}
}
public HttpResponseMessage UploadFile(string id)
{
var pathToSql = " http://localhost:58516/UploadFiles/";
var allPath = "";
HttpResponseMessage response = new HttpResponseMessage();
var abc = Request.Properties.Values;
var httpRequest = HttpContext.Current.Request;
foreach (string file in httpRequest.Files)
{
pathToSql = " http://localhost:58516/UploadFiles/";
var postedFile = httpRequest.Files[file];
var directoryPath = HttpContext.Current.Server.MapPath("~/UploadFiles/");
Directory.CreateDirectory(directoryPath + id);
allPath = directoryPath + id + "/" + postedFile.FileName;
postedFile.SaveAs(allPath);
pathToSql += id + "/" + postedFile.FileName;
using (carLeasingEntities db = new carLeasingEntities())
{
var car = db.Cars.FirstOrDefault(p => p.carId.ToString() == id);
car.picture = pathToSql;
db.SaveChanges();
}
}
return(response);
}
public static CarDTO GetCar(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.CarCasting.castToDTO(db.Cars.FirstOrDefault(s => s.carId == id)));
}
}
public static int getUsers()
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(db.Users.Count());
}
}
public static List <CarDTO> carList(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.CarCasting.castListToDTO(db.Cars.Where(p => p.owner == id).ToList()));
}
}
public static List <CarDTO> AllCars()
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.CarCasting.castListToDTO(db.Cars.ToList()));
}
}
public static List <SupplyDTO> showSupplies(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.SupplyCasting.castListToDTO(db.Supplies.Where(p => p.supplyU == id).ToList()));
}
}
public static DemandDTO GetDemand(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.DemandCasting.castToDTO(db.Demands.FirstOrDefault(s => s.demanedId == id)));
}
}
public static List <DemandDTO> showDemands(int userId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(Casting.DemandCasting.castListToDTO(db.Demands.Where(p => p.interestedId == userId).ToList()));
}
}
public static UserDTO GetUserById(int userId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var user = db.Users.FirstOrDefault(p => p.userId == userId);
return(Casting.UserCasting.castToDto(user));
}
}
public static UserDTO login(UserDTO userD)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var user = db.Users.FirstOrDefault(p => p.email == userD.email && p.password == userD.password);
return(Casting.UserCasting.castToDto(user));
}
}
public static CarDTO getCar(int carId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var c = db.Cars.FirstOrDefault(cr => cr.carId == carId);
return(Casting.CarCasting.castToDTO(c));
}
}
public static List <insuranceTypeDTO> castListToDTO(List <Insurance> dalList)
{
using (carLeasingEntities db = new carLeasingEntities())
{
List <insuranceTypeDTO> newList = new List <insuranceTypeDTO>();
dalList.ForEach(p => newList.Add(castToDTO(p)));
return(newList);
}
}
public static void deleteDemand(int demandId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Demand d = db.Demands.FirstOrDefault(p => p.demanedId == demandId);
db.Demands.Remove(d);
db.SaveChanges();
}
}
public static void deleteCar(int carId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Car c = db.Cars.FirstOrDefault(y => y.carId == carId);
db.Cars.Remove(c);
db.SaveChanges();
}
}
public static List <TransactionDTO> showTransaction(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var transactions = db.Transactions.Where(p => p.Supply.supplyU == id || p.Demand.interestedId == id).ToList();
var transactionsDto = Casting.TransactionCasting.castListToDTO(transactions);
return(transactionsDto);
}
}
public static void deleteSupply(int SupplyId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Supply d = db.Supplies.FirstOrDefault(p => p.supplyId == SupplyId);
db.Supplies.Remove(d);
db.SaveChanges();
}
}
public static List <DemandDTO> getAllDemands()
{
using (carLeasingEntities db = new carLeasingEntities())
{
List <Demand> list = new List <Demand>();
list = db.Demands.Where(p => p.isDone == false).ToList();
return(Casting.DemandCasting.castListToDTO(list));
}
}
public static List <SupplyDTO> getAllSupplies()
{
using (carLeasingEntities db = new carLeasingEntities())
{
List <Supply> list = new List <Supply>();
list = db.Supplies.Where(p => p.isDone == false).ToList();
return(Casting.SupplyCasting.castListToDTO(list));
}
}
public static int newCar(CarDTO car)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Car newCar = Casting.CarCasting.castToDAL(car);
db.Cars.Add(newCar);
db.SaveChanges();
return(db.Cars.FirstOrDefault(p => p.carNum == car.carNum).carId);
}
}
public static void deleteSupplyByCar(int id)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var d = db.Cars.FirstOrDefault(p => p.carId == id);
Car n = d;
List <Supply> s = db.Supplies.Where(p => p.carNum == n.carNum).ToList();
db.Supplies.RemoveRange(s);
db.SaveChanges();
}
}
public static void newSupply(SupplyDTO Supply)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Supply d = Casting.SupplyCasting.castToDAL(Supply);
d.isDone = false;
d.price = Supply.price;
var dd = db.Supplies.Add(d);
db.SaveChanges();
dd.supplyU = Supply.supplyU;
db.SaveChanges();
}
}
public static DemandDTO newDemand(DemandDTO demand)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Demand d = Casting.DemandCasting.castToDAL(demand);
d.isDone = false;
var dd = db.Demands.Add(d);
db.SaveChanges();
dd.interestedId = demand.interestedId;
db.SaveChanges();
return(Casting.DemandCasting.castToDTO(dd));
}
}
public static void updateSupply(SupplyDTO Supply)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var s = db.Supplies.FirstOrDefault(p => p.supplyId == Supply.supplyId);
s.fromDate = Supply.fromDate;
s.fromHour = Supply.fromHour;
s.carLocationx = Supply.carLocationx;
s.carLocationy = Supply.carLocationy;
s.toDate = Supply.toDate;
s.toHour = Supply.toHour;
db.SaveChanges();
}
}
public static void updateDetails(UserDTO userU)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var user = db.Users.Where(i => i.userId == userU.userId).FirstOrDefault();
user.firstName = userU.firstName;
user.lastName = userU.lastName;
user.email = userU.email;
user.password = userU.password;
user.insuranceType = userU.insuranceType;
user.phone = userU.phone;
db.SaveChanges();
}
}
public static void updateDemand(DemandDTO demand)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var d = db.Demands.FirstOrDefault(p => p.demanedId == demand.demanedId);
d.fromDate = demand.fromDate;
d.fromHour = demand.fromHour;
d.Locationx = demand.Locationx;
d.Locationy = demand.Locationy;
d.toDate = demand.toDate;
d.toHour = demand.toHour;
db.SaveChanges();
}
}
public static UserDTO register(UserDTO user)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var u = db.Users.FirstOrDefault(p => p.password == user.password);
if (u != null)
{
return(null);
}
User newUser = Casting.UserCasting.castToDal(user);
var uu = db.Users.Add(newUser);
db.SaveChanges();
return(Casting.UserCasting.castToDto(uu));
}
}
public static CarDTO lookForSuggest(DemandDTO demand)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var d = db.Supplies.FirstOrDefault(p => p.fromDate <= demand.fromDate && p.fromHour <= demand.fromHour && p.toDate >= demand.toDate &&
p.toHour >= demand.toHour);
if (d != null)
{
var currentCar = db.Cars.FirstOrDefault(c => c.carNum == d.carNum);
CarDTO carDTO = Casting.CarCasting.castToDTO(currentCar);
return(carDTO);
}
return(null);
}
}
public static Transaction castToDAL(TransactionDTO transactionDTO)
{
using (carLeasingEntities db = new carLeasingEntities())
{
return(new Transaction()
{
transactionId = transactionDTO.transactionId,
beginDate = transactionDTO.beginDate,
beginHour = transactionDTO.beginHour,
demandId = transactionDTO.demandId,
endDate = transactionDTO.endDate,
endHour = transactionDTO.endHour,
supplyId = transactionDTO.supplyId,
Demand = db.Demands.FirstOrDefault(p => p.demanedId == transactionDTO.demandId),
Supply = db.Supplies.FirstOrDefault(p => p.supplyId == transactionDTO.supplyId)
});
}
}
