public HttpResponseMessage PostGiay(Giay1 giay1) { var response = Request.CreateResponse <Giay1>(HttpStatusCode.Created, null); string uri = Url.Link("GiayApi", null); response.Headers.Location = new Uri(uri); return(response); }
private void CbxMaGiay_SelectedValueChanged(object sender, EventArgs e) { ComboBox combo = sender as ComboBox; if (combo.SelectedValue != null) { Giay1 g = combo.SelectedValue as Giay1; id_g = g.MaGiay.ToString(); } }
public HttpResponseMessage PutGiay(Giay1 giay1) { //GiayServices.setGiay(giay1.MaGiay, giay1.TenGiay, giay1.DaXoa, giay1.MaHieuGiay); var response = Request.CreateResponse <Giay1>(HttpStatusCode.Created, null); string uri = Url.Link("GiayApi", null); response.Headers.Location = new Uri(uri); return(response); }
public static void DelGiay(Giay1 giay) { string connectionString = String.Format("Server={0};Database={1};Integrated Security={2};", Properties.Resources.ServerName, Properties.Resources.DatabaseName, Properties.Resources.Integrated_Security ); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("DEL_GIAY", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@MAGiAY", giay.MaGiay)); cmd.ExecuteNonQuery(); } }
public static void AddGiay(Giay1 giay) { string connectionString = String.Format("Server={0};Database={1};Integrated Security={2};", Properties.Resources.ServerName, Properties.Resources.DatabaseName, Properties.Resources.Integrated_Security ); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand("ADD_GIAY", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@TENGIAY", giay.TenGiay)); cmd.Parameters.Add(new SqlParameter("@MAHIEUGIAY", giay.MaHieuGiay)); cmd.Parameters.Add(new SqlParameter("@GIASI", giay.GiaSi)); cmd.Parameters.Add(new SqlParameter("@GIALE", giay.Giale)); cmd.Parameters.Add(new SqlParameter("@NGAYLAP", giay.Ngaylap)); cmd.ExecuteNonQuery(); } }