public ActionResult Delete(string id)
{
try
{
DressModel chkDress = repo.GetDress(id);
if (chkDress == null)
{
return(NotFound(new ResponseModel {
Message = "Data Not Found"
}));
}
else
{
repo.deleteDress(id);
return(Ok(new ResponseModel {
Message = "Data is Removed"
}));
}
}
catch (Exception ex)
{
return(StatusCode(500, new ResponseModel {
Error = ex.Message
}));
}
}
public ActionResult Put(DressModel dress)
{
/*if (!ModelState.IsValid)
* return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);*/
try
{
DressModel chkDress = repo.GetDress(dress.DresID.ToString());
if (chkDress == null)
{
return(NotFound(new ResponseModel {
Error = "Dress Not Found"
}));
}
else
{
repo.updateDress(dress);
return(Ok(new ResponseModel {
Message = "Data is Updated"
}));
}
}
catch (Exception ex)
{
return(StatusCode(500, new ResponseModel {
Error = ex.Message
}));
}
}
public ActionResult Get(int id)
{
DressModel dress = repo.GetDress(id.ToString());
if (dress != null)
{
return(Ok(dress));
}
else
{
return(NotFound(new ResponseModel {
Error = "Dress Not Found"
}));
}
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
DressModel = await _context.DressModel
.Include(d => d.Dress).FirstOrDefaultAsync(m => m.Id == id);
if (DressModel == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
DressModel = await _context.DressModel.FindAsync(id);
if (DressModel != null)
{
_context.DressModel.Remove(DressModel);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetAsync(Guid?id)
{
if (id == null)
{
return(NotFound());
}
DressModel = await _context.DressModel
.Include(d => d.Dress).FirstOrDefaultAsync(m => m.Id == id);
if (DressModel == null)
{
return(NotFound());
}
ViewData["DressId"] = new SelectList(_context.Dress, "Id", "Brand");
return(Page());
}
public ActionResult Post(DressModel dress)
{
/*if (!ModelState.IsValid)
* return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);*/
try
{
repo.InsertDress(dress);
return(StatusCode(201, new ResponseModel {
Message = "Dress append"
}));
}
catch (Exception ex)
{
return(StatusCode(500, new ResponseModel {
Error = ex.Message
}));
}
}
public int updateDress(DressModel dress)
{
try
{
mysql.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = mysql.mysqlConnection;
string qry = "";
qry += "update myApi.dresses ";
qry += " set title=@title ";
qry += ", color=@color ";
qry += ", price=@price ";
qry += ", quantity=@quantity ";
qry += ", size=@size ";
qry += "where id=@DRESSID; ";
cmd.CommandText = qry;
cmd.Prepare();
cmd.Parameters.AddWithValue("@title", dress.Title);
cmd.Parameters.AddWithValue("@color", dress.Color);
cmd.Parameters.AddWithValue("@price", dress.Price);
cmd.Parameters.AddWithValue("@quantity", dress.Quantity);
cmd.Parameters.AddWithValue("@size", dress.Size);
cmd.Parameters.AddWithValue("@DRESSID", dress.DresID);
mysql.GoSql(cmd);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
mysql.Close();
}
return(1);
}
public int InsertDress(DressModel dress)
{
MySqlCommand cmd = new MySqlCommand();
mysql.Open();
cmd.Connection = mysql.mysqlConnection;
string qry = "";
qry += "INSERT INTO dresses ";
qry += "(title,color,price,quantity,size) ";
qry += " VALUES (@title,@color,@price,@quantity,@size)";
cmd.CommandText = qry;
cmd.Prepare();
cmd.Parameters.AddWithValue("@title", dress.Title);
cmd.Parameters.AddWithValue("@color", dress.Color);
cmd.Parameters.AddWithValue("@price", dress.Price);
cmd.Parameters.AddWithValue("@quantity", dress.Quantity);
cmd.Parameters.AddWithValue("@size", dress.Size);
return(mysql.GoSql(cmd));
}
