/// <summary>
/// 4b: Sửa mới 1 nhà cung cấp
/// </summary>
/// <param name="sup"></param>
/// <returns>Nhà cung cấp mới sửa</returns>
public object UpdateSupplier(SupplierReq sup)
{
object res = new 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 = "sp_UpdateSupplier";
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.CompanyName);
cmd.Parameters.AddWithValue("@City", sup.CompanyName);
cmd.Parameters.AddWithValue("@Region", sup.CompanyName);
cmd.Parameters.AddWithValue("@PostalCode", sup.CompanyName);
cmd.Parameters.AddWithValue("@Country", sup.CompanyName);
cmd.Parameters.AddWithValue("@Phone", sup.CompanyName);
cmd.Parameters.AddWithValue("@Fax", sup.CompanyName);
cmd.Parameters.AddWithValue("@HomePage", sup.CompanyName);
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 = x;
}
}
}
catch (Exception ex)
{
res = null;
}
return(res);
}
public SingleRsp UpdateSupplier(SupplierReq spl)
{
var res = new SingleRsp();
Suppliers suppliers = new Suppliers();
suppliers = _rep.Read(spl.SuppliersId);
suppliers.SuppliersName = spl.SuppliersName;
suppliers.City = spl.City;
res = _rep.UpdateSupplier(suppliers);
return(res);
}
public SingleRsp UpdateSupplier_Linq(SupplierReq req)
{
var res = new SingleRsp();
Suppliers sup = new Suppliers();
sup.SupplierId = req.SupplierId;
sup.CompanyName = req.CompanyName;
sup.ContactName = req.ContactName;
sup.ContactTitle = req.ContactTitle;
sup.Address = req.Address;
sup.City = req.City;
sup.Region = req.Region;
sup.PostalCode = req.PostalCode;
sup.Country = req.Country;
sup.Phone = req.Phone;
sup.Fax = req.Fax;
sup.HomePage = req.HomePage;
res = _rep.UpdateSupplier_Linq(sup);
res.Data = sup;
return(res);
}
public IActionResult UpdateSupplier_Linq([FromBody] SupplierReq req)
{
var res = _svc.UpdateSupplier_Linq(req);
return(Ok(res));
}
public IActionResult AddSupplier([FromBody] SupplierReq req)
{
var res = _svc.AddSupplier(req);
return(Ok(res));
}
public IActionResult DeleteSuppliers(SupplierReq req)
{
var res = _svc.DeleteSuppliers(req.SuppliersId);
return(Ok(res));
}
/// <summary>
/// 4b: Sửa mới 1 nhà cung cấp
/// </summary>
/// <param name="sup"></param>
/// <returns>Nhà cung cấp mới sửa</returns>
public object UpdateSupplier(SupplierReq req)
{
return(_rep.UpdateSupplier(req));
}
/// <summary>
/// 4a: Thêm mới 1 nhà cung cấp
/// </summary>
/// <param name="sup"></param>
/// <returns>Nhà cung cấp mới thêm</returns>
public object AddSupplier(SupplierReq req)
{
return(_rep.AddSupplier(req));
}
