private void SetupBillingAndUpgradeMembership(double amount)
{
db.Execute("update users set membership='VIP',SUBSCRIPTION_ACTIVE=1,CANCEL_FROM_NEXT_PERIOD=null,NextPaymentDate=CONVERT(DATE, dateadd(month,1,getdate()), 101),UnsuccessfullCount=0,Rate=" + MyUtils.MonthlyFee.ToString() + ",NextBillingCycle=CONVERT(DATE, dateadd(month,1,getdate()), 101),LastPaymentDate=CONVERT(DATE, getdate(), 101) where id_user="******"emailtitle:Your membership has been upgraded");
p.Add("line:Your membership has been upgraded to VIP.");
p.Add("cost:" + amount.ToString("c2"));
p.Add("date:" + DateTime.Now.ToString("MM/dd/yyyy"));
p.Add("package: Monthly Service");
RWorker.AddToEmailQueue("EMAIL_PAYMENT", MyUtils.ID_USER, null, false, p);
MyUtils.RefreshUserRow();
}
public void BuyCreditsDB(double amount_money, int credits, int id_user)
{
DB_Helper db = new DB_Helper();
db.Execute("exec BUY_CREDITS " + id_user + "," + amount_money + "," + credits);
List <string> p = new List <string>();
p.Add("emailtitle:Credits were added");
p.Add("line:We added " + credits + " credits to your account.");
p.Add("credits:" + credits);
p.Add("cost:" + amount_money.ToString("c2"));
p.Add("date:" + DateTime.Now.ToString("MM/dd/yyyy"));
p.Add("package:" + credits + " credit package");
RWorker.AddToEmailQueue("EMAIL_PAYMENT", MyUtils.ID_USER, null, false, p);
MyUtils.RefreshUserRow();
}
public static Message SendMessage(string message, string toUser, string giftIds)
{
DB_Helper db = new DB_Helper();
var fromUser = MyUtils.ID_USER;
message = MyUtils.StripHTML(message);
giftIds = MyUtils.StripHTML(giftIds);
int id_user_to = Convert.ToInt32(toUser);
int id_offer = db.ExecuteScalarInt("exec CAN_MESSAGE_WITH " + Convert.ToInt32(fromUser) + "," + id_user_to, 0);
if (id_offer == 0)
{
Message mm = new Message();
mm.Text = "You don't have permission to send messages to this user.";
return(mm);
}
if (message.Trim() == "")
{
return(null);
}
if (!string.IsNullOrEmpty(giftIds))
{
Gifts g = new Gifts(giftIds);
string err = g.AddGifts2User(MyUtils.ID_USER, id_user_to);
if (err != "")
{
Message mmm = new Message();
mmm.Text = err;
return(mmm);
}
}
var table = SaveMessage2DBAndSelect(fromUser, id_user_to, message, giftIds, id_offer);
//make sure we don't send too many notification emails
int unread_messages_in_10_mins = db.ExecuteScalarInt("select count(*) from Messages where id_user_from=" + fromUser + " and id_user_to=" + id_user_to + " and is_new = 1 and [time] > DATEADD(minute, -10, GETDATE())");
if (unread_messages_in_10_mins < 2)
{
RWorker.AddToEmailQueue("EMAIL_NEWMESSAGE", id_user_to, MyUtils.ID_USER);
}
DB_Helper.InvalidateCache("TOPCOUNTS_" + MyUtils.ID_USER);
DB_Helper.InvalidateCache("TOPCOUNTS_" + id_user_to);
var query = from p in table.AsEnumerable()
select new Message
{
Id = p.Field <int>("id_message"),
Text = p.Field <string>("text"),
From = new User
{
Name = "You",
Id = p.Field <int>("id_user_from")
},
To = new User
{
Name = "Female123", //TODO
Id = p.Field <int>("id_user_from")
},
DateTime = p.Field <DateTime>("time"),
IsFromMe = true
};
Message m = query.First();
if (!string.IsNullOrEmpty(giftIds))
{
m.Credits = Convert.ToInt32(MyUtils.GetUserField("credits"));
}
return(m);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
bool revalidate = false;
try
{
string newemail = txtEmail.Text.Trim();
int cnt = db.ExecuteScalarInt("select count(*) from users where email=" + MyUtils.safe(newemail) + " and id_user<>" + MyUtils.ID_USER);
if (cnt > 0)
{
Session["message"] = "ERROR: this email is used by other user. You need to provide a new email.";
return;
}
DataSet ds = db.CommandBuilder_LoadDataSet(string.Format("select * from users where id_user={0}", MyUtils.ID_USER));
DataRow userRow = ds.Tables[0].Rows[0];
if (txtPassword.Text.Trim() != string.Empty)
{
userRow["password"] = txtPassword.Text.Trim();
}
revalidate = userRow["email"].ToString().ToUpper() != newemail.ToUpper();
userRow["email"] = newemail;
if (revalidate)
{
userRow["email_verified"] = 0;
}
//cbx
userRow["email_new_matches"] = cbxEmailNewMatches.Checked;
userRow["email_when_new_message"] = cbxEmailWhenNewMessage.Checked;
userRow["email_when_favorited"] = cbxEmailWhenFavorited.Checked;
userRow["email_when_new_offer"] = cbxemail_when_new_offer.Checked;
userRow["email_newsletter"] = cbxEmailNewsletter.Checked;
userRow["hide_from_search_results"] = cbxHideFromSearchResults.Checked;
// userRow["hide_on_viewed_favorited_list"] = cbxHideOnViewedFavoritedList.Checked;
// userRow["hide_last_logintime"] = cbxHideLastLogintime.Checked;
db.CommandBuilder_SaveDataset();
}
finally
{
db.CommandBuilder_Disconnect();
}
MyUtils.RefreshUserRow();
if (revalidate)
{
RWorker.AddToEmailQueue("EMAIL_ACTIVATE", MyUtils.ID_USER);
}
Session["message"] = "Settings have been saved";
Response.Redirect("~/Account/");
}
