internal User toUser(SqlDataReader rdr, string encryptionKey)
{
User result = new User();
if (_encrypt)
{
result.SSN = new SocSecNum(SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SSN")), encryptionKey));
result.Name = new PersonName(SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("Name")), encryptionKey));
result.Uid = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("DUZ")), encryptionKey);
string siteId = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SiteId")), encryptionKey);
string siteName = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SiteName")), encryptionKey);
result.LogonSiteId = new SiteId(siteId, siteName);
result.Phone = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("Phone")), encryptionKey);
}
else
{
//result.SSN = new SocSecNum(rdr.GetString(rdr.GetOrdinal("SSN")));
string s = rdr.GetString(rdr.GetOrdinal("Name"));
result.Name = new PersonName(rdr.GetString(rdr.GetOrdinal("Name")));
result.Uid = rdr.GetString(rdr.GetOrdinal("DUZ"));
string siteId = rdr.GetString(rdr.GetOrdinal("SiteId"));
string siteName = rdr.GetString(rdr.GetOrdinal("SiteName"));
result.LogonSiteId = new SiteId(siteId, siteName);
result.Phone = rdr.GetString(rdr.GetOrdinal("Phone"));
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
ErrorInfo.Visible = false;
if (!IsPostBack)
{
//Check if the browser support cookies
if (Request.Browser.Cookies)
{
//Check if the cookies wth name BulaBulaLogin exist on user's machine
if (Request.Cookies["login"] != null)
{
string username = null, password = null;
if (Request.Cookies["login"]["username"] != null)
{
username = Request.Cookies["login"]["username"];
}
if (Request.Cookies["login"]["password"] != null)
{
password = Request.Cookies["login"]["password"];
}
userInformation = new ActiveDirectoryDAL(SSTCryptographer.Decrypt(username), SSTCryptographer.Decrypt(password));
Session["memberID"] = username;
// Server.Transfer("~/Home.aspx");
Response.Redirect("~/Home.aspx");
}
}
}
}
private void main_Load(object sender, EventArgs e)
{
var version = new Version(Application.ProductVersion);
versionNumber.Text = "Versión: " + version.Major.ToString() + "." + version.Minor.ToString();
errorTimer = new Timer();
errorTimer.Interval = 1000;
errorTimer.Tick += ErrorTimer_Tick;
errorTimer.Enabled = true;
check.Checked = true;
check.Text = "Sólo lectura";
check.CheckedChanged += setSoloLectura;
ConfigError =
string.IsNullOrWhiteSpace(Properties.Settings.Default.serverAddress) ||
string.IsNullOrWhiteSpace(Properties.Settings.Default.databaseName) ||
string.IsNullOrWhiteSpace(Properties.Settings.Default.databaseUsername) ||
string.IsNullOrWhiteSpace(Properties.Settings.Default.serverPort) ||
string.IsNullOrWhiteSpace(Properties.Settings.Default.databasePassword) ||
string.IsNullOrWhiteSpace(Properties.Settings.Default.reportUNC);
if (ConfigError)
{
return;
}
db = new dbMySql.dbMySql();
db.serverAddress = Properties.Settings.Default.serverAddress;
db.serverPort = Properties.Settings.Default.serverPort;
db.databaseName = Properties.Settings.Default.databaseName;
db.databaseUsername = Properties.Settings.Default.databaseUsername;
db.databasePassword = SSTCryptographer.Decrypt(
Properties.Settings.Default.databasePassword,
Properties.Settings.Default.databaseUsername +
"as56afs65qer3g654afg");
db.limitResults = Properties.Settings.Default.limitResults;
db.limitResultsTo = Properties.Settings.Default.limitResultsTo;
db.useWildcard = Properties.Settings.Default.useWildcard;
reportUNC = Properties.Settings.Default.reportUNC;
db.CreateConnection();
dataGridView1.DataSource = mainBindingSource;
backgroundWorker = new BackgroundWorker();
backgroundWorker.DoWork += databaseTransaction;
backgroundWorker.RunWorkerCompleted += databaseTransactionResult;
bgwObj = new backgroundObject();
bgwObj.db = db;
bgwObj.actionIs = backgroundObject.action.justConnect;
backgroundWorker.RunWorkerAsync(bgwObj);
}
private void Config_Load(object sender, EventArgs e)
{
label = new Label[fieldsAmount];
textBox = new TextBox[fieldsAmount];
AppDomain currentDomain = AppDomain.CurrentDomain;
currentDomain.UnhandledException += new UnhandledExceptionEventHandler(GeneralException);
for (int fieldNumber = 0; fieldNumber < fieldsAmount; ++fieldNumber)
{
label[fieldNumber] = new Label();
textBox[fieldNumber] = new TextBox();
textBox[fieldNumber].Size = new Size(200, 20);
tableLayoutPanel1.Controls.Add(label[fieldNumber]);
tableLayoutPanel1.Controls.Add(textBox[fieldNumber]);
}
label[0].Text = "Server address ";
textBox[0].Text = Properties.Settings.Default.serverAddress;
label[1].Text = "Server port ";
textBox[1].Text = Properties.Settings.Default.serverPort;
label[2].Text = "Database ";
textBox[2].Text = Properties.Settings.Default.databaseName;
label[3].Text = "User ";
textBox[3].Text = Properties.Settings.Default.databaseUsername;
label[4].Text = "Password ";
textBox[4].UseSystemPasswordChar = true;
label[5].Text = "Report UNC ";
textBox[5].Text = Properties.Settings.Default.reportUNC;
checkBox1.Checked = Properties.Settings.Default.useWildcard;
checkBox2.Checked = Properties.Settings.Default.limitResults;
numericUpDown1.Value = Properties.Settings.Default.limitResultsTo;
textBox[4].Text = SSTCryptographer.Decrypt(
Properties.Settings.Default.databasePassword,
Properties.Settings.Default.databaseUsername +
"as56afs65qer3g654afg");
}
private void MoveProcess()
{
try
{
int j = 0;
string bath = "";
string temp = @Convert.ToString(XMLCacheGet("frmOption_TempPath", "")) + "\\temp\\";
progressBarControl1.Properties.Maximum = namedate.Length / 4;
string dllname = "";
mmolog.Text = "";
for (int i = 0; i < namedate.Length - 3; i = i + 4)
{
dllname = SSTCryptographer.Decrypt(namedate[i], "SampleKey");
string date = namedate[i + 1] + " " + namedate[i + 2];
dateTimePicker1.Text = date;
switch (Convert.ToInt16(namedate[i + 3]))
{
case 0: bath = @Convert.ToString(XMLCacheGet("frmOption_TempPath", "")) + "\\"; break;
case 1: bath = @Convert.ToString(XMLCacheGet("frmOption_ReportPathIn", "")) + "\\"; break;
case 2: bath = @Convert.ToString(XMLCacheGet("frmOption_DynamicPathIn", "")) + "\\"; break;
case 3: bath = @Convert.ToString(XMLCacheGet("frmOption_SlipsPathIn", "")) + "\\"; break;
}
j++;
if (File.Exists(bath + dllname))
{
File.Delete(bath + dllname);
}
progressBarControl1.EditValue = j;
mmolog.Text = mmolog.Text + "\r\n" + Convert.ToString(j) + ". " + dllname + ".........." + date;
File.SetLastWriteTime(temp + dllname, dateTimePicker1.Value);
File.Move(temp + dllname, bath + dllname);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GenerateProfile(Member aMember)
{
#region RIGHT COLUMN GET ALL JOINED GROUPS
//JOINED GROUPS==============================================================================
Reusable_Methods reusable_Methods = new Reusable_Methods(aMember);
allgroups = reusable_Methods.RightColumnGetAllJoinedGroups();
//============================================================================================
#endregion
#region RIGHT COLUMN MEMBER INFORMATION
//MEMBER INFORMATION ON RIGHT COLUMN==========================================================================
//MEMBER INFO AND PROFILE
MemberInfoDAL dal = new MemberInfoDAL();
// Member member = new Member();
aMember = dal.GetAllMemberInfo(aMember);
profilesMemnerID.Value = aMember.MemberId;
//Set the ImageUrl to the path of the handler with the querystring value
ProfileImage.ImageUrl = "ProfilePicHandler.ashx?id=" + SSTCryptographer.Decrypt(aMember.MemberId);
//call the method to get the image information and display it in Label Control
//=======================================================================================================
#endregion
#region MAIN COLUMN MEMBER INFORMATION
//MEMBER INFORMATION ON MAIN DISPLAY==========================================================================
StringBuilder memberData = new StringBuilder();
memberData.Append("<tr><td style='font-weight: bold;' > ");
memberData.Append("First Name:</td><td>");
memberData.Append(aMember.FirstName);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;'>");
memberData.Append("Last Name:</td><td>");
memberData.Append(aMember.LastName);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
memberData.Append("Display Name:</td><td>");
memberData.Append(aMember.DisplayName);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
memberData.Append("Email:</td><td>");
memberData.Append(aMember.Email);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
memberData.Append("Description:</td><td>");
memberData.Append(aMember.Description);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
memberData.Append("Campus:</td><td>");
memberData.Append(aMember.Campus);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
memberData.Append("Account Type:</td><td>");
memberData.Append(aMember.MemberType);
memberData.Append("</td></tr> <tr><td style='font-weight: bold;' > ");
if (aMember.IsOnline == false)
{
memberData.Append("Online Status:</td><td style='color:red;'>");
memberData.Append("Offline");
memberData.Append("</td></tr>");
}
else
{
memberData.Append("Online Status:</td><td style='color:green;'>");
memberData.Append("Online");
memberData.Append("</td></tr>");
}
memberDataMain = memberData.ToString();
#endregion
#region MAIN COLUMN MOST RECENT POST DATE
//MOST RECENT POST DATE ON MAIN DISPLAY==========================================================================
NotificationDAL notificationDAL = new NotificationDAL();
StringBuilder recentPostDate = new StringBuilder();
Post aPost = new Post();
aPost = notificationDAL.GetMostRecentPostDate(aMember);
if (aPost.CreateDate == DateTime.Parse("1/1/0001 12:00:00 AM"))
{
reusable_Methods = new Reusable_Methods();
string date = reusable_Methods.FormatDateTime(aPost.CreateDate);
recentPostDate.Append("<p style='font-size: 1.2em; color: #A3ADB5;'>Most recent post date<span style='color: #0e93be;'> - ");
recentPostDate.Append("No posts");
recentPostDate.Append("</span></p>");
mostRecentPostDate = recentPostDate.ToString();
}
else
{
reusable_Methods = new Reusable_Methods();
string date = reusable_Methods.FormatDateTime(aPost.CreateDate);
recentPostDate.Append("<p style='font-size: 1.2em; color: #A3ADB5;'>Most recent post date<span style='color: #0e93be;'> - ");
recentPostDate.Append(date);
recentPostDate.Append("</span></p>");
mostRecentPostDate = recentPostDate.ToString();
}
#endregion
#region MAIN ACTUAL DISPLAY NAME
MemberInfoDAL memberInfoDAL = new MemberInfoDAL();
Member actualMember = new Member(Context.Session["memberID"].ToString());
aMember = memberInfoDAL.GetActualDisplayName(actualMember);
actualMemberDisplayName = aMember.DisplayName;
#endregion
}
public void testDecrypt()
{
Assert.AreEqual(SECRET, SSTCryptographer.Decrypt(ENCRYPTED));
}
protected void Page_Load(object sender, EventArgs e)
{
//To use for notifications
SessionMemberID.Value = Session["memberID"].ToString();
year = now.Year;
if (Session["stayEx"] != null)
{
if (Session["stayEx"].ToString() == "expanded")
{
StayExpanded.Value = "expanded";
}
}
if (StayExpanded.Value == "expanded")
{
Session["stayEx"] = "expanded";
}
else
{
Session["stayEx"] = "";
}
MessagesDAL member = new MessagesDAL();
if (!IsPostBack)
{
if (Session["memberID"] == null)
{
Response.Redirect("~/Login.aspx");
}
else if (loginDAL.GetMemberStatus(member_Status = new Member_Status(Session["memberID"].ToString())))
{
if (Request.Cookies["login"] != null)
{
var c = new HttpCookie("login");
c.Expires = DateTime.Now.AddDays(-1);
Response.Cookies.Add(c);
Session.Abandon();
}
Response.Redirect("~/Login.aspx");
}
defaultEmailAddress = SSTCryptographer.Decrypt(Session["memberID"].ToString()) + "@live.nmmu.ac.za";
}//END MAIN if LOADING FOR THE FIRST TIME
else if (profileFriendID.Value != "")
{
#region REDIRECT TO CLICKED PROFILE
//REDIRECT TO CLICKED PROFILE===================================================================
if (profileFriendID.Value != null)
{
Session["profileFriendID"] = profileFriendID.Value;
profileFriendID.Value = null;
Response.Redirect("~/Profile.aspx");
}
//=============================================================================================
#endregion
}
else if (GoToGroupPageID.Value != "")
{
Session["GroupInfo"] = GoToGroupPageID.Value;
Response.Redirect("~/Group.aspx");
}
else if (SelectedMessageID.Value != "")
{
Session["selectedMessageID"] = SelectedMessageID.Value;
Response.Redirect("~/ViewMessages.aspx");
}
if (Session["memberID"] == null)
{
Response.Redirect("~/Login.aspx");
}
else
{
string memberId = Context.Session["memberID"].ToString();
thisMemberID.Value = memberId;
aMember.MemberId = memberId;
#region GO ONLINE
MemberInfoDAL memberInfoDAL = new MemberInfoDAL();
memberInfoDAL.UpdateToOnline(aMember);
#endregion
#region MAIN ACTUAL DISPLAY NAME
memberInfoDAL = new MemberInfoDAL();
aMember = memberInfoDAL.GetActualDisplayName(aMember);
actualMemberDisplayName = aMember.DisplayName;
#endregion
#region RIGHT COLUMN GET 5 JOINEDGROUPS
//JOINED GROUPS==============================================================================
Reusable_Methods reusable_Methods = new Reusable_Methods(aMember);
allgroups = reusable_Methods.RightColumnGet5JoinedGroups();
//===========================================================================================
#endregion
#region RIGHT COLUMN FRIENDS ONLINE
//FRIENDS ONLINE==============================================================================
memberId = Context.Session["memberID"].ToString();
aMember.MemberId = memberId;
reusable_Methods = new Reusable_Methods(aMember);
FriendsOnlineString = reusable_Methods.RightColumnGetFriendsOnline();
//===========================================================================================
#endregion
#region NOTIFICATIONS
NotificationsString = reusable_Methods.RightColumnNotifications();
#endregion
}
}//END PAGE_LOAD
