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)); }