public DataTable GetOrders(BO_CRM objCRM)
{
DAL objDAL = new DAL();
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = objDAL.AddParameter("@CustomerId", objCRM.CustomerId, SqlDbType.VarChar, 100);
DataTable dt = objDAL.ExecuteDTByProcedure("SP_GetAllOrders", parameters);
return(dt);
}
public void AddNewOrder(BO_CRM objCRM)
{
DAL objDAL = new DAL();
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = objDAL.AddParameter("@OrderDate", objCRM.OrderDate, SqlDbType.Date, 100);
parameters[1] = objDAL.AddParameter("@OrderNumber", objCRM.OrderNumber, SqlDbType.VarChar, 10);
parameters[2] = objDAL.AddParameter("@CustomerId", objCRM.CustomerId, SqlDbType.Int, 100);
parameters[3] = objDAL.AddParameter("@TotalAmount", objCRM.TotalAmount, SqlDbType.Decimal, 12);
objDAL.ExecuteDTByProcedure("SP_AddNewOrder", parameters);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
BO_CRM objCRM = new BO_CRM();
BLL objBLL = new BLL();
objCRM.OrderDate = Convert.ToDateTime(txtOrderDate.Text); //Convert.ToDateTime(txtOrderDate.Text);
objCRM.OrderNumber = txtOrderNumber.Text;
objCRM.CustomerId = Convert.ToInt32(txtCustomerId.Text);
objCRM.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
objBLL.AddNewOrder(objCRM);
Response.Redirect("~/AddNewOrder.aspx?alert=success");
}
protected void Page_Load(object sender, EventArgs e)
{
BO_CRM objCRM = new BO_CRM();
BLL objBLL = new BLL();
objCRM.CustomerId = 0;
DataTable dt = objBLL.GetOrders(objCRM);;
GridView2.DataSource = dt;
GridView2.DataBind();
if (dt.Rows.Count > 0)
{
DropDownList1.DataValueField = "Order Id"; //"Id";
DropDownList1.DataTextField = "Order Number"; //"OrderNumber";
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
txtOrderNumber.Text = dt.Rows[4][2].ToString();
}
//in-line query
string CS = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
using (SqlConnection conn = new SqlConnection(CS))
{
string sql = string.Format(@"select * from Customer");
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
//SqlDataAdapter adapter = new SqlDataAdapter();
SqlDataReader dr = cmd.ExecuteReader();
DropDownList2.DataSource = dr;
DropDownList2.DataValueField = "Id";
DropDownList2.DataTextField = "FirstName";
DropDownList2.DataBind();
}
}
