private static Ecard[] Fetch(int? id, int? ecardTypeID, string fromUsername, string toUsername,
bool? isOpened, eSortColumn sortColumn)
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = (SqlDataReader) SqlHelper.GetDB().ExecuteReader( "FetchEcards",
id,
ecardTypeID,
fromUsername,
toUsername,
isOpened,
sortColumn);
List<Ecard> lEcards = new List<Ecard>();
while (reader.Read())
{
Ecard ecard = new Ecard();
ecard.id = (int)reader["ID"];
ecard.ecardTypeID= (int) reader["EcardTypeID"];
ecard.fromUsername = (string) reader["FromUsername"];
ecard.toUsername = (string) reader["ToUsername"];
ecard.date = (DateTime) reader["Date"];
ecard.message = (string) reader["Message"];
ecard.deletedByFromUser = (bool) reader["DeletedByFromUser"];
ecard.deletedByToUser = (bool) reader["DeletedByToUser"];
ecard.isOpened = (bool) reader["IsOpened"];
lEcards.Add(ecard);
}
return lEcards.ToArray();
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
EcardType ecardType = EcardType.Fetch(Convert.ToInt32(ddEcards.SelectedValue));
if (ecardType != null)
{
//var permissionResult = CurrentUserSession.CanSendEcards();
if (canSendEcardPermissionResult == PermissionCheckResult.No)
{
StatusPageMessage = "You are not allowed to send e-cards".Translate();
Response.Redirect("ShowStatus.aspx");
return;
}
if (canSendEcardPermissionResult == PermissionCheckResult.YesButMoreCreditsNeeded ||
canSendEcardPermissionResult == PermissionCheckResult.YesButPlanUpgradeNeeded)
{
Global.GetSessionState()["BillingPlanOption"] = CurrentUserSession.BillingPlanOptions.CanSendEcards;
Response.Redirect("ManageProfile.aspx?sel=payment");
return;
}
if (canSendEcardPermissionResult == PermissionCheckResult.YesWithCredits)
{
//if (Config.Credits.Required && CurrentUserSession.BillingPlanOptions.CanSendEcards.Credits > 0)
//{
// if (!Config.Users.FreeForFemales ||
// CurrentUserSession.Gender != Classes.User.eGender.Female)
// {
int creditsCost = CurrentUserSession.BillingPlanOptions.CanSendEcards.Credits;
int creditsLeft = CurrentUserSession.Credits - creditsCost;
if (!Config.Credits.ChargeOneTimePerMember) // charge every time
{
if (creditsLeft < 0)
{
Global.GetSessionState()["BillingPlanOption"] = CurrentUserSession.BillingPlanOptions.CanSendEcards;
Response.Redirect("~/ManageProfile.aspx?sel=payment");
return;
}
var user = Classes.User.Load(CurrentUserSession.Username);
user.Credits -= creditsCost;
user.Update(true);
CurrentUserSession.Credits = user.Credits;
}
else
{
bool isCharged = EstablishedCommunication.Fetch(CurrentUserSession.Username,
RecipientUsername) != null;
if (!isCharged)
{
if (creditsLeft >= 0)
{
var establishedCommunication =
new EstablishedCommunication(CurrentUserSession.Username, RecipientUsername);
establishedCommunication.Save();
var user = Classes.User.Load(CurrentUserSession.Username);
user.Credits -= creditsCost;
user.Update(true);
CurrentUserSession.Credits = user.Credits;
}
else
{
Global.GetSessionState()["BillingPlanOption"] = CurrentUserSession.BillingPlanOptions.CanSendEcards;
Response.Redirect("~/ManageProfile.aspx?sel=payment");
return;
}
}
}
// }
}
Ecard ecard = new Ecard(ecardType.ID, CurrentUserSession.Username, RecipientUsername);
string message = htmlEditor != null ? htmlEditor.Content : ckeditor.Text;
ecard.Message = message.Trim();
ecard.Save();
User recipient = null;
try
{
recipient = Classes.User.Load(RecipientUsername);
}
catch (NotFoundException)
{
StatusPageMessage = "The user no longer exists!".Translate();
Response.Redirect("~/ShowStatus.aspx");
return;
}
if (Classes.User.IsUserBlocked(RecipientUsername, CurrentUserSession.Username))
{
StatusPageMessage =
String.Format(Lang.Trans("You are currently blocked from sending e-cards to {0}"),
RecipientUsername);
Response.Redirect("ShowStatus.aspx");
return;
}
if (recipient.ReceiveEmails)
{
EmailTemplates.SendEcard sendEcardTemplate = new EmailTemplates.SendEcard(recipient.LanguageId);
Email.Send(Config.Misc.SiteTitle, Config.Misc.SiteEmail, recipient.Name, recipient.Email,
sendEcardTemplate.GetFormattedSubject(CurrentUserSession.Username),
sendEcardTemplate.GetFormattedBody(CurrentUserSession.Username), false);
}
if (Config.Users.NewEventNotification)
{
int imageID = 0;
try
{
imageID = Photo.GetPrimary(CurrentUserSession.Username).Id;
}
catch (NotFoundException)
{
imageID = ImageHandler.GetPhotoIdByGender(CurrentUserSession.Gender);
}
string text = "You have a new e-card!".Translate();
string thumbnailUrl = ImageHandler.CreateImageUrl(imageID, 50, 50, false, true, true);
Classes.User.SendOnlineEventNotification(CurrentUserSession.Username, recipient.Username, text,
thumbnailUrl, "Mailbox.aspx?sel=recec");
}
StatusPageLinkText = "Back to profile".Translate();
StatusPageLinkURL = UrlRewrite.CreateShowUserUrl(RecipientUsername);
StatusPageMessage = Lang.Trans("<b>Your e-card was sent successfully!</b><br><br>");
Response.Redirect("~/ShowStatus.aspx");
}
}