private void btnSave_Click(object sender, EventArgs e)
{
ShopInfo_DTO shop = new ShopInfo_DTO(tbName.Text, tbPhone.Text, tbAddress.Text, tbWifi.Text, tbFacebook.Text, tbTime.Text);
ShopInfo_BUS.EditShopInfo(shop);
this.Close();
}
public static void EditShopInfo(ShopInfo_DTO shop)
{
SqlConnection cnn = ConnectToSQL.Connect();
SqlCommand cmd = new SqlCommand("editShopInfo", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Name", SqlDbType.NVarChar, 100);
cmd.Parameters["@Name"].Value = shop.Name;
cmd.Parameters.Add("@Wifi", SqlDbType.NVarChar, 200);
cmd.Parameters["@Wifi"].Value = shop.Wifi;
cmd.Parameters.Add("@Facebook", SqlDbType.NVarChar, 200);
cmd.Parameters["@Facebook"].Value = shop.Facebook;
cmd.Parameters.Add("@Address", SqlDbType.NVarChar, 200);
cmd.Parameters["@Address"].Value = shop.Address;
cmd.Parameters.Add("@OpenAndCloseTime", SqlDbType.NVarChar, 200);
cmd.Parameters["@OpenAndCloseTime"].Value = shop.Time;
cmd.Parameters.Add("@Phone", SqlDbType.NVarChar, 200);
cmd.Parameters["@Phone"].Value = shop.Phone;
cnn.Open();
cmd.ExecuteNonQuery();
cnn.Close();
}
public static void EditShopInfo(ShopInfo_DTO shop)
{
ShopInfo_DAO.EditShopInfo(shop);
}
