private void btnAdd_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(tbSalesId.Text.Trim()) && !string.IsNullOrWhiteSpace(tbSalesName.Text.Trim()))
{
SalesBEL salesBEL = new SalesBEL();
salesBEL.Id = tbSalesId.Text.Trim();
salesBEL.Name = tbSalesName.Text.Trim();
salesBEL.IsEnable = "1";
SalesBLL.insertSales(salesBEL);
SetCurrentSales();
}
}
public static Int32 insertSales(SalesBEL objBel)
{
SalesDAL objDal = new SalesDAL();
try
{
return(objDal.insertSales(objBel));
}
catch (Exception ex)
{
throw;
}
finally
{
objDal = null;
}
}
public Int32 insertSales(SalesBEL objBEL)
{
int result;
try
{
SqlCommand cmd = new SqlCommand("dbo.sp_insertSales", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objBEL.Id);
cmd.Parameters.AddWithValue("@Name", objBEL.Name);
cmd.Parameters.AddWithValue("@IsEnable", objBEL.IsEnable);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
result = cmd.ExecuteNonQuery();
cmd.Dispose();
if (result > 0)
{
return(result);
}
else
{
return(0);
}
}
catch (Exception ex)
{
throw;
}
finally
{
if (con.State != ConnectionState.Closed)
{
con.Close();
}
}
}
