public DataTable FindByColumn( )
{
dt = UserDto.Data();
dr = dt.NewRow();
dr["FName"] = "";
return(dao.FindByColumn(dt));
}
public DataTable FindByPK(string User_Oid)
{
dt = UserDto.Data();
dr = dt.NewRow();
dr["USER_OID"] = User_Oid;
dt.Rows.Add(dr);
return(dao.FindByPK(dt));
}
public DataTable UserLogin(string userName, string password)
{
dt = UserDto.Data();
dr = dt.NewRow();
dr["USER_LOGIN"] = userName;
dr["PASSWORD"] = password;
dt.Rows.Add(dr);
return(dao.FindByUserLogin(dt));
}
/// <summary>
/// active =1 /0 if active is empty then show all
/// </summary>
/// <param name="name"></param>
/// <param name="active"></param>
/// <returns></returns>
public DataTable FindByColumn(string fname, string usergroup_OID, string active)
{
dt = UserDto.Data();
dr = dt.NewRow();
dr["FName"] = fname;
dr["USERGROUP_OID"] = usergroup_OID;
dr["ROW_STATE"] = active;
dt.Rows.Add(dr);
return(dao.FindByColumn(dt));
}
public bool Action(string USER_OID
, string USERGROUP_OID
, string USER_LOGIN
, string FName
, string LName
, string Position
, string Addr1
, string Telephone
, string Email
, string PASSWORD
, bool rowState
, string userLogin
, PAction action)
{
dt = UserDto.Data();
dr = dt.NewRow();
dr["USER_OID"] = USER_OID;
dr["USERGROUP_OID"] = USERGROUP_OID;
dr["USER_LOGIN"] = USER_LOGIN;
dr["FName"] = FName;
dr["LName"] = LName;
dr["Position"] = Position;
dr["Addr1"] = Addr1;
dr["Telephone"] = Telephone;
dr["Email"] = Email;
dr["PASSWORD"] = PASSWORD;
dr["MAX_SESSION"] = "";
dr["SESSION_TIME_OUT"] = "";
dr["CREATE_BY"] = userLogin;
dr["CREATE_DATE"] = "";
dr["UPDATE_BY"] = userLogin;
dr["UPDATE_DATE"] = "";
dr["ROW_STATE"] = rowState?"1":"0";
dr["Active"] = "";
dt.Rows.Add(dr);
switch (action)
{
case PAction.Add: isCan = Add(); break;
case PAction.Update: isCan = Update(); break;
case PAction.Delete: isCan = Delete(); break;
}
return(isCan);
}