public void GetNonExistingLandlordData() { CtrLandlord ctrLandlordObj = new CtrLandlord(); MdlLandlord mdlLandlordObj = ctrLandlordObj.GetLandlordData("*****@*****.**"); Assert.IsNull(mdlLandlordObj.ContactPerson); }
public string AddLandlord(MdlLandlord mdlLandlordObj) { using (SqlConnection conn = new SqlConnection(DbConnection.connectionString)) { conn.Open(); return(GetOutput(conn, mdlLandlordObj)); } }
public string AddLandlord(MdlLandlord mdlLandlordObj) { DbLandlord dbLandlordObj = new DbLandlord(); mdlLandlordObj.Salt = CreateSalt(10); mdlLandlordObj.Password = CreateHash(mdlLandlordObj.Password, mdlLandlordObj.Salt); return(dbLandlordObj.AddLandlord(mdlLandlordObj)); }
public string AddLandlord(MdlLandlord mdlLandlordObj) { ctrLandlordObj = new CtrLandlord(); Console.WriteLine(); Console.WriteLine("AddLandlord() " + GetExecutionThreadTime()); return(ctrLandlordObj.AddLandlord(mdlLandlordObj)); }
public bool EditLandlordProfile(MdlLandlord mdlLandlordObj) { ctrLandlordObj = new CtrLandlord(); Console.WriteLine(); Console.WriteLine("EditLandlordProfile() " + GetExecutionThreadTime()); return(ctrLandlordObj.UpdateProfile(mdlLandlordObj)); }
public void AddNewLandlord() { CtrLandlord ctrLandlordObj = new CtrLandlord(); MdlLandlord mdlLandlordObj = GenerateLandlordObj(); string expected = "Registration successful."; string actual; actual = ctrLandlordObj.AddLandlord(mdlLandlordObj).Trim(); Assert.AreEqual(expected, actual); }
public bool UpdateProfile(MdlLandlord mdlLandlordObj) { var option = new TransactionOptions(); option.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; option.Timeout = TimeSpan.FromSeconds(3); using (var scope = new TransactionScope(TransactionScopeOption.Required, option)) { try { using (SqlConnection conn = new SqlConnection(DbConnection.connectionString)) { DataSet ds = GetLandlordDataSet(conn, mdlLandlordObj.Email); DataRow dr = ds.Tables["Landlords"].Rows[0]; SqlDataAdapter da = new SqlDataAdapter("spGetLandlordData", conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@Email", mdlLandlordObj.Email); SqlCommandBuilder builder = new SqlCommandBuilder(da); if (ds.Tables["Landlords"].Rows.Count == 0) { return(false); } dr = UpdateDataRow(dr, mdlLandlordObj); // Update returns number of updated rows int update = da.Update(ds, "Landlords"); scope.Complete(); if (update > 0) { return(true); } else { return(false); } } } catch (Exception e) { Transaction.Current.Rollback(); return(false); } finally { if (scope != null) { ((IDisposable)scope).Dispose(); } } } }
public void GetLandlordData() { string expected = "contactPerson"; string actual; CtrLandlord ctrLandlordObj = new CtrLandlord(); MdlLandlord mdlLandlordObj = ctrLandlordObj.GetLandlordData("*****@*****.**"); actual = mdlLandlordObj.ContactPerson.Trim(); Assert.AreEqual(expected, actual); }
public void AddExistingLandlord() { CtrLandlord ctrLandlordObj = new CtrLandlord(); MdlLandlord mdlLandlordObj = GenerateLandlordObj(); mdlLandlordObj.Email = "*****@*****.**"; string expected = "Registration has failed due to the existing Email."; string actual; actual = ctrLandlordObj.AddLandlord(mdlLandlordObj).Trim(); Assert.AreEqual(expected, actual); }
private string GetOutput(SqlConnection conn, MdlLandlord mdlLandlordObj) { var option = new TransactionOptions(); option.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; option.Timeout = TimeSpan.FromSeconds(3); using (var scope = new TransactionScope(TransactionScopeOption.Required, option)) { try { SqlCommand cmd = new SqlCommand("spExecuteInsertLandlord", conn); //set command type cmd.CommandType = CommandType.StoredProcedure; //input parameters cmd.Parameters.AddWithValue("@EmailInput", mdlLandlordObj.Email); cmd.Parameters.AddWithValue("@PasswordInput", mdlLandlordObj.Password); cmd.Parameters.AddWithValue("@SaltInput", mdlLandlordObj.Salt); cmd.Parameters.AddWithValue("@NameInput", mdlLandlordObj.Name); cmd.Parameters.AddWithValue("@AddressInput", mdlLandlordObj.Address); cmd.Parameters.AddWithValue("@PostCodeInput", mdlLandlordObj.PostCode); cmd.Parameters.AddWithValue("@CityInput", mdlLandlordObj.City); cmd.Parameters.AddWithValue("@CountryInput", mdlLandlordObj.Country); cmd.Parameters.AddWithValue("@ContactPersonInput", mdlLandlordObj.ContactPerson); cmd.Parameters.AddWithValue("@PhoneInput", mdlLandlordObj.Phone); //output parameters SqlParameter outputParameter = new SqlParameter(); outputParameter.ParameterName = "@MessageOutput"; outputParameter.SqlDbType = SqlDbType.Char; outputParameter.Direction = ParameterDirection.Output; outputParameter.Size = 100; cmd.Parameters.Add(outputParameter); //execute cmd.ExecuteNonQuery(); scope.Complete(); return(outputParameter.Value.ToString()); } catch (Exception e) { Transaction.Current.Rollback(); Console.WriteLine("An Error has accured. Registration Terminated. Err:" + e); return("Error"); } finally { if (scope != null) { ((IDisposable)scope).Dispose(); } } } }
private DataRow UpdateDataRow(DataRow dr, MdlLandlord mdlLandlordObj) { dr["Confirmed"] = mdlLandlordObj.Confirmed; dr["Name"] = mdlLandlordObj.Name; dr["Address"] = mdlLandlordObj.Address; dr["PostCode"] = mdlLandlordObj.PostCode; dr["City"] = mdlLandlordObj.City; dr["Country"] = mdlLandlordObj.Country; dr["ContactPerson"] = mdlLandlordObj.ContactPerson; dr["Phone"] = mdlLandlordObj.Phone; return(dr); }
private MdlLandlord GenerateLandlordObj() { MdlLandlord mdlLandlordObj = new MdlLandlord(); mdlLandlordObj.Email = "*****@*****.**"; mdlLandlordObj.Password = "******"; mdlLandlordObj.Name = "CompanyName"; mdlLandlordObj.Address = "Jernbanegade 12A"; mdlLandlordObj.PostCode = "9000"; mdlLandlordObj.City = "Aalborg"; mdlLandlordObj.Country = "Denmark"; mdlLandlordObj.ContactPerson = "Miroslav Pakanec"; mdlLandlordObj.Phone = "+421910245649"; return(mdlLandlordObj); }
private static MdlLandlord GetFilledLandlordObj(DataRow dr) { MdlLandlord mdlLandlordObj = new MdlLandlord(); mdlLandlordObj.Email = dr["Email"].ToString(); mdlLandlordObj.Confirmed = (bool)dr["Confirmed"]; mdlLandlordObj.DateOfCreation = Convert.ToDateTime(dr["DateOfCreation"]); mdlLandlordObj.Name = dr["Name"].ToString(); mdlLandlordObj.Address = dr["Address"].ToString(); mdlLandlordObj.PostCode = dr["PostCode"].ToString(); mdlLandlordObj.City = dr["City"].ToString(); mdlLandlordObj.Country = dr["Country"].ToString(); mdlLandlordObj.ContactPerson = dr["ContactPerson"].ToString(); mdlLandlordObj.Phone = dr["Phone"].ToString(); return(mdlLandlordObj); }
public void UpdateLandlordProfileNonExistingEmail() { CtrLandlord ctrLandlordObj = new CtrLandlord(); MdlLandlord mdlLandlordObj = GenerateLandlordObj(); mdlLandlordObj.Email = "*****@*****.**"; mdlLandlordObj.Name = "CompanyName"; mdlLandlordObj.Country = "Slovakia"; mdlLandlordObj.City = "Neslusa"; mdlLandlordObj.PostCode = "02341"; mdlLandlordObj.Address = "Neslusa 523"; mdlLandlordObj.ContactPerson = "Miroslav Pakanec"; bool expected = false; bool actual = ctrLandlordObj.UpdateProfile(mdlLandlordObj); Assert.AreEqual(expected, actual); }
public MdlLandlord GetLandlordData(string email) { try { using (SqlConnection conn = new SqlConnection(DbConnection.connectionString)) { SqlDataAdapter da = new SqlDataAdapter("spGetLandlordData", conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@Email", email); DataSet ds = new DataSet(); da.Fill(ds, "Landlords"); //opens connection to DB/ executes command/ reads data/ fills Data set/ closing connection DataRow dr = ds.Tables["Landlords"].Rows[0]; return(GetFilledLandlordObj(dr)); } } catch (Exception e) { MdlLandlord emptyObj = new MdlLandlord(); Console.WriteLine("HERE"); return(emptyObj); } }
public bool UpdateProfile(MdlLandlord mdlLandlordObj) { DbLandlord dbLandlordObj = new DbLandlord(); return(dbLandlordObj.UpdateProfile(mdlLandlordObj)); }