public void Update() { GvOrder.Columns[3].Visible = Editable; GvOrder.Columns[4].Visible = Editable; GvOrder.DataSource = TableOrder; GvOrder.DataBind(); }
protected void BtnCancel_Click(object sender, EventArgs e) { int index = GvOrder.SelectedIndex; int id = Convert.ToInt32(GvOrder.Rows[index].Cells[1].Text); string connectionString = ConfigurationManager.ConnectionStrings["CSharpAssignmentConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); string sql = "Update Booking SET StatusID = @statusID WHERE ID = @id"; SqlCommand com = new SqlCommand(sql, conn); com.Parameters.AddWithValue("@statusID", STATUS_CANCELLED); com.Parameters.AddWithValue("@id", id); if (com.ExecuteNonQuery() > 0) { GvOrder.DataBind(); BtnAccept.Visible = false; BtnCancel.Visible = false; } } finally { conn.Close(); } }
public void bindAllOrder() { DataSet ds = new DataSet(); List <ParaList> para = new List <ParaList>() { new ParaList { Key = "@i_CompId", Value = CurrentUser.CompId }, }; ds = crmclient.list(para, "SalesInvoice"); if (ds.Tables[0].Rows.Count > 0) { GvOrder.DataSource = ds.Tables[0]; GvOrder.DataBind(); } }
protected void BtnAccept_Click(object sender, EventArgs e) { int index = GvOrder.SelectedIndex; int id = Convert.ToInt32(GvOrder.Rows[index].Cells[1].Text); string connectionString = ConfigurationManager.ConnectionStrings["CSharpAssignmentConnectionString"].ConnectionString; SqlConnection conn = new SqlConnection(connectionString); GridViewRowCollection rows = GvOrderDetail.Rows; for (int i = 0; i < GvOrderDetail.Rows.Count; i++) { ProductDAO products = new ProductDAO(); TableCell productId = GvOrderDetail.Rows[i].Cells[0]; TableCell quanitity = GvOrderDetail.Rows[i].Cells[4]; int proId = Convert.ToInt32(productId.Text.ToString()); int quan = Convert.ToInt32(quanitity.Text.ToString()); int currentQuantity = products.GetQuantityOfProduct(proId); bool updateQuantity = products.UpdateQuantityOfProduct(proId, currentQuantity - quan); } try { conn.Open(); string sql = "Update Booking SET StatusID = @statusID WHERE ID = @id"; SqlCommand com = new SqlCommand(sql, conn); com.Parameters.AddWithValue("@statusID", STATUS_ACCEPTED); com.Parameters.AddWithValue("@id", id); if (com.ExecuteNonQuery() > 0) { GvOrder.DataBind(); BtnAccept.Visible = false; BtnCancel.Visible = false; } } finally { conn.Close(); } }