/// <summary>
/// This method inserts new salesman into the database.
/// </summary>
/// <param name="newSalesman"></param>
/// <returns></returns>
public int InsertSalesman(SalesmanBO newSalesman)
{
int rowInserted;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["firstDBConnectionString"].ConnectionString))
{
try
{
string query = "Insert into Salesman (salesman_id, name, city, comission) values (@Id, @Name, @City, @Commission) ";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@Id", Convert.ToInt32(newSalesman.Id));
cmd.Parameters.AddWithValue("@Name", (newSalesman.Name));
cmd.Parameters.AddWithValue("@City", (newSalesman.City));
cmd.Parameters.AddWithValue("@Commission", Convert.ToDecimal(newSalesman.Commission));
con.Open();
rowInserted = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
rowInserted = 0;
Console.WriteLine($"Error: {ex.Message}");
}
return(rowInserted);
}
}
/// <summary>
/// This is button click event and inserts new saleman on submit click.
/// </summary>
/// <param name="sender">sender Object.</param>
/// <param name="e">evnet arg.</param>
protected void SubmitBtn_Click(object sender, EventArgs e)
{
int rowInserted = 0;
SalesmanBO newSalesman = new SalesmanBO()
{
Id = Convert.ToInt32(this.SalesmanIdTxt.Text),
Name = this.SalesmanNameTxt.Text,
City = this.SalesmanCityTxt.Text,
Commission = Convert.ToDecimal(this.SalesmanCommissionTxt.Text),
};
SalesmanBL newSalesmanBL = new SalesmanBL();
rowInserted = newSalesmanBL.InsertSalesman(newSalesman);
if (rowInserted > 0)
{
Console.WriteLine($"Total {rowInserted} Row(s) Affected ");
}
this.SalesmanIdTxt.Text = string.Empty;
this.SalesmanNameTxt.Text = string.Empty;
this.SalesmanCityTxt.Text = string.Empty;
this.SalesmanCommissionTxt.Text = string.Empty;
this.SalesmanIdTxt.Focus();
this.SalesmanGv.DataSource = newSalesmanBL.GridViewBind();
this.SalesmanGv.DataBind();
}
/// <summary>
/// this method expects Business object of salesman and pass it to DataAccess model and from there it get back row affected.
/// </summary>
/// <param name="newSalesman"></param>
/// <returns></returns>
public int InsertSalesman(SalesmanBO newSalesman)
{
SalesmanDA newSalesmanDA = new SalesmanDA();
newSalesmanDA.InsertSalesman(newSalesman);
return(newSalesmanDA.InsertSalesman(newSalesman));
}