public void Edit([FromBody] c_order corder)
{
if (ModelState.IsValid)
{
objcorder.UpdateOrder(corder);
}
}
public void Post([FromBody] c_order value)
{
if (ModelState.IsValid)
{
objcorder.AddOrder(value);
}
}
public void Create([FromBody] c_order corder)
{
if (ModelState.IsValid)
{
objcorder.AddOrder(corder);
}
}
public void Put(int id, [FromBody] c_order value)
{
if (ModelState.IsValid)
{
objcorder.UpdateOrder(value);
}
}
public Task<int> Create(c_order article)
{
var dbPara = new DynamicParameters();
dbPara.Add("Name", article.name, DbType.String);
dbPara.Add("Note", article.note, DbType.String);
var articleId = Task.FromResult(_dapperManager.Insert<int>(@"INSERT INTO c_order (name,note) VALUES (@Name,@Note);SELECT LAST_INSERT_ID();",
dbPara,
commandType: CommandType.Text));
return articleId;
}
public Task<int> Update(c_order c_Order)
{
var dbPara = new DynamicParameters();
dbPara.Add("Id", c_Order.id);
dbPara.Add("Name", c_Order.name, DbType.String);
var updateArticle = Task.FromResult(_dapperManager.Update<int>("c_order",
dbPara,
commandType: CommandType.StoredProcedure));
return updateArticle;
}
public c_order GetOrder(ulong id)
{
try
{
c_order corder = db.c_order.Find(id);
return(corder);
}
catch
{
throw;
}
}
public void UpdateOrder(c_order corder)
{
try
{
db.Entry(corder).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch
{
throw;
}
}
public void AddOrder(c_order corder)
{
try
{
db.c_order.Add(corder);
db.SaveChanges();
}
catch
{
throw;
}
}
public void DeleteOrder(int id)
{
try
{
c_order corder = db.c_order.Find(id);
db.c_order.Remove(corder);
db.SaveChanges();
}
catch
{
throw;
}
}
public void order_update(c_order t)
{
order_business db = new order_business();
throw new NotImplementedException();
}
public void order_insert(c_order t)
{
order_business db = new order_business();
db.Create(t);
}
public Task <int> Update(c_order cOrder)
{
throw new System.NotImplementedException();
}
Task <int> ICorderManager.Create(c_order cOrder)
{
return(_mngOrder.Create(cOrder));
//throw new NotImplementedException();
}
