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); } }
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); } }
public bool Update(ContactRewardDetails Details) { try { return(Insert(Details)); } catch (Exception ex) { throw base.ThrowException(ex); } }
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); } }
public bool Update(ContactRewardDetails Details) { try { return Insert(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }
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); } }