Exemplo n.º 1
0
        public bool Insert(ContactRewardDetails Details)
        {
            try
            {
                string SQL = "CALL procContactRewardModify(@lngCustomerID, @strRewardCardNo, @intRewardActive, @decRewardPoints, @dteRewardAwardDate, @intRewardCardStatus, @dteExpiryDate, @dteBirthDate);";

                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@lngCustomerID", Details.ContactID);
                cmd.Parameters.AddWithValue("@strRewardCardNo", Details.RewardCardNo);
                cmd.Parameters.AddWithValue("@intRewardActive", Convert.ToInt16(Details.RewardActive));
                cmd.Parameters.AddWithValue("@decRewardPoints", Convert.ToDecimal(0));                 // not working if decimal
                cmd.Parameters.AddWithValue("@dteRewardAwardDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                cmd.Parameters.AddWithValue("@intRewardCardStatus", Details.RewardCardStatus.ToString("d"));
                cmd.Parameters.AddWithValue("@dteExpiryDate", Details.ExpiryDate.ToString("yyyy-MM-dd"));
                cmd.Parameters.AddWithValue("@dteBirthDate", Details.BirthDate.ToString("yyyy-MM-dd"));

                bool bolRetValue = false;
                if (base.ExecuteNonQuery(cmd) > 0)
                {
                    bolRetValue = true;
                }
                return(bolRetValue);
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Exemplo n.º 2
0
		public bool Insert(ContactRewardDetails Details)
		{
			try  
			{
				string SQL = "CALL procContactRewardModify(@lngCustomerID, @strRewardCardNo, @intRewardActive, @decRewardPoints, @dteRewardAwardDate, @intRewardCardStatus, @dteExpiryDate, @dteBirthDate);";

				MySqlCommand cmd = new MySqlCommand();
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				cmd.Parameters.AddWithValue("@lngCustomerID", Details.ContactID);
				cmd.Parameters.AddWithValue("@strRewardCardNo", Details.RewardCardNo);
				cmd.Parameters.AddWithValue("@intRewardActive", Convert.ToInt16(Details.RewardActive));
				cmd.Parameters.AddWithValue("@decRewardPoints", Convert.ToDecimal(0)); // not working if decimal
				cmd.Parameters.AddWithValue("@dteRewardAwardDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
				cmd.Parameters.AddWithValue("@intRewardCardStatus", Details.RewardCardStatus.ToString("d"));
				cmd.Parameters.AddWithValue("@dteExpiryDate", Details.ExpiryDate.ToString("yyyy-MM-dd"));
				cmd.Parameters.AddWithValue("@dteBirthDate", Details.BirthDate.ToString("yyyy-MM-dd"));

				bool bolRetValue = false;
				if (base.ExecuteNonQuery(cmd) > 0) bolRetValue = true;
				return bolRetValue;
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Exemplo n.º 3
0
        public bool Update(ContactRewardDetails Details)
        {
            try
            {
                return(Insert(Details));
            }

            catch (Exception ex)
            {
                throw base.ThrowException(ex);
            }
        }
Exemplo n.º 4
0
        public ContactRewardDetails Details(string RewardCardNo)
        {
            try
            {
                string SQL = SQLSelect() + "WHERE RewardCardNo = @RewardCardNo;";



                MySqlCommand cmd = new MySqlCommand();


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.CommandText = SQL;

                cmd.Parameters.AddWithValue("@RewardCardNo", RewardCardNo);

                MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);

                ContactRewardDetails Details = new ContactRewardDetails();

                while (myReader.Read())
                {
                    Details.ContactID        = myReader.GetInt64("CustomerID");
                    Details.RewardCardNo     = "" + myReader["RewardCardNo"].ToString();
                    Details.RewardActive     = myReader.GetBoolean("RewardActive");
                    Details.RewardPoints     = myReader.GetDecimal("RewardPoints");
                    Details.RewardAwardDate  = myReader.GetDateTime("RewardAwardDate");
                    Details.TotalPurchases   = myReader.GetDecimal("TotalPurchases");
                    Details.RedeemedPoints   = myReader.GetDecimal("RedeemedPoints");
                    Details.RewardCardStatus = (RewardCardStatus)Enum.Parse(typeof(RewardCardStatus), myReader.GetString("RewardCardStatus"));
                    Details.ExpiryDate       = myReader.GetDateTime("ExpiryDate");
                    Details.BirthDate        = myReader.GetDateTime("BirthDate");
                }

                myReader.Close();

                return(Details);
            }

            catch (Exception ex)
            {
                {
                }

                throw base.ThrowException(ex);
            }
        }
Exemplo n.º 5
0
		public bool Update(ContactRewardDetails Details)
		{
			try 
			{
				return Insert(Details);
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
Exemplo n.º 6
0
		public ContactRewardDetails Details(string RewardCardNo)
		{
			try
			{
				string SQL = SQLSelect() + "WHERE RewardCardNo = @RewardCardNo;";

				

				MySqlCommand cmd = new MySqlCommand();
				
				
				cmd.CommandType = System.Data.CommandType.Text;
				cmd.CommandText = SQL;

				cmd.Parameters.AddWithValue("@RewardCardNo", RewardCardNo);

				MySqlDataReader myReader = base.ExecuteReader(cmd, System.Data.CommandBehavior.SingleResult);

				ContactRewardDetails Details = new ContactRewardDetails();

				while (myReader.Read())
				{
					Details.ContactID = myReader.GetInt64("CustomerID");
					Details.RewardCardNo = "" + myReader["RewardCardNo"].ToString();
					Details.RewardActive = myReader.GetBoolean("RewardActive");
					Details.RewardPoints = myReader.GetDecimal("RewardPoints");
					Details.RewardAwardDate = myReader.GetDateTime("RewardAwardDate");
					Details.TotalPurchases = myReader.GetDecimal("TotalPurchases");
					Details.RedeemedPoints = myReader.GetDecimal("RedeemedPoints");
					Details.RewardCardStatus = (RewardCardStatus)Enum.Parse(typeof(RewardCardStatus), myReader.GetString("RewardCardStatus"));
					Details.ExpiryDate = myReader.GetDateTime("ExpiryDate");
					Details.BirthDate = myReader.GetDateTime("BirthDate");
				}

				myReader.Close();

				return Details;
			}

			catch (Exception ex)
			{
				
				
				{
					
					
					
					
				}

				throw base.ThrowException(ex);
			}	
		}