public void Put(string TableNo, [FromBody] R_Table R_Table)
{
if (ModelState.IsValid)
{
R_TableTrpository.Update(TableNo, R_Table);
}
}
public void Post([FromBody] R_Table R_Table)
{
if (ModelState.IsValid)
{
R_TableTrpository.Add(R_Table);
}
}
public void Update(string OldTable, R_Table R_Table)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "UPDATE R_Table SET TableNo=@TableNo,Status=@Status,BkColor=@BkColor "
+ " WHERE TableNo ='" + OldTable + "'";
dbConnection.Open();
dbConnection.Query(sQuery, R_Table);
}
}
public void Add(R_Table R_Table)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO R_Table(TableNo,Status,BkColor )"
+ " VALUES(@TableNo,@Status,@BkColor )";
dbConnection.Open();
dbConnection.Execute(sQuery, R_Table);
}
}
public bool Create(TableCreateDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
bool result = true;
try
{
db.BeginTran();
R_Table model = new R_Table()
{
Name = req.Name,
Describe = req.Description,
R_Restaurant_Id = req.RestaurantId,
ServerRate = req.ServerRate,
R_Area_Id = req.RestaurantArea,
CythStatus = CythStatus.空置,
SeatNum = req.SeatNum,
IsVirtual = req.IsVirtual,
Sorted = req.Sorted
};
var insert = db.Insert(model);
if (req.Box > 0)
{
db.Insert(new R_BoxTable()
{
R_Table_Id = Convert.ToInt32(insert),
R_Box_Id = req.Box
});
}
db.CommitTran();
}
catch (Exception)
{
result = false;
db.RollbackTran();
throw;
}
return(result);
}
}
public ActionResult R_TableUpdate(R_Table tab)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
//Define request data format
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//Sending request to find web api REST service resource GetAllEmployees using HttpClient
HttpResponseMessage Res = client.PutAsJsonAsync("api/R_Table/" + tab.TableNo, tab).Result;
//Checking the response is successful or not which is sent using HttpClient
if (Res.IsSuccessStatusCode)
{
//Storing the response details recieved from web api
var TabResponse = Res.Content.ReadAsStringAsync().Result;
ViewBag.Name = JsonConvert.SerializeObject(TabResponse);
//Deserializing the response recieved from web api and storing into the Employee list
//CatInfo = JsonConvert.DeserializeObject<List<Category>>(CatResponse);
}
}
return(RedirectToAction("R_Table"));
}
public bool Update(TableCreateDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
bool result = true;
try
{
db.BeginTran();
R_Table model = db.Queryable <R_Table>().First(p => p.Id == req.Id);
model.Name = req.Name;
model.Describe = req.Description;
model.R_Restaurant_Id = req.RestaurantId;
model.ServerRate = req.ServerRate;
model.R_Area_Id = req.RestaurantArea;
model.SeatNum = req.SeatNum;
model.IsVirtual = req.IsVirtual;
model.Sorted = req.Sorted;
result = db.Update(model);
var cybxth = db.Queryable <R_BoxTable>()
.Where(p => p.R_Table_Id == model.Id)
.FirstOrDefault();
if (req.Box > 0)
{
if (cybxth != null)
{
if (cybxth.R_Box_Id != req.Box)
{
cybxth.R_Box_Id = req.Box;
db.Update <R_BoxTable>(cybxth);
}
}
else
{
db.Insert <R_BoxTable>(new R_BoxTable()
{
R_Table_Id = model.Id,
R_Box_Id = req.Box
});
}
}
else
{
if (cybxth != null)
{
db.Delete <R_BoxTable>(p => p.Id == cybxth.Id);
}
}
db.CommitTran();
}
catch (Exception)
{
db.RollbackTran();
result = false;
throw;
}
return(result);
}
}
