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()
{
string strsql = "exec ViewPoolingRequest '" + ddlStatus.SelectedValue + "'";
VDSI_EmpCarPooling_BLL.CarPoolingBLL objBll = new CarPoolingBLL();
DataSet ds = objBll.ViewPoolingDetails(strsql);
grdView.DataSource = ds;
grdView.DataBind();
}
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();
}
protected void btnRegister_Click(object sender, EventArgs e)
{
CarPoolingBLL carPoolingBll = new CarPoolingBLL();
string strsql = "exec InsertRegDetails '" + Session["EmpId"].ToString() + "','" + txtEmail.Text + "','" + txtFrom.Text + "','" + txtTo.Text + "','" + txtVia.Text+ "','" +txtInTime.Text + "','" +txtOutTime.Text + "','" + txtseats.Text + "'" ;
carPoolingBll.insertRegistrationDetails(strsql);
lblMsg.Text = "Registration is Succesfully";
// Page.ClientScript.RegisterClientScriptBlock(this.GetType(),"test","javascript:alert(created Sucessfully)","window.location:Close();",1)
}
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";
}
public void TestMethod4()
{
try
{
CarPoolingBLL bll = new CarPoolingBLL();
bll.insertRegistrationDetails("exec InsertRegDetails '1234','a4@ggs','porur','guindy','ramapuram','10','11','1'");
}
catch
{
Assert.Fail();
}
}
protected void btnRegister_Click(object sender, EventArgs e)
{
CARREGDETAILDTO carRegDetail = new CARREGDETAILDTO();
carRegDetail.Email = txtEmail.Text;
carRegDetail.EmpId = txtEmpId.Text;
carRegDetail.From = txtFrom.Text;
carRegDetail.To = txtTo.Text;
carRegDetail.InTime = txtInTime.Text;
carRegDetail.OutTime = txtOutTime.Text;
carRegDetail.Via = txtVia.Text;
CarPoolingBLL bll = new CarPoolingBLL();
bll.insertRegistrationDetails(carRegDetail);
}
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 RespPerson = ((TextBox)row.Cells[5].FindControl("txtName")).Text;
string RespSeat = ((TextBox)row.Cells[6].FindControl("txtSeats")).Text;
string RespBoarding = ((TextBox)row.Cells[7].FindControl("txtBoarding")).Text;
string RespNo = ((TextBox)row.Cells[7].FindControl("txtNo")).Text;
string strsql = "exec InsertPoolingRequest " + RespId + ",'1234','" + RespSeat + "','" + RespBoarding + "','" + RespNo + "','" + RespPerson +"'";
CarPoolingBLL carPoolingBll = new CarPoolingBLL();
carPoolingBll.insertRegistrationDetails(strsql);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtUserName.Text) && !string.IsNullOrEmpty(txtPassword.Text))
{
CarPoolingBLL carPoolingBll = new CarPoolingBLL();
string empId = carPoolingBll.getLoginDetails(txtUserName.Text, txtPassword.Text);
if (!string.IsNullOrEmpty(empId))
{
Session["EmpId"] = empId;
Response.Redirect("Menupage.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Notify", "alert('Notification : Invalid Username Or Password.');", true);
}
}
}
public void TestMethod1()
{
CarPoolingBLL bll = new CarPoolingBLL();
string result = bll.getLoginDetails("Arun", "Arun");
Assert.AreEqual(result, "1234");
}
