protected void btnSubmit_Click(object sender, EventArgs e)
{
BO_Retail objRetail = new BO_Retail();
BLL objBLL = new BLL();
objRetail.OrderNumber = txtOrderNumber.Text;
objRetail.OrderDate = Convert.ToDateTime(txtOrderDate.Text);
objRetail.CustomerId = Convert.ToInt32(ddlCustomer.Text);
objRetail.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
objBLL.AddNewOrder(objRetail);
Response.Redirect("~/AddNewOrder.aspx?alert=success");
}
public void AddNewOrder(BO_Retail objRetail)
{
DAL objDAL = new DAL();
DataTable dt = new DataTable();
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = objDAL.AddParameter("@OrderDate", objRetail.OrderDate, SqlDbType.DateTime, 100);
parameters[1] = objDAL.AddParameter("@OrderNumber", objRetail.OrderNumber, SqlDbType.VarChar, 10);
parameters[2] = objDAL.AddParameter("@CustomerId", objRetail.CustomerId, SqlDbType.Int, 100);
parameters[3] = objDAL.AddParameter("@TotalAmount", objRetail.TotalAmount, SqlDbType.Decimal, 12);
dt = objDAL.ExecuteDTByProcedure("SP_AddNewOrder", parameters);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
BLL objBLL = new BLL();
BO_Retail objRetail = new BO_Retail();
objRetail.FirstName = txtFirstName.Text;
objRetail.LastName = txtLastName.Text;
objRetail.City = txtCity.Text;
objRetail.Country = txtCountry.Text;
objRetail.PhoneNo = txtPhoneNo.Text;
objBLL.AddNewCustomer(objRetail);
Response.Redirect("~/AddNewCustomer.aspx?alert=success");
}
public void AddNewCustomer(BO_Retail objRetail)
{
DAL objDAL = new DAL();
DataTable dt = new DataTable();
SqlParameter[] parameters = new SqlParameter[5];
parameters[0] = objDAL.AddParameter("@FirstName", objRetail.FirstName, SqlDbType.VarChar, 100);
parameters[1] = objDAL.AddParameter("@LastName", objRetail.LastName, SqlDbType.VarChar, 100);
parameters[2] = objDAL.AddParameter("@City", objRetail.City, SqlDbType.VarChar, 100);
parameters[3] = objDAL.AddParameter("@Country", objRetail.Country, SqlDbType.VarChar, 100);
parameters[4] = objDAL.AddParameter("@Phone", objRetail.PhoneNo, SqlDbType.VarChar, 100);
dt = objDAL.ExecuteDTByProcedure("SP_AddNewCustomer", parameters);
}
