public string tierDataInsertDAL(tierDataBAL tBAL)
{
dbc.mycon();
dbc.cmd = new SqlCommand("Insert into tier values(@nm,@pswd)", dbc.con);
dbc.cmd.Parameters.AddWithValue("@nm", tBAL.username);
dbc.cmd.Parameters.AddWithValue("@pswd", tBAL.password);
dbc.cmd.ExecuteNonQuery();
return("Data success fully inserted");
}
public string tierDataSelectDAL(tierDataBAL tBAL)
{
dbc.mycon();
dbc.cmd = new SqlCommand("select * from tier where uname=@un", dbc.con);
dbc.cmd.Parameters.AddWithValue("un", tBAL.username);
SqlDataAdapter da = new SqlDataAdapter(dbc.cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
string s1 = ds.Tables[0].Rows[0][0].ToString();
string s2 = ds.Tables[0].Rows[0]["password"].ToString();
return(s1 + "<br>" + s2);
}
else
{
return("Data is not avaliable");
}
}
public string tierDataSelectBLL(tierDataBAL tBAL)
{
tierDataDAL tDAL = new tierDataDAL();
return(tDAL.tierDataSelectDAL(tBAL));
}
public string tierInsertDataBLL(tierDataBAL tBAL)
{
tierDataDAL tDAL = new tierDataDAL();
return(tDAL.tierDataInsertDAL(tBAL));
}
