public IActionResult CapNhatShipper([FromBody] ShippersReq req)
{
var res = new SingleRsp();
res.Data = _svc.CapNhatShipper(req);
return(Ok(res));
}
public IActionResult UpdateShippADO([FromBody] ShippersReq req)
{
var res = new SingleRsp();
var hist = _svc.UpdateShippADO(req);
res.Data = hist;
return(Ok(res));
}
public Shippers ThemMoiShipper(ShippersReq req)
{
Shippers ship = new Shippers();
ship.CompanyName = req.CompanyName;
ship.Phone = req.Phone;
return(_rep.ThemMoiShipper(ship));
}
//Câu 3 LINQ đề 4
public Shippers UpdateShip_LINQ(ShippersReq req)
{
Shippers ship = new Shippers();
ship.ShipperId = req.Id;
ship.CompanyName = req.CompanyName;
ship.Phone = req.Phone;
return(_rep.UpdateShip_LINQ(ship));
}
public SingleRsp De4_2_CapNhat1RecrdShipperTraVeRecrdDaThem_LinQ(ShippersReq ship)
{
var res = new SingleRsp();
Shippers shipper = new Shippers();
shipper.ShipperId = ship.ShipperID;
shipper.CompanyName = ship.CompanyName;
shipper.Phone = ship.Phone;
res = _rep.De4_2_CapNhat1RecrdShipperTraVeRecrdDaThem_LinQ(shipper);
return(res);
}
//Đề 4:
//Câu 3: Hàm cập nhật record cho bảng Shipper theo ShipperID
public object CapNhatShipper(ShippersReq ship)
{
List <object> res = new List <object>();
var cnn = (SqlConnection)Context.Database.GetDbConnection();
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
try
{
string sql = "update [dbo].[Shippers] set [CompanyName] = '" + ship.CompanyName + "', [Phone] = '" + ship.Phone + "'";
sql = sql + "where ShipperID = '" + ship.ShipperId + "'";
sql = sql + "select * from [dbo].[Shippers] where ShipperID = '" + ship.ShipperId + "'";
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
var cmd = cnn.CreateCommand();
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
da.SelectCommand = cmd;
da.Fill(ds);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
var x = new
{
ShipperId = row["ShipperID"],
CompanyName = row["CompanyName"],
Phone = row["Phone"]
};
res.Add(x);
}
}
}
catch (Exception e)
{
res = null;
}
return(res);
}
public SingleRsp CreateShippers(ShippersReq req)
{
var res = new SingleRsp();
try
{
Shippers c = new Shippers();
//c.ShipperId = req.ShipperId; // Vi ID tu tang nen khong go
c.CompanyName = req.CompanyName;
c.Phone = req.Phone;
//
res = base.Create(c);
res.Data = c;
}
catch (Exception ex)
{
res.SetError(ex.StackTrace);
}
return(res);
}
public IActionResult CreateShippers(ShippersReq req)
{
var res = _svc.CreateShippers(req);
return(Ok(res));
}
public object CapNhatShipper(ShippersReq req)
{
return(_rep.CapNhatShipper(req));
}
public IActionResult De4_2_CapNhat1RecrdShipperTraVeRecrdDaThem_LinQ([FromBody] ShippersReq req)
{
var res = _svc.De4_2_CapNhat1RecrdShipperTraVeRecrdDaThem_LinQ(req);
return(Ok(res));
}
public IActionResult De4_2_Them1RecrdShipperTraVeRecrdDaThem([FromBody] ShippersReq req)
{
var res = _svc.De4_2_Them1RecrdShipperTraVeRecrdDaThem(req.CompanyName, req.Phone);
return(Ok(res));
}
