public void InsertSpecial(SalesSpecials special)
{
SalesSpecials newSpecial = new SalesSpecials();
var repo = GetAllSpecials();
newSpecial.SpecialName = special.SpecialName;
newSpecial.SpecialDescription = special.SpecialDescription;
repo.Insert(special.SpecialID, newSpecial);
}
public ActionResult AddSpecial(SalesSpecials special)
{
SalesSpecials specialK = new SalesSpecials
{
SpecialsName = special.SpecialsName,
SpecialDesc = special.SpecialDesc
};
repo.AddSpecial(specialK);
return(View(special));
}
public void AddSpecial(SalesSpecials newSpecial)
{
if (_salesSpecials.Any())
{
newSpecial.SalesSpecialsId = _salesSpecials.Max(s => s.SalesSpecialsId) + 1;
}
else
{
newSpecial.SalesSpecialsId = 1;
}
_salesSpecials.Add(newSpecial);
}
public void AddSpecial(SalesSpecials newSpecial)
{
if (context.DealerSalesSpecials.Count() == 0)
{
newSpecial.SalesSpecialsId = 1;
}
else
{
var max = context.DealerSalesSpecials.Max(m => m.SalesSpecialsId);
newSpecial.SalesSpecialsId = max;
}
context.DealerSalesSpecials.Add(newSpecial);
context.SaveChanges();
}
public void CanInsertSalesSpecial()
{
SalesSpecials specialToAdd = new SalesSpecials();
var repo = new SalesSpecialsRepositoryDapper();
var specials = repo.GetAllSpecials();
specialToAdd.SpecialName = "$10,000 Off MSRP";
specialToAdd.SpecialDescription = "Save $10,000 on remaining 2019 Models in Stock.";
repo.InsertSpecial(specialToAdd);
Assert.AreEqual(3, specialToAdd.SpecialID);
}
public IHttpActionResult DeleteSpecial(int specialID)
{
var repo = SalesSpecialsRepositoryFactory.GetRepository();
SalesSpecials special = repo.GetSpecialByID(specialID);
if (special == null)
{
return(NotFound());
}
else
{
repo.DeleteSpecial(specialID);
return(Ok());
}
}
public void InsertSpecial(SalesSpecials special)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var parameters = new DynamicParameters();
parameters.Add("@SpecialID",
dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@SpecialName", special.SpecialName);
parameters.Add("@SpecialDescription", special.SpecialDescription);
cn.Execute("SpecialInsert",
parameters, commandType: CommandType.StoredProcedure);
special.SpecialID = parameters.Get <int>("@SpecialID");
}
}
public ActionResult InsertSpecial(SalesSpecials special)
{
if (special.SpecialName == null)
{
ModelState.AddModelError("SpecialName", "Special name cannot be blank");
}
if (special.SpecialDescription == null)
{
ModelState.AddModelError("SpecialDescription", "Special description cannot be blank");
}
var repo = SalesSpecialsRepositoryFactory.GetRepository();
if (ModelState.IsValid)
{
repo.InsertSpecial(special);
return(RedirectToAction("Specials"));
}
return(View("Specials", special));
}
public ActionResult Specials()
{
var model = new SalesSpecials();
return(View(model));
}
public void EditSpecial(SalesSpecials editedSpecial)
{
throw new NotImplementedException();
}
public ActionResult DeleteSpecial(SalesSpecials special)
{
repo.DeleteSpecial(special.SalesSpecialsId);
return(RedirectToAction("AddSpecial"));
}
public void EditSpecial(SalesSpecials editedSpecial)
{
_salesSpecials.RemoveAll(s => s.SalesSpecialsId == editedSpecial.SalesSpecialsId);
_salesSpecials.Add(editedSpecial)
;
}
