public static void SaveUser(User u)
{
if (u==null) return;
string sql = "UPDATE users SET Key=?, Name=?, Email=?, Language=?, Picture=?, NumInvitees=?, ConfirmationDate=?, NumConfirmed=? WHERE UserID=?";
int modrows = DbAccess.ExecuteUpdate(
sql,
u.Key,
u.Name,
u.Email,
u.Language,
u.Picture,
u.NumInvitees,
(u.ConfirmationDate.HasValue ? u.ConfirmationDate.Value : DateTime.MinValue),
(u.NumConfirmed.HasValue ? u.NumConfirmed.Value : 0),
u.ID);
if (modrows != 1)
{
throw new Exception(string.Format("Modified {0} rows, expected 1.", modrows));
}
}
private static string getImgPath(User u)
{
return getImgPath(u.Picture);
}
public static string getMiniAvatar(User u)
{
return string.Format("<div class='miniavatar' style=\"background-image: url('{0}'); background-size: contain; background-repeat: no-repeat; \"></div>", getImgPath(u));
}
private void setDbgUserData(User u)
{
string html = "<div id='dbg' style='position:absolute; background-color: yellow; z-index:99; opacity: 0.33;'>";
html += "DEBUG:<br>";
html += u.ToString();
html += "<br/>UICulture:" + System.Threading.Thread.CurrentThread.CurrentUICulture;
html += "</div>";
dbgUserData.Text = html;
}
private void LoadUserRec()
{
if (_u != null) return;
string userKey = HttpContext.Current.User.Identity.Name;
if (userKey != null && userKey != "")
{
_u = DataAccess.LoadUser(-1, userKey);
}
}
private static User LoadUser(DataRow theRow)
{
User theUser = new User(
(Int64)theRow["UserID"],
(string)theRow["Key"],
(string)theRow["Name"],
(string)(theRow["DisplayName"] is DBNull ? null : theRow["DisplayName"]),
(string)(theRow["Email"] is DBNull ? null : theRow["Email"]),
(string)(theRow["Language"] is DBNull ? null : theRow["Language"]),
(string)(theRow["Picture"] is DBNull ? null : theRow["Picture"]),
(Int64) theRow["NumInvitees"]);
if (!(theRow["ConfirmationDate"] is System.DBNull))
{
theUser.ConfirmationDate = (DateTime)theRow["ConfirmationDate"];
}
if (!(theRow["NumConfirmed"] is System.DBNull))
{
theUser.NumConfirmed = (Int64)theRow["NumConfirmed"];
}
return theUser;
}
protected void Page_Load(object sender, EventArgs e)
{
LoadUserRec();
u = _u;
if (!IsPostBack)
{
loadVisibilities();
for (int i = 1; i <= u.NumInvitees; i++)
{
rdoPlusList.Items.Add(new ListItem(convertGuestNum(i), "" + i));
rdoPlusList.SelectedIndex = 0;
}
if (u.NumConfirmed.HasValue)
{
if (u.NumConfirmed.Value == 0)
{
rdoNo.Checked = true;
}
else
{
rdoYes.Checked = true;
rdoPlusList.SelectedValue = "" + u.NumConfirmed.Value;
}
}
else
rdoPlusList.SelectedIndex = 0;
}
loadGuestStatusText();
setRadioTextAlign(rdoYes);
setRadioTextAlign(rdoNo);
setRadioTextAlign(rdoPlusList);
//Show Guest List
DataTable GVDataTable = DataAccess.LoadGuestList();
guestListGV.DataSource = GVDataTable;
guestListGV.DataBind();
// Style buttons
SetCultureOnButton(btnEditToggle);
}
public Comment(String text, DateTime commDate, User user)
{
this.text = text;
this.commDate = commDate;
this.user = user;
}
