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)); }