public void TestMethod3()
{
CarPoolingBLL bll = new CarPoolingBLL();
string strsql = "exec [ViewCarPoolingDetails] '','',''";
Assert.AreEqual(bll.ViewPoolingDetails(strsql).Tables[0].Columns.Count, 12);
// Assert.AreEqual( ds.Tables[0].Columns.Count,12);
}
public void BindGrid()
{
VDSI_EmpCarPooling_BLL.CarPoolingBLL objBll = new CarPoolingBLL();
string strsql = "exec [ViewCarPoolingDetails] '" + txtStPoint.Text + "','" + txtEndPoint.Text + "','" + txtTime.Text + "'";
DataSet ds = objBll.ViewPoolingDetails(strsql);
grdView.DataSource = ds;
grdView.DataBind();
}
public void Bindgrid()
{
string strsql = "exec ViewPoolingRequest '" + ddlStatus.SelectedValue + "'";
VDSI_EmpCarPooling_BLL.CarPoolingBLL objBll = new CarPoolingBLL();
DataSet ds = objBll.ViewPoolingDetails(strsql);
grdView.DataSource = ds;
grdView.DataBind();
}
protected void grdView_RowEditing(object sender, GridViewEditEventArgs e)
{
GridViewRow row = grdView.Rows[e.NewEditIndex];
int RespId = Convert.ToInt32(((Label)row.Cells[1].FindControl("lblReqId")).Text);
string strsql = " update poolingrequest set status =2 where id= " + RespId;
CarPoolingBLL carPoolingBll = new CarPoolingBLL();
carPoolingBll.ViewPoolingDetails(strsql);
lblMsg.Text = "Record has been Approved";
}