public static void UpdateTaxLevel(ItemTaxLevel aItemTaxLevel)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("UPDATE TaxLevel SET Percentage=@Percentage,Description=@Description WHERE ID=@ID", Helper.Instance.con);
cmd.Parameters.Add("@Percentage", SqlDbType.NVarChar).Value = aItemTaxLevel.Item_Tax_Percentage;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = aItemTaxLevel.Item_Tax_Description;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = aItemTaxLevel.Item_Tax_ID;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
}
catch (Exception ex)
{
MessageBox.Show("ERROR IN *ItemTaxLevel* MGMT (UpdateTaxLevel FUNCTION) EX=" + ex.Message.ToString());
}
}
}
public static bool AddTaxLevel(ItemTaxLevel aItemTaxLevel)
{
if (Helper.Instance.con.State == ConnectionState.Closed)
{
try
{
Helper.Instance.con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO TaxLevel (Percentage,Description) VALUES (@Percentage,@Description)", Helper.Instance.con);
cmd.Parameters.Add("@Percentage", SqlDbType.NVarChar).Value = aItemTaxLevel.Item_Tax_Percentage;
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = aItemTaxLevel.Item_Tax_Description;
cmd.ExecuteNonQuery();
Helper.Instance.con.Close();
return(true);
}
catch (Exception ex)
{
Helper.Instance.con.Close();
MessageBox.Show("ERROR IN *ItemTaxLevel* MGMT (AddTaxLevel FUNCTION) EX=" + ex.Message.ToString());
return(false);
}
}
return(false);
}
private void AddTaxBtn_Click(object sender, EventArgs e)
{
try
{
double TestParser;
if (Validators.TxtBoxNotEmpty(PercentageTxtBox.Text) && Validators.TxtBoxNotEmpty(DescriptionTxtBox.Text))
{
if (!double.TryParse(PercentageTxtBox.Text, out TestParser))
{
MessageBox.Show(MsgTxt.PleaseSelectCorrectAmountTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
PercentageTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
return;
}
else
{
PercentageTxtBox.BackColor = PercentageBGColor;
}
Nullable <int> Check = ItemTaxLevelMgmt.IsTaxLevelUsed(PercentageTxtBox.Text);
if (Check == 10)
{
ItemTaxLevel aItemTaxLevel = new ItemTaxLevel();
aItemTaxLevel.Item_Tax_Percentage = PercentageTxtBox.Text;
aItemTaxLevel.Item_Tax_Description = DescriptionTxtBox.Text;
if (ItemTaxLevelMgmt.AddTaxLevel(aItemTaxLevel))
{
MessageBox.Show(MsgTxt.AddedSuccessfully, MsgTxt.AddedSuccessfully, MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show(MsgTxt.UnexpectedError + " \n[DataBase Error]:IN [AddTaxBtn_Click]" + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
else if (Check == 5)
{
MessageBox.Show(MsgTxt.PercentageTxt + " [ " + PercentageTxtBox.Text + " ] " + MsgTxt.AlreadyUsedTxt, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (Check == null)
{
MessageBox.Show(MsgTxt.UnexpectedError + " \n[DataBase Error2]:IN [AddTaxBtn_Click]" + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}
else
{
MessageBox.Show(MsgTxt.PleaseAddAllRequiredFields, MsgTxt.WarningCaption, MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (!Validators.TxtBoxNotEmpty(DescriptionTxtBox.Text))
{
DescriptionTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
DescriptionTxtBox.Focus();
}
else
{
DescriptionTxtBox.BackColor = DescriptionBGColor;
}
if (!Validators.TxtBoxNotEmpty(PercentageTxtBox.Text))
{
PercentageTxtBox.BackColor = SharedVariables.TxtBoxRequiredColor;
PercentageTxtBox.Focus();
}
else
{
PercentageTxtBox.BackColor = PercentageBGColor;
}
}
}
catch (Exception ex)
{
MessageBox.Show(MsgTxt.UnexpectedError + " \n[Exception]:IN [AddUserBtn_Click]" + "\n" + ex.ToString() + "\n" + MsgTxt.FormWillCloseNowTxt, MsgTxt.ErrorCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Close();
}
}