private void btnok_Click(object sender, EventArgs e)
{
if (passtxt.Text.Trim() == "")
{
MessageBox.Show("Please fill up the password field.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
passtxt.Focus();
passtxt.Text = "";
}
else if (passtxt.Text.Trim() != password)
{
MessageBox.Show("Invalid System Password.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
passtxt.Text = "";
passtxt.Focus();
}
else
{
if (catans != 1)
{
BalloonKingdomDataSetTableAdapters.CategoryTableAdapter addNewCat = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.CategoryTableAdapter();
addNewCat.AddNewCategory(ItemCatCombo, SubCatCombo, SpecCatCombo);
}
BalloonKingdomDataSetTableAdapters.InventoryTableAdapter updateInv = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.InventoryTableAdapter();
updateInv.UpdateInventoryRecord(ItemCatCombo, SubCatCombo, SpecCatCombo, AdItemNametxt, AdType, AdSizeStand, InvUnitcombo, AdColorExist, Convert.ToDecimal(AdCusWidtxt), Convert.ToDecimal(AdInvHeighttxt), AdSuppExist, Convert.ToInt32(InvItemIDtxt), Convert.ToInt32(InvItemIDtxt));
BalloonKingdomDataSetTableAdapters.ItemTableAdapter updateItem = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.ItemTableAdapter();
updateItem.UpdateCartItems(ItemCatCombo, SubCatCombo, SpecCatCombo, AdItemNametxt, AdSuppExist, Convert.ToDecimal(AdCusWidtxt), Convert.ToDecimal(AdInvHeighttxt), AdSizeStand, AdColorExist, AdType, InvUnitcombo, Convert.ToInt32(InvItemIDtxt));
MessageBox.Show("Record has been successfully updated.", "Update Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
private void frmDeliverRental_Load(object sender, EventArgs e)
{
try
{
conn = new SqlConnection();
conn.ConnectionString = str_conn;
conn.Open();
if (conn.State != ConnectionState.Open)
{
MessageBox.Show("Unable to connect to database", "Connection Status");
}
}
catch (Exception x)
{ MessageBox.Show(x.GetBaseException().ToString(), "Connection status"); }
renta *= 3;
RentSecurityAmt.Text = Convert.ToString(renta);
BalloonKingdomDataSetTableAdapters.ItemTableAdapter viewrent = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.ItemTableAdapter();
RentDataGrid.DataSource = viewrent.ViewRentItem(Convert.ToInt32(COFNumLbl.Text));
int totquanti = 0;
SqlCommand extract = new SqlCommand("Select * from Item where [COF Number]=" + "'" + COFNumLbl.Text + "'" + "And Type='Rental'", conn);
SqlDataReader drex = extract.ExecuteReader();
while (drex.Read())
{
unit[c] = drex["Unit"].ToString();
itemid[c] = drex["Item ID"].ToString();
itemnme[c] = drex["Item Name"].ToString();
cat[c] = drex["Category Name"].ToString();
subcat[c] = drex["Sub Category"].ToString();
speccat[c] = drex["Specific Category"].ToString();
quanti[c] = drex["Quantity"].ToString();
totquanti += Convert.ToInt32(drex["Quantity"].ToString());
c++;
}
drex.Close();
OverallQtyTxt.Text = Convert.ToString(totquanti);
}