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 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 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 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 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 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 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 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 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 void edit(CarDTO car)
{
using (carLeasingEntities db = new carLeasingEntities())
{
var c = db.Cars.FirstOrDefault(cr => cr.carId == car.carId);
c.carNum = car.carNum;
c.description = car.description;
c.carCompany = car.carCompany;
c.expiryDate = car.expiryDate;
c.file = car.file;
c.insuranceType = car.insuranceType;
c.model = car.model;
c.numSeats = car.numSeats;
c.trunc = car.trunc;
c.picture = car.picture;
db.SaveChanges();
}
}
public static bool CreatTransaction(int supplyId, int demanedId, int userId)
{
using (carLeasingEntities db = new carLeasingEntities())
{
Supply supply = db.Supplies.FirstOrDefault(s => s.supplyId == supplyId);
if (demanedId == -1)
{
DemandDTO d = new DemandDTO()
{
fromDate = supply.fromDate,
fromHour = supply.fromHour,
Locationx = supply.carLocationx,
Locationy = supply.carLocationy,
toDate = supply.toDate,
toHour = supply.toHour,
interestedId = userId
};
d = DemandsFunction.newDemand(d);
demanedId = d.demanedId;
}
Demand demaned = db.Demands.FirstOrDefault(d => d.demanedId == demanedId);
if (supply != null && demaned != null)
{
Transaction t = new Transaction()
{
demandId = demanedId,
supplyId = supplyId,
};
db.Transactions.Add(t);
supply.isDone = true;
demaned.isDone = true;
if (supply.fromDate < demaned.fromDate)
{
Supply s = new Supply()
{
carNum = supply.carNum,
carLocationx = supply.carLocationx,
carLocationy = supply.carLocationy,
supplyId = supply.supplyId,
supplyU = supply.supplyU,
fromDate = supply.fromDate,
fromHour = supply.fromHour,
toDate = demaned.fromDate,
toHour = demaned.toHour,
isDone = false
};
db.Supplies.Add(s);
}
if (supply.toDate > demaned.toDate)
{
Supply s = new Supply()
{
carNum = supply.carNum,
carLocationx = supply.carLocationx,
carLocationy = supply.carLocationy,
supplyId = supply.supplyId,
supplyU = supply.supplyU,
fromDate = demaned.toDate,
fromHour = demaned.toHour,
toDate = supply.toDate,
toHour = supply.toHour,
isDone = false
};
db.Supplies.Add(s);
}
}
db.SaveChanges();
SendEmail(supply);
}
return(true);
}
