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