public void LoadFromObj(COUser oOrg)
{
miID = oOrg.ID;
msUsername = oOrg.Username;
msDescription = oOrg.Description;
msPassword = oOrg.Password;
mbIsAdministrator = oOrg.IsAdministrator;
mbIsEngineerAdmin = oOrg.IsEngineerAdmin;
mbIsManager = oOrg.IsManager;
}
public void Copy(COUser oNew)
{
oNew.ID = miID;
oNew.Username = msUsername;
oNew.Description = msDescription;
oNew.Password = msPassword;
oNew.IsAdministrator = mbIsAdministrator;
oNew.IsEngineerAdmin = mbIsEngineerAdmin;
oNew.IsManager = mbIsManager;
}
private void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
s = new XmlSerializer(typeof(COUser));
sr = new System.IO.StringReader(strXml);
oVar = new COUser();
oVar = (COUser)s.Deserialize(sr);
sr.Close();
sr = null;
s = null;
}
public void LoadVals(string strXml)
{
XmlSerializer s;
StringReader sr;
COUser o;
s = new XmlSerializer(typeof(COUser));
sr = new System.IO.StringReader(strXml);
o = new COUser();
o = (COUser)s.Deserialize(sr);
base.LoadFromObj(o);
o = null;
sr.Close();
sr = null;
s = null;
}
public string GetByUserPwrd(string user, string pwrd)
{
SqlDataReader dr;
RSLib.CDbConnection cnn;
SqlCommand cmd;
SqlParameter prm;
string tmpStr = "";
cnn = new RSLib.CDbConnection();
cmd = new SqlCommand("spUser_ByUserPwrd", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@Username", SqlDbType.VarChar, 50);
prm.Value = user;
prm = cmd.Parameters.Add("@Password", SqlDbType.VarChar, 100);
prm.Value = pwrd;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oVar = new COUser();
oVar.ID = Convert.ToInt32(dr["ID"]);
oVar.Username = dr["Username"].ToString();
oVar.Description = dr["Description"].ToString();
oVar.Password = dr["Password"].ToString();
oVar.IsAdministrator = Convert.ToBoolean(dr["IsAdministrator"]);
oVar.IsEngineerAdmin = Convert.ToBoolean(dr["IsEngineerAdmin"]);
oVar.IsManager = Convert.ToBoolean(dr["IsManager"]);
tmpStr = GetDataString();
}
dr = null;
prm = null;
cmd = null;
cnn.CloseConnection();
cnn = null;
return(tmpStr);
}
public string GetDataString()
{
string tmpStr;
COUser o;
XmlSerializer s;
StringWriter sw;
o = new COUser();
s = new XmlSerializer(typeof(COUser));
sw = new StringWriter();
base.Copy(o);
s.Serialize(sw, o);
tmpStr = sw.ToString();
o = null;
s = null;
sw = null;
return(tmpStr);
}
