public void CanInsertSalesInformation()
{
SalesInformation sale = new SalesInformation();
var repo = new SalesInformationRepositoryDapper();
sale.CustomerName = "Susan Wright";
sale.CustomerPhone = "502-555-0117";
sale.CustomerEmail = "*****@*****.**";
sale.CustomerStreet1 = "200 Merriweather Rd";
sale.CustomerStreet2 = "Apt B";
sale.CustomerCity = "Louisville";
sale.CustomerState = "KY";
sale.CustomerZip = "40223";
sale.PurchasePrice = 18200;
sale.PurchaseTypeID = 2;
sale.VehicleID = 4;
var dateTime = DateTime.Parse("04/20/2020");
sale.PurchaseDate = dateTime;
sale.Id = "00000000-0000-0000-0000-000000000000";
repo.Insert(sale);
Assert.AreEqual(3, sale.SalesID);
}
public void Insert(SalesInformation sale)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var parameters = new DynamicParameters();
parameters.Add("@SalesID",
dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@CustomerName", sale.CustomerName);
parameters.Add("@CustomerPhone", sale.CustomerPhone);
parameters.Add("@CustomerEmail", sale.CustomerEmail);
parameters.Add("@CustomerStreet1", sale.CustomerStreet1);
parameters.Add("@CustomerStreet2", sale.CustomerStreet2);
parameters.Add("@CustomerCity", sale.CustomerCity);
parameters.Add("@CustomerState", sale.CustomerState);
parameters.Add("@CustomerZip", sale.CustomerZip);
parameters.Add("@PurchasePrice", sale.PurchasePrice);
parameters.Add("@PurchaseTypeID", sale.PurchaseTypeID);
parameters.Add("@PurchaseDate", sale.PurchaseDate);
parameters.Add("@VehicleID", sale.VehicleID);
parameters.Add("@Id", sale.Id);
cn.Execute("SalesInsert",
parameters, commandType: CommandType.StoredProcedure);
sale.SalesID = parameters.Get <int>("@SalesID");
}
}
public void AddSale(SalesInformation sale)
{
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["CarDealership"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddSale";
cmd.Parameters.AddWithValue("@Name", sale.Name);
cmd.Parameters.AddWithValue("@Email", sale.Email);
cmd.Parameters.AddWithValue("@Phone", sale.Phone);
cmd.Parameters.AddWithValue("@Street1", sale.Street1);
if (sale.Street2 != null)
{
cmd.Parameters.AddWithValue("@Street2", sale.Street2);
}
else
{
cmd.Parameters.AddWithValue("@Street2", "");
}
cmd.Parameters.AddWithValue("@City", sale.City);
cmd.Parameters.AddWithValue("@StateId", sale.StateId);
cmd.Parameters.AddWithValue("@ZipCode", sale.Zipcode);
cmd.Parameters.AddWithValue("@PurchasePrice", sale.PurchasePrice);
cmd.Parameters.AddWithValue("@PurchaseTypeId", sale.PurchaseType);
cmd.Parameters.AddWithValue("@SoldBy", sale.SoldBy);
cmd.Parameters.AddWithValue("@InventoryNumber", sale.InventoryNumber);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
public SalesInformation GetById(int Id)
{
SalesInformation res = new SalesInformation();
res = _unitOfWork.efSalesInformationDal.Get(c => c.Id == Id, i => i.Include(cp => cp.Cart).ThenInclude(c => c.CartProducts).ThenInclude(p => p.Product).ThenInclude(c => c.Category).Include(pt => pt.PaymentType));
return(res);
}
public void AddToSalesInfoDate(string dateOfSale, Sale sale)
{
if (SalesInformation.Contains(sale))
{
int i = SalesInformation.IndexOf(sale);
SalesInformation[i].AddDateOfSale(dateOfSale);
}
}
public string UpdateAndSalesInformationAdd(Cart cart, SalesInformation salesInfo)
{
_unitOfWork.BeginTransaction();
_unitOfWork.efSalesInformationDal.Add(salesInfo);
cart.isPaymentCompleted = true;
_unitOfWork.efCartDal.Update(cart);
return(_unitOfWork.CommitSaveChanges());
}
public void AddToSalesInformation(string dateOfPurchase, string price, string licenseNumber)
{
Sale s = new Sale(dateOfPurchase, price);
s.AddLicenseNumber(licenseNumber);
SalesInformation.Add(s);
DateOfPurchaise = dateOfPurchase;
}
private bool SalesInformationExists(int id)
{
bool result = false;
SalesInformation product = salesInformationService.GetById(id);
if (product != null)
{
result = true;
}
return(result);
}
public IHttpActionResult UpdateSalesInformation(SalesInformation s_SalesInformation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_SalesInformationService.Update(s_SalesInformation);
return(CreatedAtRoute("DefaultApi", new { id = s_SalesInformation.SalesID }, s_SalesInformation));
}
public IHttpActionResult GetSalesInformation(int id)
{
SalesInformation s_SalesInformation = _SalesInformationService.GetById(id);
if (s_SalesInformation == null)
{
return(NotFound());
}
return(Ok(s_SalesInformation));
}
public bool Delete(SalesInformation aS_SalesInformation)
{
try
{
repository.Update(aS_SalesInformation);
return(true);
}
catch
{
return(false);
}
}
public IHttpActionResult AddSalesInformation(SalesInformation s_SalesInformation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_SalesInformationService.Add(s_SalesInformation);
return(StatusCode(HttpStatusCode.NoContent));
}
public bool Add(SalesInformation aS_SalesInformation)
{
try
{
aS_SalesInformation.Status = 1;
repository.Add(aS_SalesInformation);
unitOfWork.Commit();
return(true);
}
catch
{
return(false);
}
}
public bool Update(SalesInformation aS_SalesInformation)
{
try
{
aS_SalesInformation.ModifiedBy = 1;
aS_SalesInformation.ModifiedOn = DateTime.Now;
repository.Update(aS_SalesInformation);
unitOfWork.Commit();
return(true);
}
catch
{
return(false);
}
}
public IActionResult CompleteCartSales(int id, int paymentTypeId)
{
Cart cart = new Cart();
cart = cartService.GetById(id);
int total = 0;
foreach (var item in cart.CartProducts)
{
total += item.ProductAmount * item.Product.Price;
}
SalesInformation salesInfo = new SalesInformation()
{
CartId = cart.Id, PaymentTypeId = paymentTypeId, TotalPrice = total
};
cartService.UpdateAndSalesInformationAdd(cart, salesInfo);
return(RedirectToAction(nameof(Index), "Products"));
}
public void Insert(SalesInformation sale)
{
SalesInformation newSale = new SalesInformation();
var repo = GetSales();
newSale.CustomerName = sale.CustomerName;
newSale.CustomerPhone = sale.CustomerPhone;
newSale.CustomerEmail = sale.CustomerEmail;
newSale.CustomerStreet1 = sale.CustomerStreet1;
newSale.CustomerStreet2 = sale.CustomerStreet2;
newSale.CustomerCity = sale.CustomerCity;
newSale.CustomerState = sale.CustomerState;
newSale.CustomerZip = sale.CustomerZip;
newSale.PurchasePrice = sale.PurchasePrice;
newSale.PurchaseTypeID = sale.PurchaseTypeID;
newSale.VehicleID = sale.VehicleID;
newSale.Id = sale.Id;
newSale.PurchaseDate = sale.PurchaseDate;
repo.Insert(newSale.SalesID, newSale);
}
public List <SalesInformation> GetAllSalesInformation()
{
List <SalesInformation> _salesInformation = new List <SalesInformation>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["CarDealership"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetAllSalesInformation";
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SalesInformation currentRow = new SalesInformation();
currentRow.Name = dr["Name"].ToString();
currentRow.Email = dr["CustomerEmail"].ToString();
currentRow.Phone = dr["Phone"].ToString();
currentRow.Street1 = dr["Street1"].ToString();
currentRow.Street2 = dr["Street2"].ToString();
currentRow.City = dr["City"].ToString();
currentRow.StateId = dr["StateId"].ToString();
currentRow.Zipcode = dr["Zipcode"].ToString();
currentRow.PurchasePrice = (int)dr["PurchasePrice"];
currentRow.SoldBy = dr["Email"].ToString();
currentRow.InventoryNumber = (int)dr["InventoryNumber"];
currentRow.PurchaseType = dr["PurchaseType"].ToString();
currentRow.PurchaseDate = (DateTime)dr["PurchaseDate"];
_salesInformation.Add(currentRow);
}
}
}
return(_salesInformation);
}
public string Delete(SalesInformation entity)
{
_unitOfWork.BeginTransaction();
_unitOfWork.efSalesInformationDal.Delete(entity);
return(_unitOfWork.CommitSaveChanges());
}
public ActionResult InsertSalesInformation(PurchaseSalesInfoViewModel model)
{
var inventory = VehicleRepositoryFactory.GetRepository();
var vech = inventory.GetVehicleDetails(model.VehicleID);
if (model.PurchasePrice >= vech.MSRP)
{
ModelState.AddModelError("PurchasePrice", "Purchase price cannot be greater than MSRP");
}
if (decimal.ToDouble(model.PurchasePrice) < ((decimal.ToDouble(vech.SalesPrice) * 0.95)))
{
ModelState.AddModelError("PurchasePrice", "Purchase price cannot be less than 95% of sales price");
}
if (ModelState.IsValid)
{
var repo = SalesInformationRepositoryFactory.GetRepository();
SalesInformation sale = new SalesInformation();
sale.VehicleID = model.VehicleID;
sale.CustomerName = model.CustomerName;
sale.CustomerPhone = model.CustomerPhone;
sale.CustomerEmail = model.CustomerEmail;
sale.CustomerStreet1 = model.CustomerStreet1;
sale.CustomerStreet2 = model.CustomerStreet2;
sale.CustomerCity = model.CustomerCity;
sale.CustomerState = model.CustomerState;
sale.CustomerZip = model.CustomerZip;
sale.PurchasePrice = model.PurchasePrice;
sale.PurchaseTypeID = model.PurchaseTypeID;
var id = User.Identity.GetUserId();
sale.Id = id;
DateTime today = DateTime.Today;
sale.PurchaseDate = today;
repo.Insert(sale);
return(RedirectToAction("Index"));
}
else
{
var repo = VehicleRepositoryFactory.GetRepository();
var car = repo.GetVehicleDetails(model.VehicleID);
model.YearBuilt = car.YearBuilt;
model.MakeName = car.MakeName;
model.ModelName = car.ModelName;
model.ImageFileName = car.ImageFileName;
model.BodyTypeName = car.BodyTypeName;
model.TransmissionTypeName = car.TransmissionTypeName;
model.ExtColorName = car.ExtColorName;
model.IntColorName = car.IntColorName;
model.Mileage = car.Mileage;
model.VINNumber = car.VINNumber;
model.SalesPrice = car.SalesPrice;
model.MSRP = car.MSRP;
model.VehicleDescription = car.VehicleDescription;
return(View("Purchase", model));
}
}
