} //End Of Insert Function
public static void InsertData(SalesManInfoClass stock)
{
string query = "INSERT INTO SalesManTable (SalesmanName,SalesmanQualification,SalesmanCity,SalesmanPhoneNumber ) VALUES('" + stock.Name.ToUpper() + "','" + stock.Qualification.ToUpper() + "','" + stock.City.ToUpper() + "' ,'" + stock.Number + "');";
try
{
DataTable _dtable = null;
_dtable = dbAccess.ReadDataFromDb(query);
}
catch (Exception ex)
{ throw ex; }
} //End Of Insert Function
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == "" || txtNumber.Text == "")
{
MessageBox.Show("Please Fill The Form Above.");
}
else
{
SalesManInfoClass ps = new SalesManInfoClass();
try
{
ps.Name = txtName.Text.Trim();
ps.Qualification = txtQualification.Text.Trim();
ps.City = txtCity.Text;
ps.Number = txtNumber.Text;
QueryClass.InsertData(ps);
MessageBox.Show("Add Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error", ex.Message);
}
}
}