public List <FullCardInfo> GetProcessData(string userName, string step)
{
NpgsqlParameter paramUserName = new NpgsqlParameter("@user_name", NpgsqlTypes.NpgsqlDbType.Text);
paramUserName.Value = userName;
NpgsqlParameter paramstep = new NpgsqlParameter("@step", NpgsqlTypes.NpgsqlDbType.Text);
paramstep.Value = step;
List <FullCardInfo> dt = cmd.ExecuteDataAdapter <FullCardInfo>(DBConstant.GetDataStep, new NpgsqlParameter[] { paramUserName, paramstep });
return(dt);
}
public List <ConfigurationItem> GetAllConfig()
{
List <ConfigurationItem> result = null;
result = cmd.ExecuteDataAdapter <ConfigurationItem>(DBConstant.GetAllConfig, null);
return(result);
}
public User DoLogin(string userName, string password)
{
User result = null;
NpgsqlParameter paramUserName = new NpgsqlParameter("@login_username", NpgsqlTypes.NpgsqlDbType.Text);
paramUserName.Value = userName;
NpgsqlParameter paramPassword = new NpgsqlParameter("@login_password", NpgsqlTypes.NpgsqlDbType.Text);
paramPassword.Value = password;
List <User> lstUser = cmd.ExecuteDataAdapter <User>(DBConstant.GetUserInfo, new NpgsqlParameter[] { paramUserName, paramPassword });
if (lstUser != null && lstUser.Count > 0)
{
result = lstUser.FirstOrDefault();
}
return(result);
}
public List <Data> GetAllData(string session)
{
NpgsqlParameter param = new NpgsqlParameter("@sessionName", NpgsqlTypes.NpgsqlDbType.Text);
param.Value = session;
List <Data> dt = cmd.ExecuteDataAdapter <Data>(DBConstant.GetAllData, new NpgsqlParameter[] { param });
return(dt);
}
public WorkingStatus GetWorkingStatus(string username, string step)
{
NpgsqlParameter paramUser = new NpgsqlParameter("@userName", NpgsqlTypes.NpgsqlDbType.Text);
paramUser.Value = username;
NpgsqlParameter paramStep = new NpgsqlParameter("@userstep", NpgsqlTypes.NpgsqlDbType.Text);
paramStep.Value = step;
List <WorkingStatus> dt = cmd.ExecuteDataAdapter <WorkingStatus>(DBConstant.GetWorkingStatus, new NpgsqlParameter[] { paramUser, paramStep });
if (dt != null && dt.Count > 0)
{
return(dt.FirstOrDefault());
}
return(null);
}