private void updateRow()
{
SqlDataSourceUpdate.UpdateParameters["modelo"].DefaultValue = textBoxModelo.Text;
SqlDataSourceUpdate.UpdateParameters["id_Zapato"].DefaultValue = labelId.Text;
SqlDataSourceUpdate.UpdateParameters["descripcion"].DefaultValue = TextBoxDescripcion.Text;
SqlDataSourceUpdate.UpdateParameters["fk_color"].DefaultValue = ddlColour.SelectedValue;
SqlDataSourceUpdate.UpdateParameters["fk_talla"].DefaultValue = ddlSize.SelectedValue;
SqlDataSourceUpdate.UpdateParameters["fk_estilo"].DefaultValue = ddlStyle.SelectedValue;
SqlDataSourceUpdate.UpdateParameters["fk_linea"].DefaultValue = ddlLine.SelectedValue;
try
{
SqlDataSourceUpdate.Update();
}
catch (Exception except)
{
Messagebox("No se Pudo Actualizar: " + except);
}
Response.Redirect("default");
}
protected void btnBuy_Click(object sender, EventArgs e)
{
decimal CustomerBalance;
decimal Price = 0;
decimal CashInHand;
decimal AdminBalance = 0;
decimal SellerBalance = 0;
decimal AgencyFee;
//Retrieve Customer Balance which meet account number and security code from Account
DataView dv = (DataView)AccountDS.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView dr in dv)
{
if (txtAccountNumber.Text == dr[0].ToString() && txtSecurityCode.Text == dr[1].ToString())
{
CustomerBalance = decimal.Parse(dr[2].ToString());
//Retrieve Price from Item
DataView dv1 = (DataView)ItemDS.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView dr1 in dv1)
{
Price = decimal.Parse(dr1[5].ToString()); //Retrieve Price From Item
}
if (CustomerBalance > Price)
{
CashInHand = CustomerBalance - Price;
if (CashInHand >= 1000)
{
Session["Balance"] = CashInHand.ToString();
AccountDS.Update();
txtAccountNumber.Text = "";
txtSecurityCode.Text = "";
//Retrieve Admin Balance from Account and plus agency fee and update it
DataView dv2 = (DataView)AccountForAdminDS.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView dr2 in dv2)
{
AdminBalance = decimal.Parse(dr2[0].ToString());
break;
}
AdminBalance = AdminBalance + (Price * (decimal)0.05);
Session["Balance"] = AdminBalance.ToString();
AccountForAdminDS.Update();
//Retrieve Seller Balance and plus item's amount
DataView dv3 = (DataView)AccountForSellerDS.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView dr3 in dv3)
{
SellerBalance = decimal.Parse(dr3[0].ToString());
}
SellerBalance = SellerBalance + (Price - (Price * (decimal)0.05));
Session["Balance"] = SellerBalance.ToString();
AccountForSellerDS.Update();
Session["PurchaseDate"] = DateTime.Now.ToShortDateString();
SqlDataSourceUpdate.Update();
int pid;
try
{
SqlConnection conn = new SqlConnection(@"Data Source=LAEMON-PC\GROUP3_SERVER;Initial Catalog=ITSocietyDB;User ID=sa;Password=group3");
SqlCommand cmd = new SqlCommand("select max(purchaseID) from PurchaseInfo", conn);
conn.Open();
SqlDataReader rader1 = cmd.ExecuteReader();
rader1.Read();
pid = int.Parse(rader1[0].ToString());
pid++;
conn.Close();
}
catch (Exception)
{
pid = 1;
}
Session["pid"] = pid;
PurchaseDS.Insert();
lblMsg.Text = "Successfully Purchased! Thank You For Purchasing";
lbtnPurchase.Visible = false;
pnlPurchase.Visible = false;
break;
}
else
{
lblMsg.Text = "Your Balance is lower than 1000 Kyats!";
}
}
else
{
lblMsg.Text = "Your Balance is not enough for purchase!";
}
break;
}
else
{
lblMsg.Text = "Your Informatin is not Valid!";
}
}
}
