public DataTable ChangePasswordFirst(plTrRegister pl)
{
DataTable dt = new DataTable();
dt = dl.ChangePasswordFirst(pl);
return(dt);
}
public DataSet GetUserLoginID(plTrRegister pl)
{
DataSet ds = new DataSet();
ds = dl.GetUserLoginID(pl);
return(ds);
}
public DataTable UpdateInvalidAttempts(plTrRegister pl)
{
DataTable dt = new DataTable();
dt = dl.UpdateInvalidAttempts(pl);
return(dt);
}
public DataTable GetLoginDetailsfromservice(plTrRegister pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", 11);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.LoginPwd);
da = new SqlDataAdapter(cmd);
pl.dt = new DataTable();
da.Fill(pl.dt);
return(pl.dt);
}
public int CheckLockInd(plTrRegister pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
return(i);
}
public DataTable ChangePasswordFirst(plTrRegister pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@NewPwd", pl.LoginPwd);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable UpdateInvalidAttempts(plTrRegister pl)
{
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@LoginPwd", pl.UserLoginPwd);
da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataSet GetUserLoginID(plTrRegister pl)
{
DataSet ds = new DataSet();
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@LoginId", pl.UserLoginId);
cmd.Parameters.AddWithValue("@MacAddress", pl.MacAddress);
da = new SqlDataAdapter(cmd);
da.Fill(ds);
return(ds);
}
public DataTable GetAllRegister(plTrRegister pl, int Ind)
{
cmd = new SqlCommand("SPGetAllMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", Ind);
if (Ind == 6)
{
cmd.Parameters.AddWithValue("@ItmId", pl.ItemID);
}
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
return(dt);
}
public int ChangeLoginIdStatus(plTrRegister pl)
{
if (pl.UserId > 0)
{
int i;
cmd = new SqlCommand("SPLoginDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Ind", pl.Ind);
cmd.Parameters.AddWithValue("@UserId", pl.UserId);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
ad.Fill(dt);
return(i = Convert.ToInt32(dt.Rows[0][0]));
}
else
{
return(0);
}
}
public int ChangeLoginIdStatus(plTrRegister pl)
{
return(dl.ChangeLoginIdStatus(pl));
}
public int CheckLockInd(plTrRegister pl)
{
return(dl.CheckLockInd(pl));
}
public DataTable GetLoginDetails(plTrRegister pl)
{
return(dl.GetLoginDetails(pl));
}
public DataTable GetAllRegister(plTrRegister pl, int Ind)
{
return(dl.GetAllRegister(pl, Ind));
}
public DataTable GetLoginDetailsfromservice(plTrRegister pl)
{
return(dl.GetLoginDetailsfromservice(pl));
}
