Example #1
0
        private bool DeleteSingleMessageByMessageID(MessageSticker Message)
        {
            SqlConnection con = null;

            try
            {
                con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
                string     delete  = "DELETE FROM MessageSticker WHERE MessageID=@MessageID";
                SqlCommand command = new SqlCommand(delete, con);

                command.Parameters.AddWithValue("@MessageID", Message.MessageID);
                con.Open();
                command.ExecuteNonQuery();
                return(true);
            }
            catch (Exception err)
            {
                StatusMessage.Text = "Грешка, обидете се повторно (11) " + err.Message;
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }
            }
            return(false);
        }
Example #2
0
        private bool SenderIsBuying(MessageSticker Message)
        {
            SqlConnection con = null;

            try
            {
                string ThisUserID   = MessageSticker.PosterUserID;
                string SenderUserID = Message.SenderUserID;

                con = new SqlConnection(WebConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
                //get cash
                string     select  = "SELECT Cash,UserId FROM aspnet_Users WHERE UserId=@PosterID OR UserId=@SenderID";
                SqlCommand command = new SqlCommand(select, con);

                command.Parameters.AddWithValue("@PosterID", ThisUserID);
                command.Parameters.AddWithValue("@SenderID", SenderUserID);
                con.Open();
                SqlDataReader reader = command.ExecuteReader();

                int ThisUserCash = 0;
                int SenderCash   = 0;

                while (reader.Read())
                {
                    if (reader["UserId"].ToString() == ThisUserID)
                    {
                        ThisUserCash = (int)reader["Cash"];
                    }
                    else if (reader["UserId"].ToString() == SenderUserID)
                    {
                        SenderCash = (int)reader["Cash"];
                    }
                }
                reader.Close();

                ThisUserCash += Message.Offer;
                SenderCash   -= Message.Offer;

                //update cash
                string update = "UPDATE aspnet_Users SET Cash=@Cash WHERE UserId=@Userid";
                command.CommandText = update;
                command.Parameters.Clear();

                command.Parameters.AddWithValue("@Cash", ThisUserCash);
                command.Parameters.AddWithValue("@Userid", ThisUserID);
                command.ExecuteNonQuery();

                command.Parameters.Clear();
                command.Parameters.AddWithValue("@Cash", SenderCash);
                command.Parameters.AddWithValue("@Userid", SenderUserID);
                command.ExecuteNonQuery();

                //transfer sticker to sender
                update = "UPDATE Sticker SET UserID=@SenderID WHERE StickerID=@StickerID";
                command.CommandText = update;
                command.Parameters.Clear();
                command.Parameters.AddWithValue("@SenderID", SenderUserID);
                command.Parameters.AddWithValue("@StickerID", Message.PosterStickerID);
                command.ExecuteNonQuery();

                //transfer sticker to poster if sender offered one
                if (!string.IsNullOrWhiteSpace(Message.SenderStickerID))
                {
                    update = "UPDATE Sticker SET UserID=@ThisUserID WHERE StickerID=@StickerID";
                    command.CommandText = update;
                    command.Parameters.Clear();
                    command.Parameters.AddWithValue("@ThisUserID", ThisUserID);
                    command.Parameters.AddWithValue("@StickerID", Message.SenderStickerID);
                    command.ExecuteNonQuery();
                }

                //delete post from PostSticker
                string delete = "DELETE FROM PostSticker WHERE StickerID=@PosterStickerID AND PosterID=@PosterID";
                command.CommandText = delete;
                command.Parameters.Clear();
                command.Parameters.AddWithValue("@PosterStickerID", Message.PosterStickerID);
                command.Parameters.AddWithValue("@PosterID", ThisUserID);
                command.ExecuteNonQuery();

                return(true);
            }
            catch (Exception err)
            {
                StatusMessage.Text = "Грешка, обидете се повторно (12345) " + err.Message;
            }
            finally
            {
                if (con != null)
                {
                    con.Close();
                }
            }
            return(false);
        }