public ActionResult Edit(MarketCreateDTO req)
{
Response res = new Response();
if (ModelState.IsValid)
{
try
{
if (req.Id > 0)
{
res.Data = _marketRepository.Update(req);
}
else
{
res.Data = _marketRepository.Create(req);
}
}
catch (Exception ex)
{
res.Message = ex.Message;
}
}
else
{
res.Data = false;
res.Message = string.Join(",", ModelState
.SelectMany(ms => ms.Value.Errors)
.Select(e => e.ErrorMessage));
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public bool Update(MarketCreateDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
bool result = true;
R_Market model = new R_Market()
{
Name = req.Name,
Description = req.Description,
Id = req.Id,
R_Restaurant_Id = req.Restaurant,
StartTime = req.StartTime,
EndTime = req.EndTime
};
result = db.Update(model);
return(result);
}
}
public bool Create(MarketCreateDTO req)
{
using (var db = new SqlSugarClient(Connection))
{
bool result = true;
R_Market model = new R_Market()
{
Name = req.Name,
Description = req.Description,
R_Restaurant_Id = req.Restaurant,
StartTime = req.StartTime,
EndTime = req.EndTime
};
if (db.Insert(model) == null)
{
result = false;
}
return(result);
}
}
public MarketCreateDTO GetModel(int id)
{
using (var db = new SqlSugarClient(Connection))
{
MarketCreateDTO result = null;
var model = db.Queryable <R_Market>().InSingle(id);
if (model != null)
{
result = new MarketCreateDTO()
{
Id = model.Id,
Name = model.Name,
Description = model.Description,
Restaurant = model.R_Restaurant_Id,
StartTime = model.StartTime,
EndTime = model.EndTime
};
}
return(result);
}
}
