public ActionResult Input(string id = "")
{
try
{
if (string.IsNullOrEmpty(id))
{
ViewBag.Title = "Create new Supplier";
SuppliSer newSupplier = new SuppliSer()
{
SupplierID = 0
};
return(View(newSupplier));
}
else
{
ViewBag.Title = "Edit a Supplier";
SuppliSer editSupplier = CatalogBLL.GetSupplier(Convert.ToInt32(id));
if (editSupplier == null)
{
return(RedirectToAction("Index"));
}
return(View(editSupplier));
}
return(View());
} catch (Exception ex)
{
return(Content(ex.Message + ":" + ex.StackTrace));
}
}
public ActionResult Input(SuppliSer model)
{
try
{
//TODO:
if (string.IsNullOrEmpty(model.CompanyName))
{
ModelState.AddModelError("CompanyName", "CompanyName expected");
}
if (string.IsNullOrEmpty(model.ContactName))
{
ModelState.AddModelError("ContactName", "ContactName expected");
}
if (string.IsNullOrEmpty(model.ContactTitle))
{
ModelState.AddModelError("ContactTitle", "ContactTitle expected");
}
if (string.IsNullOrEmpty(model.Address))
{
model.Address = "";
}
if (string.IsNullOrEmpty(model.Country))
{
model.Country = "";
}
if (string.IsNullOrEmpty(model.City))
{
model.City = "";
}
if (string.IsNullOrEmpty(model.HomePage))
{
model.HomePage = "";
}
if (string.IsNullOrEmpty(model.Phone))
{
model.Phone = "";
}
if (string.IsNullOrEmpty(model.Fax))
{
model.Fax = "";
}
if (model.SupplierID == 0)
{
CatalogBLL.AddSupplier(model);
}
else
{
CatalogBLL.UpdateSupplier(model);
}
return(RedirectToAction("Index"));
}catch (Exception ex)
{
ModelState.AddModelError("", ex.Message + ":" + ex.StackTrace);
return(View(model));
}
}
/// <summary>
///
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int Add(SuppliSer data)
{
int supplierId = 0;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"INSERT INTO Suppliers
(
CompanyName,
ContactName,
ContactTitle,
Address,
City,
Country,
Phone,
Fax,
HomePage
)
VALUES
(
@CompanyName,
@ContactName,
@ContactTitle,
@Address,
@City,
@Country,
@Phone,
@Fax,
@HomePage
);
SELECT @@IDENTITY;";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@CompanyName", data.CompanyName);
cmd.Parameters.AddWithValue("@ContactName", data.ContactName);
cmd.Parameters.AddWithValue("@ContactTitle", data.ContactTitle);
cmd.Parameters.AddWithValue("@Address", data.Address);
cmd.Parameters.AddWithValue("@City", data.City);
cmd.Parameters.AddWithValue("@Country", data.Country);
cmd.Parameters.AddWithValue("@Phone", data.Phone);
cmd.Parameters.AddWithValue("@Fax", data.Fax);
cmd.Parameters.AddWithValue("@HomePage", data.HomePage);
supplierId = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
}
return(supplierId);
}
/// <summary>
///
/// </summary>
/// <param name="date"></param>
/// <returns></returns>
public bool Update(SuppliSer data)
{
int rowsAffected = 0;
using (SqlConnection connection = new SqlConnection(this.connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"UPDATE Suppliers
SET CompanyName = @CompanyName
,ContactName = @ContactName
,ContactTitle = @ContactTitle
,Address = @Address
,City = @City
,Country = @Country
,Phone = @Phone
,Fax = @Fax
,HomePage = @HomePage
WHERE SupplierID = @SupplierID";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@SupplierID", data.SupplierID);
cmd.Parameters.AddWithValue("@CompanyName", data.CompanyName);
cmd.Parameters.AddWithValue("@ContactName", data.ContactName);
cmd.Parameters.AddWithValue("@ContactTitle", data.ContactTitle);
cmd.Parameters.AddWithValue("@Address", data.Address);
cmd.Parameters.AddWithValue("@City", data.City);
cmd.Parameters.AddWithValue("@Country", data.Country);
cmd.Parameters.AddWithValue("@Phone", data.Phone);
cmd.Parameters.AddWithValue("@Fax", data.Fax);
cmd.Parameters.AddWithValue("@HomePage", data.HomePage);
rowsAffected = Convert.ToInt32(cmd.ExecuteNonQuery());
connection.Close();
}
return(rowsAffected > 0);
}
/// <summary>
///
/// </summary>
/// <param name="supplierID"></param>
/// <returns></returns>
public SuppliSer Get(int supplierID)
{
SuppliSer data = null;
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"SELECT * FROM Suppliers WHERE SupplierID = @supplierID";
cmd.CommandType = CommandType.Text;
cmd.Connection = connection;
cmd.Parameters.AddWithValue("@supplierID", supplierID);
using (SqlDataReader dbReader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
if (dbReader.Read())
{
data = new SuppliSer()
{
SupplierID = Convert.ToInt32(dbReader["SupplierID"]),
CompanyName = Convert.ToString(dbReader["CompanyName"]),
ContactName = Convert.ToString(dbReader["ContactName"]),
ContactTitle = Convert.ToString(dbReader["ContactTitle"]),
Address = Convert.ToString(dbReader["Address"]),
City = Convert.ToString(dbReader["City"]),
Country = Convert.ToString(dbReader["Country"]),
Phone = Convert.ToString(dbReader["Phone"]),
Fax = Convert.ToString(dbReader["Fax"]),
HomePage = Convert.ToString(dbReader["HomePage"])
};
}
}
connection.Close();
}
return(data);
}
/// <summary>
/// sửa 1 supplier
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static bool UpdateSupplier(SuppliSer data)
{
return(SupplierDB.Update(data));
}
/// <summary>
/// thêm 1 supplier
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static int AddSupplier(SuppliSer data)
{
return(SupplierDB.Add(data));
}
