public IActionResult CapNhatSupplier([FromBody] SuppliersReq req)
{
var res = new SingleRsp();
res.Data = _svc.CapNhatSupplier(req);
return(Ok(res));
}
//Câu 2: Hàm gọi store 1b => cập nhật 1 record của bảng Supplier theo Supplier, sau khi cập nhật thành công trả về Supplier đã được cập nhật
public object CapNhatSupplier(SuppliersReq sup)
{
List <object> res = new List <object>();
var cnn = (SqlConnection)Context.Database.GetDbConnection();
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
try
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
var cmd = cnn.CreateCommand();
cmd.CommandText = "CapNhatSupplier";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SupplierID", sup.SupplierId);
cmd.Parameters.AddWithValue("@CompanyName", sup.CompanyName);
cmd.Parameters.AddWithValue("@ContactName", sup.ContactName);
cmd.Parameters.AddWithValue("@ContactTitle", sup.ContactTitle);
cmd.Parameters.AddWithValue("@Address", sup.Address);
cmd.Parameters.AddWithValue("@City", sup.City);
cmd.Parameters.AddWithValue("@Region", sup.Region);
cmd.Parameters.AddWithValue("@PostalCode", sup.PostalCode);
cmd.Parameters.AddWithValue("@Country", sup.Country);
cmd.Parameters.AddWithValue("@Phone", sup.Phone);
cmd.Parameters.AddWithValue("@Fax", sup.Fax);
cmd.Parameters.AddWithValue("@HomePage", sup.HomePage);
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
{
SupplierID = row["SupplierID"],
CompanyName = row["CompanyName"],
ContactName = row["ContactName"],
ContactTitle = row["ContactTitle"],
Address = row["Address"],
City = row["City"],
Region = row["Region"],
PostalCode = row["PostalCode"],
Country = row["Country"],
Phone = row["Phone"],
Fax = row["Fax"],
HomePage = row["HomePage"],
};
res.Add(x);
}
}
}
catch (Exception e)
{
res = null;
}
return(res);
}
public IActionResult UpdateSupiler([FromBody] SuppliersReq req)
{
var res = new SingleRsp();
var m = _svc.GetUpdateSupplier(req);
res.Data = m;
return(Ok(res));
}
public IActionResult AddNewSuplier([FromBody] SuppliersReq req)
{
var res = new SingleRsp();
var m = _svc.GetThemReCord(req);
res.Data = m;
return(Ok(res));
}
public object CapNhatSupplier(SuppliersReq req)
{
return(_rep.CapNhatSupplier(req));
}
public object ThemMoiSupplier(SuppliersReq req)
{
return(_rep.ThemMoiSupplier(req));
}
// Câu 2 b đề 4 Update Record cho bảng Supliers
#endregion
public object GetUpdateSupplier(SuppliersReq req)
{
return(_rep.UpdateSuplier(req.SupplierId, req.CompanyName, req.ContactName, req.ContactTitle, req.Address, req.City,
req.Region, req.PostalCode, req.Country, req.Phone, req.Fax, req.HomePage));
}
/// <summary>
/// Initialize
/// </summary>
// Câu 2 a đề 4 Thêm Record vào bảng Suppliers (Bước 3)
public object GetThemReCord(SuppliersReq req)
{
return(_rep.AddNewSuplier(req.CompanyName, req.ContactName, req.ContactTitle, req.Address, req.City,
req.Region, req.PostalCode, req.Country, req.Phone, req.Fax, req.HomePage));
}
