public Int16 InsertIntoDatabase() { if (this.created == true) { using (SqlConnection connOne = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString.ToString())) { using (SqlCommand cmdOne = new SqlCommand("InsertBlackList", connOne)) { Int16 result = 0; CustomerClass tmpClass = new CustomerClass(); tmpClass = tmpClass.SelectOneCustomer(this.CustomerID); tmpClass.generateEncryptor(this.CustomerName); cmdOne.CommandType = CommandType.StoredProcedure; cmdOne.Parameters.AddWithValue("@endedAt", this.EndedAt); cmdOne.Parameters.AddWithValue("@reason", this.Reason); cmdOne.Parameters.AddWithValue("@customerId", this.CustomerID); cmdOne.Parameters.AddWithValue("@customerName", tmpClass.generateEncryptor(this.CustomerName)); try { connOne.Open(); result = (Int16)cmdOne.ExecuteNonQuery(); if (result != 1) { throw new NullReferenceException(); } result = tmpClass.UpdateCustomerStatus(tmpClass.ID, tmpClass.Email, "blackListedStatus", true); } catch (SqlException err) { Console.WriteLine(err); result = -3; } catch (NullReferenceException) { result = -3; } catch (OverflowException) { result = -2; } catch { result = -1; } finally { connOne.Close(); } return(result); } } } else { return(0); } }
public Int16 UpdateCustomer(Guid ID, String PastEmail, String firstName, String lastName, String email, String PhoneNumber, DateTime dateOfBirth) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString.ToString())) { Int16 result = 0; CustomerClass tmpClass = new CustomerClass(); tmpClass = tmpClass.SelectOneCustomer(PastEmail); using (SqlCommand cmd = new SqlCommand("UpdateCustomerParticulars", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", ID); cmd.Parameters.AddWithValue("@PastEmail", PastEmail); cmd.Parameters.AddWithValue("@FirstName", tmpClass.generateEncryptor(firstName)); cmd.Parameters.AddWithValue("@LastName", tmpClass.generateEncryptor(lastName)); cmd.Parameters.AddWithValue("@NewEmail", email); cmd.Parameters.AddWithValue("@PhoneNumber", tmpClass.generateEncryptor(PhoneNumber)); cmd.Parameters.AddWithValue("@BirthDate", tmpClass.generateEncryptor(dateOfBirth.ToString())); try { conn.Open(); BlackListClass tmpPower = new BlackListClass(); result = tmpPower.UpdateBlacklistEmails(PastEmail, email); if (result < 0) { throw new OverflowException(); } result = (Int16)cmd.ExecuteNonQuery(); if (result != 1) { throw new OverflowException(); } if (email != PastEmail) { result = UpdateCustomerStatus(ID, PastEmail, "emailStatus", false); } } catch (SqlException err) { Console.WriteLine(err); result = -3; } catch (OverflowException err) { result = -2; } catch { result = -1; } finally { conn.Close(); } return(result); } } }
public BlackListClass SelectOneBlacklist(Guid ID, String customerId) { using (SqlConnection connOne = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString.ToString())) { using (SqlCommand cmdOne = new SqlCommand("SelectOneBlackList", connOne)) { BlackListClass tmpClass = new BlackListClass(); cmdOne.CommandType = CommandType.StoredProcedure; cmdOne.Parameters.AddWithValue("@ID", ID); cmdOne.Parameters.AddWithValue("@customerId", customerId); CustomerClass powerClass = new CustomerClass(); powerClass = powerClass.SelectOneCustomer(customerId); try { connOne.Open(); using (SqlDataReader reader = cmdOne.ExecuteReader()) { if (reader.Read()) { tmpClass.CreatedAt = (DateTime)reader["createdAt"]; tmpClass.EndedAt = (DateTime)reader["endedAt"]; tmpClass.Reason = (String)reader["reason"]; tmpClass.CustomerID = (String)reader["customerId"]; tmpClass.CustomerName = powerClass.generateDecryptor((String)reader["customerName"]); tmpClass.Deleted = (Boolean)reader["deleted"]; } } } catch (Exception err) { Console.WriteLine(err); return(null); } finally { connOne.Close(); } return(tmpClass); } } }
public Int16 UpdateCustomerPassword(Guid ID, String PastEmail, String Password) { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString.ToString())) { Int16 result = 0; CustomerClass tmpClass = new CustomerClass(); tmpClass = tmpClass.SelectOneCustomer(PastEmail); using (SqlCommand cmd = new SqlCommand("UpdateCustomerPassword", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", ID); cmd.Parameters.AddWithValue("@PastEmail", PastEmail); cmd.Parameters.AddWithValue("@ValueOne", tmpClass.updateHashPassword(Password)); try { conn.Open(); result = (Int16)cmd.ExecuteNonQuery(); } catch (SqlException err) { Console.WriteLine(err); result = -3; } catch (OverflowException) { result = -2; } catch { result = -1; } finally { conn.Close(); } return(result); } } }
public List <BlackListClass> SelectAllBlacklist(String customerId) { using (SqlConnection connOne = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDBConnection"].ConnectionString.ToString())) { using (SqlConnection connTwo = new SqlConnection(ConfigurationManager.ConnectionStrings["MySecretDB"].ConnectionString.ToString())) { using (SqlDataAdapter cmdOne = new SqlDataAdapter("SelectAllBlackList", connOne)) { connOne.Open(); connTwo.Open(); cmdOne.SelectCommand.CommandType = CommandType.StoredProcedure; cmdOne.SelectCommand.Parameters.AddWithValue("@customerId", customerId); DataSet newDataSet = new DataSet(); cmdOne.Fill(newDataSet); List <BlackListClass> blacklistList = new List <BlackListClass>(); int rec_cnt = newDataSet.Tables[0].Rows.Count; CustomerClass powerClass = new CustomerClass(); powerClass = powerClass.SelectOneCustomer(customerId); for (int i = 0; i < rec_cnt; i++) { DataRow row = newDataSet.Tables[0].Rows[i]; BlackListClass tmpClass = new BlackListClass(); tmpClass.ID = (Guid)row["ID"]; tmpClass.CreatedAt = (DateTime)row["createdAt"]; tmpClass.EndedAt = (DateTime)row["endedAt"]; tmpClass.Reason = (String)row["reason"]; tmpClass.CustomerID = (String)row["customerId"]; tmpClass.CustomerName = powerClass.generateDecryptor((String)row["customerName"]); tmpClass.Deleted = (Boolean)row["deleted"]; blacklistList.Add(tmpClass); } connOne.Close(); connTwo.Close(); return(blacklistList); } } } }