//login
public bool Login(Registar obj)
{
SqlConnection con = new SqlConnection(@"Data Source=BPDESILVA;Initial Catalog=StaffordUniversity;Persist Security Info=True;User ID=sa;Password=123456");
bool log = false;
string query = "SELECT * FROM Registar where username ='******'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
if (reader[2].Equals(obj.getPassword()))
{
log = true;
}
else
{
MessageBox.Show("Incorrect!");
}
}
else
{
MessageBox.Show("Incorrect!");
}
}
finally
{
con.Close();
}
return(log);
}
private void metroButtonRegAddU_Click(object sender, EventArgs e)
{
if (metroTextBoxUnames.Text == "" || metroTextBoxPws.Text == "")
{
MessageBox.Show("Fields cannot be empty");
}
else
{
CommonDBTransaction c = new CommonDBTransaction();
string sql = "SELECT * FROM Registar WHERE Username = '******'";
DataTable d = c.searchData(sql);
metroGridRegs.DataSource = d;
if (d.Rows.Count > 0)
{
MetroMessageBox.Show(this, "This Data already exist");
}
else
{
Registar obj = new Registar(metroTextBoxUnames.Text, metroTextBoxPws.Text);
RegistarTransactions tr = new RegistarTransactions();
tr.addRegistar(obj);
MetroMessageBox.Show(this, "Data Saved Sucessfully !");
clearReg();
}
}
}
public PacketModifierBase(ClientConnection connection, IPacket packetOriginal, Release releaseFrom, Release releaseTarget)
{
Connection = connection;
PacketOriginal = packetOriginal;
ReleaseFrom = releaseFrom;
ReleaseTarget = releaseTarget;
PacketModified = CreatePacket(Registar.GetPacketIdModified(packetOriginal.Header, packetOriginal.Type, releaseFrom, releaseTarget));
}
private void btnLogin_Click(object sender, EventArgs e)
{
string type = metroComboBoxType.SelectedItem.ToString();
metroComboBoxType.Enabled = false;
if (txtUsername.Text == "" && txtPassword.Text == "" || type.Equals(""))
{
MetroMessageBox.Show(this, "Please fill all fields in order to proceed.", "Fields are Empty ! ", MessageBoxButtons.OKCancel, MessageBoxIcon.Hand);
}
else
{
switch (type)
{
case "Student":
Student s = new Student();
s.setUsername(txtUsername.Text);
s.setPassword(txtPassword.Text);
if (st.Login(s) == true)
{
u = txtUsername.Text;
Hide();
StudentHome sh = new StudentHome();
sh.Show();
}
break;
case "Professor":
Professor l = new Professor();
l.setUsername(txtUsername.Text);
l.setPassword(txtPassword.Text);
if (pt.Login(l) == true)
{
u = txtUsername.Text;
Hide();
ProfessorHome ph = new ProfessorHome();
ph.Show();
}
break;
case "Registar":
Registar r = new Registar();
r.setUsername(txtUsername.Text);
r.setPassword(txtPassword.Text);
if (rt.Login(r) == true)
{
u = txtUsername.Text;
Hide();
RegistarHome rh = new RegistarHome();
rh.Show();
}
break;
default:
break;
}
}
}
/// <summary>
/// Responsible for starting everything.
/// </summary>
/// <returns></returns>
public async Task StartAsync()
{
Logger.Information("Starting application");
await Registar.InitializeAsync();
await _clientHandler.StartAsync();
Logger.Information("Started application, press CTRL+C to exit");
}
//add data
public void addRegistar(Registar obj)
{
try
{
string sql = "INSERT INTO Registar (RId,Username,Password)values('2','" + obj.getUsername() + "','" + obj.getPassword() + "')";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public ActionResult Registar(Registar registar)
{
GetRolesForCurrentUser();
if (ModelState.IsValid)
{
bool isUserExists = WebSecurity.UserExists(registar.UserName);
if (isUserExists)
{
ModelState.AddModelError("UserName", "User Name already exists");
}
else
{
WebSecurity.CreateUserAndAccount(registar.UserName, registar.Password, new { FullName = registar.FullName, Email = registar.Email });
Roles.AddUserToRole(registar.UserName, registar.Role);
return(RedirectToAction("Index", "Dashboard"));
}
}
return(View());
}
public void LoadScenery()
{
try
{
GameObject hider = new GameObject();
char dsc = System.IO.Path.DirectorySeparatorChar;
using (WWW www = new WWW("file://" + Path + dsc + "assetbundle" + dsc + "mod"))
{
if (www.error != null)
{
throw new Exception("Loading had an error:" + www.error);
}
AssetBundle bundle = www.assetBundle;
try
{
XmlDocument doc = new XmlDocument();
string[] files = System.IO.Directory.GetFiles(Path, "*.xml");
doc.Load(files[0]);
XmlElement xelRoot = doc.DocumentElement;
XmlNodeList ModNodes = xelRoot.SelectNodes("/Mod");
foreach (XmlNode Mod in ModNodes)
{
modName = Mod["ModName"].InnerText;
modDiscription = Mod["ModDiscription"].InnerText;
}
XmlNodeList ObjectNodes = xelRoot.SelectNodes("/Mod/Objects/Object");
foreach (XmlNode ParkOBJ in ObjectNodes)
{
try
{
ModdedObject MO = null;
GameObject asset = Instantiate(bundle.LoadAsset(ParkOBJ["OBJName"].InnerText)) as GameObject;
asset.name = Identifier + "@" + ParkOBJ["OBJName"].InnerText;
switch (ParkOBJ["Type"].InnerText)
{
case "deco":
DecoMod DM = new DecoMod();
DM.HeightDelta = float.Parse(ParkOBJ["heightDelta"].InnerText);
DM.GridSubdivision = 1f;
DM.SnapCenter = Convert.ToBoolean(ParkOBJ["snapCenter"].InnerText);
DM.category = ParkOBJ["category"].InnerText;
DM.BuildOnGrid = Convert.ToBoolean(ParkOBJ["grid"].InnerText);
DM.gridSubdivision = float.Parse(ParkOBJ["gridSubdivision"].InnerText);
MO = DM;
break;
case "trashbin":
MO = new TrashBinMod();
break;
case "seating":
SeatingMod SM = new SeatingMod();
SM.hasBackRest = false;
MO = SM;
break;
case "seatingAuto":
SeatingAutoMod SMA = new SeatingAutoMod();
SMA.hasBackRest = false;
SMA.seatCount = 2;
MO = SMA;
break;
case "lamp":
MO = new LampMod();
break;
case "fence":
FenceMod FM = new FenceMod();
FM.FenceFlat = null;
FM.FencePost = null;
MO = FM;
break;
case "FlatRide":
FlatRideMod FR = new FlatRideMod();
FR.XSize = (int)float.Parse(ParkOBJ["X"].InnerText);
FR.ZSize = (int)float.Parse(ParkOBJ["Z"].InnerText);
FR.Excitement = float.Parse(ParkOBJ["Excitement"].InnerText);
FR.Intensity = float.Parse(ParkOBJ["Intensity"].InnerText);
FR.Nausea = float.Parse(ParkOBJ["Nausea"].InnerText);
FR.closedAngleRetraints = getVector3(ParkOBJ["RestraintAngle"].InnerText);
RideAnimationMod RA = new RideAnimationMod();
RA.motors = FlatRideLoader.LoadMotors(ParkOBJ, asset);
RA.phases = FlatRideLoader.LoadPhases(ParkOBJ, asset);
FR.Animation = RA;
XmlNodeList WaypointsNodes = ParkOBJ.SelectNodes("Waypoints/Waypoint");
foreach (XmlNode xndNode in WaypointsNodes)
{
Waypoint w = new Waypoint();
w.isOuter = Convert.ToBoolean(xndNode["isOuter"].InnerText);
w.isRabbitHoleGoal = Convert.ToBoolean(xndNode["isRabbitHoleGoal"].InnerText);
if (xndNode["connectedTo"].InnerText != "")
{
w.connectedTo = xndNode["connectedTo"].InnerText.Split(',').ToList().ConvertAll(s => Int32.Parse(s));
}
w.localPosition = getVector3(xndNode["localPosition"].InnerText);
FR.waypoints.Add(w);
}
MO = FR;
break;
case "Shop":
ShopMod S = new ShopMod();
asset.SetActive(false);
XmlNodeList ProductNodes = ParkOBJ.SelectNodes("Shop/Product");
foreach (XmlNode ProductNode in ProductNodes)
{
ProductMod PM = new ProductMod();
switch (ProductNode["Type"].InnerText)
{
case "consumable":
consumable C = new consumable();
C.ConsumeAnimation = (consumable.consumeanimation)Enum.Parse(typeof(consumable.consumeanimation), ProductNode["ConsumeAnimation"].InnerText);
C.Temprature = (consumable.temprature)Enum.Parse(typeof(consumable.temprature), ProductNode["Temprature"].InnerText);
C.portions = Int32.Parse(ProductNode["Portions"].InnerText);
PM = C;
break;
case "wearable":
wearable W = new wearable();
W.BodyLocation = (wearable.bodylocation)Enum.Parse(typeof(wearable.bodylocation), ProductNode["BodyLocation"].InnerText);
PM = W;
break;
case "ongoing":
ongoing O = new ongoing();
O.duration = Int32.Parse(ProductNode["Duration"].InnerText);
PM = O;
break;
default:
break;
}
PM.Name = ProductNode["Name"].InnerText;
PM.GO = Instantiate(bundle.LoadAsset(ProductNode["Model"].InnerText)) as GameObject;
PM.GO.SetActive(false);
PM.Hand = (ProductMod.hand)Enum.Parse(typeof(ProductMod.hand), ProductNode["Hand"].InnerText);
PM.price = float.Parse(ProductNode["Price"].InnerText);
XmlNodeList IngredientNodes = ProductNode.SelectNodes("Ingredients/Ingredient");
foreach (XmlNode IngredientNode in IngredientNodes)
{
ingredient I = new ingredient();
I.Name = IngredientNode["Name"].InnerText;
I.price = float.Parse(IngredientNode["Price"].InnerText);
I.amount = float.Parse(IngredientNode["Amount"].InnerText);
I.tweakable = Boolean.Parse(IngredientNode["tweakable"].InnerText);
XmlNodeList EffectNodes = IngredientNode.SelectNodes("Effects/effect");
foreach (XmlNode EffectNode in EffectNodes)
{
effect E = new effect();
E.Type = (effect.Types)Enum.Parse(typeof(effect.Types), EffectNode["Type"].InnerText);
E.amount = float.Parse(EffectNode["Amount"].InnerText);
I.effects.Add(E);
}
PM.ingredients.Add(I);
}
S.products.Add(PM);
}
MO = S;
break;
case "PathStyle":
Registar.RegisterPath(asset.GetComponent <Renderer>().material.mainTexture, ParkOBJ["inGameName"].InnerText, (Registar.PathType)Enum.Parse(typeof(Registar.PathType), ParkOBJ["PathStyle"].InnerText));
break;
case "CoasterCar":
Debug.Log("Test CoasterCar");
CoasterCarMod CC = new CoasterCarMod();
CC.CoasterName = ParkOBJ["CoasterName"].InnerText;
CC.Name = ParkOBJ["inGameName"].InnerText;
try
{
CC.closedAngleRetraints = getVector3(ParkOBJ["RestraintAngle"].InnerText);
CC.FrontCarGO = Instantiate(bundle.LoadAsset(ParkOBJ["FrontCarGO"].InnerText)) as GameObject;
}
catch
{ }
MO = CC;
MO.Name = ParkOBJ["inGameName"].InnerText;
MO.Object = asset;
break;
default:
break;
}
if (MO != null)
{
MO.Name = ParkOBJ["inGameName"].InnerText;
MO.Object = asset;
MO.Price = float.Parse(ParkOBJ["price"].InnerText);
MO.Shader = ParkOBJ["shader"].InnerText;
if (ParkOBJ["BoudingBoxes"] != null)
{
XmlNodeList BoudingBoxNodes = ParkOBJ.SelectNodes("BoudingBoxes/BoudingBox");
foreach (XmlNode Box in BoudingBoxNodes)
{
BoundingBox BB = MO.Object.AddComponent <BoundingBox>();
BB.isStatic = false;
BB.bounds.min = getVector3(Box["min"].InnerText);
BB.bounds.max = getVector3(Box["max"].InnerText);
BB.layers = BoundingVolume.Layers.Buildvolume;
BB.isStatic = true;
}
}
MO.Recolorable = Convert.ToBoolean(ParkOBJ["recolorable"].InnerText);
if (MO.Recolorable)
{
List <Color> colors = new List <Color>();
if (HexToColor(ParkOBJ["Color1"].InnerText) != new Color(0.95f, 0, 0))
{
colors.Add(HexToColor(ParkOBJ["Color1"].InnerText));
}
if (HexToColor(ParkOBJ["Color2"].InnerText) != new Color(0.32f, 1, 0))
{
colors.Add(HexToColor(ParkOBJ["Color2"].InnerText));
}
Debug.Log("Color 3" + HexToColor(ParkOBJ["Color3"].InnerText));
if (ParkOBJ["Color3"].InnerText != "1C0FFF")
{
colors.Add(HexToColor(ParkOBJ["Color3"].InnerText));
}
if (HexToColor(ParkOBJ["Color4"].InnerText) != new Color(1, 0, 1))
{
colors.Add(HexToColor(ParkOBJ["Color4"].InnerText));
}
MO.Colors = colors.ToArray();
}
Registar.Register(MO).GetComponent <BuildableObject>();
}
}
catch (Exception e)
{
LogException(e);
}
}
}
catch (Exception e)
{
LogException(e);
}
bundle.Unload(false);
Debug.Log("Bundle Unloaded");
}
}
catch (Exception e)
{
LogException(e);
}
}
public void UnloadScenery()
{
Registar.UnRegister();
}
public void onDisabled()
{
Registar.UnRegister();
Object.Destroy(_go);
}
public void TestShopQaRsOrderPro()
{
ShopQaRegistar register = new Registar(driver);
ShopQaHomePage home = new ShopQaHomePage(driver);
ShopQaLoginPage login = new ShopQaLoginPage(driver);
UsefulHelpers helper = new UsefulHelpers();
home.GoToPage();
home.ClickOnRegisterLink();
string firstName = "User" + TestData_String;
string lastName = "New" + TestData_String;
string email = TestData_Email;
string username = "******" + TestData_String;
string password = TestData_password;
register.RegisterUser(firstName, lastName, email, username, password);
home.ClickOnLoginLink();
login.Login(username, password);
//Excel.Worksheet Sheet;
//Sheet = this.CSV.OpenCSV(@"D:\Users\login.csv");
//int rows = Sheet.UsedRange.Rows.Count;
///int columns = Sheet.UsedRange.Columns.Count;
//if ((rows <= 1) || (columns < 2))
//{
// this.LogLine("FAIL - Not enough data to proceed with login");
// Assert.Fail("Not enough data to proceed with login");
//}
//string username = Sheet.Cells[2, 1].Value;
//string password = Sheet.Cells[2, 2].Value;
//this.CSV.Close();
//ShopQaHomePage home = new ShopQaHomePage(driver);
//ShopQaLoginPage login = new ShopQaLoginPage(driver);
//home.GoToPage();
//home.ClickOnLoginLink();
//home = login.Login(username, password);
Excel.Worksheet Sheet;
if (home.WelcomeBack != null) // Successful login
{
Sheet = this.CSV.OpenCSV(@"D:\Users\test-pro-order.csv");
int rows = Sheet.UsedRange.Rows.Count;
int columns = Sheet.UsedRange.Columns.Count;
if ((rows <= 1) || (columns < 2))
{
this.LogLine("FAIL - Not enough data to proceed with tests");
Assert.Fail("Not enough data to proceed with tests");
}
ShopQaCartPage cart;
ShopQaConfirmationPage confirmation;
//bool hasFail = false;
string name, quantity;
for (int i = 2; i <= rows; i++)
{
name = Sheet.Cells[i, 1].Value;
quantity = Convert.ToString(Sheet.Cells[i, 2].Value);
//// shipping = Convert.ToString(Sheet.Cells[i, 3].Value);
// if (shipping != "FREE")
// {
// shipping = $"${shipping}";
// }
home.SelectQuantity(home.PackageProQuantity, quantity);
cart = home.ClickOnOrderPro();
home = cart.ClickContinueShopping();
}
this.CSV.Close();
this.CSV = null;
cart = home.ClickOnViewCart();
Thread.Sleep(5000);
confirmation = cart.ClickCheckout();
home = confirmation.ClickGoBack();
confirmation.ViewHistoryClick();
string text = confirmation.OrderAmount.Text;
string expected = "4800.00";
Assert.AreEqual(text, expected);
}
}
