public bool UpdatePlayerData(PlayerMaintanance oPlayerMaintanance) { bool ReturnValue = false; try { using (HttpClient client = new HttpClient()) { string path = "Player/UpdatePlayerData"; client.BaseAddress = new Uri(GlobalValues.BaseUri); var json = JsonConvert.SerializeObject(oPlayerMaintanance); var content = new StringContent(json, Encoding.UTF8, "application/json"); HttpResponseMessage responce = client.PostAsync(path, content).Result; if (responce.IsSuccessStatusCode) { string jsnString = responce.Content.ReadAsStringAsync().Result; ReturnValue = JsonConvert.DeserializeObject <bool>(jsnString); } } } catch (Exception ex) { string message = ex.Message; } return(ReturnValue); }
private void UpdatePlayerData() { bool result = false; try { #region Player PlayerDTO oPlayerDTO = new PlayerDTO(); oPlayerDTO.PlayerId = Convert.ToInt32(Session["PlayerId"].ToString()); oPlayerDTO.Name = txtName.Text; oPlayerDTO.Address = txtAddress.Text; oPlayerDTO.Telephone = txtTelephone.Text; oPlayerDTO.Email = txtEmail.Text; oPlayerDTO.Description = txtDescription.InnerText; oPlayerDTO.Type = Convert.ToInt32(ddlType.SelectedValue.ToString()); oPlayerDTO.JoinDate = Convert.ToDateTime(txtJoinDate.Text); //oPlayerDTO.NumberOfShares = Convert.ToInt32(txtNoOfShares.Text); //oPlayerDTO.SharePrice = Convert.ToDecimal(txtSharePrice.Text); oPlayerDTO.Status = Convert.ToInt32(ddlStatus.SelectedValue.ToString()); oPlayerDTO.UserName = txtUserName.Text; string EncryptedPwd = Cryptography.Encryption.Encrypt(txtPassword.Text, txtUserName.Text); oPlayerDTO.Password = EncryptedPwd; oPlayerDTO.ModifiedUser = Session["UserID"].ToString(); oPlayerDTO.ModifiedDateTime = DateTime.Now; oPlayerDTO.ModifiedMachine = Session["UserMachine"].ToString(); #endregion #region Login LoginDTO oLoginDTOs = new LoginDTO(); oLoginDTOs.UserName = txtUserName.Text; oLoginDTOs.Password = EncryptedPwd; oLoginDTOs.UserType = Convert.ToInt32(Session["UserType"].ToString()); oLoginDTOs.LoginAttempts = 1; oLoginDTOs.ModifiedUser = Session["UserID"].ToString(); oLoginDTOs.ModifiedDateTime = DateTime.Now; oLoginDTOs.ModifiedMachine = Session["UserMachine"].ToString(); #endregion PlayerMaintanance oPlayerMaintanance = new PlayerMaintanance(); oPlayerMaintanance.oPlayerDTO = oPlayerDTO; oPlayerMaintanance.oLoginDTO = oLoginDTOs; result = oWebApiCalls.UpdatePlayerData(oPlayerMaintanance); if (result == true) { ResetControllers(); Messages("Player Updated Successfully!!"); } else { Messages("Connection Error!"); } } catch (Exception ex) { throw ex; } }
protected void btnPAdd_Click(object sender, EventArgs e) { bool result = false; try { PlayerDTO oPlayerDTOs = new PlayerDTO(); oPlayerDTOs.Name = txtPName.Text; oPlayerDTOs.Address = txtPAddress.Text; oPlayerDTOs.Telephone = txtPTelephone.Text; oPlayerDTOs.Email = txtPEmail.Text; oPlayerDTOs.Description = txtPDescription.InnerText; oPlayerDTOs.Type = Convert.ToInt32(ddlPType.SelectedValue.ToString()); oPlayerDTOs.JoinDate = Convert.ToDateTime(dtpPJoinDate.Text); oPlayerDTOs.Status = Convert.ToInt32(ddlPStatus.SelectedValue.ToString()); oPlayerDTOs.UserName = txtUserName.Text; string EncryptedPwd = Cryptography.Encryption.Encrypt(txtPPassword.Text, txtPUserName.Text); oPlayerDTOs.Password = EncryptedPwd; oPlayerDTOs.CreatedUser = Session["UserID"].ToString(); oPlayerDTOs.CreatedDateTime = DateTime.Now; oPlayerDTOs.CreatedMachine = Session["UserMachine"].ToString(); oPlayerDTOs.ModifiedUser = Session["UserID"].ToString(); oPlayerDTOs.ModifiedDateTime = DateTime.Now; oPlayerDTOs.ModifiedMachine = Session["UserMachine"].ToString(); #region Login LoginDTO oLoginDTOs = new LoginDTO(); oLoginDTOs.UserName = txtPUserName.Text; oLoginDTOs.Password = EncryptedPwd; oLoginDTOs.UserType = Convert.ToInt32(Session["UserType"].ToString()); oLoginDTOs.LoginAttempts = 1; oLoginDTOs.CreatedUser = Session["UserID"].ToString(); oLoginDTOs.CreatedDateTime = DateTime.Now; oLoginDTOs.CreatedMachine = Session["UserMachine"].ToString(); oLoginDTOs.ModifiedUser = Session["UserID"].ToString(); oLoginDTOs.ModifiedDateTime = DateTime.Now; oLoginDTOs.ModifiedMachine = Session["UserMachine"].ToString(); #endregion PlayerMaintanance oPlayerMaintanance = new PlayerMaintanance(); oPlayerMaintanance.oPlayerDTO = oPlayerDTOs; oPlayerMaintanance.oLoginDTO = oLoginDTOs; result = oWebApiCalls.InsertPlayerData(oPlayerMaintanance); if (result == true) { ResetControllers(); Messages("Player Inserted Successfully!!"); } else { Messages("Connection Error!"); } } catch (Exception ex) { throw ex; } }
public bool UpdatePlayerData(PlayerMaintanance oPlayerMaintanance) { return(oPlayerBL.PlayerUpdate(oPlayerMaintanance)); }
public bool InsertPlayerData(PlayerMaintanance oPlayerMaintanance) { return(oPlayerBL.PlayerInsert(oPlayerMaintanance)); }
public bool PlayerInsert(PlayerMaintanance oPlayerMaintanance) { PlayerDTO oPlayerDTOs = oPlayerMaintanance.oPlayerDTO; LoginDTO oLoginDTOs = oPlayerMaintanance.oLoginDTO; int resultCount = 0; try { using (UniversalConnection oUniversalConnection = new UniversalConnection(Connection.Common.ConnectionString)) { StringBuilder varname1 = new StringBuilder(); varname1.Append("INSERT INTO Player \n"); varname1.Append(" (Name, \n"); varname1.Append(" Address, \n"); varname1.Append(" Telephone, \n"); varname1.Append(" Email, \n"); varname1.Append(" Description, \n"); varname1.Append(" Type, \n"); varname1.Append(" JoinDate, \n"); varname1.Append(" Status, \n"); varname1.Append(" UserName, \n"); varname1.Append(" Password, \n"); varname1.Append(" CreatedUser, \n"); varname1.Append(" CreatedMachine, \n"); varname1.Append(" CreatedDateTime, \n"); varname1.Append(" ModifiedUser, \n"); varname1.Append(" ModifiedMachine, \n"); varname1.Append(" ModifiedDateTime) \n"); varname1.Append("VALUES (?Name, \n"); varname1.Append(" ?Address, \n"); varname1.Append(" ?Telephone, \n"); varname1.Append(" ?Email, \n"); varname1.Append(" ?Description, \n"); varname1.Append(" ?Type, \n"); varname1.Append(" ?JoinDate, \n"); varname1.Append(" ?Status, \n"); varname1.Append(" ?UserName, \n"); varname1.Append(" ?Password, \n"); varname1.Append(" ?CreatedUser, \n"); varname1.Append(" ?CreatedMachine, \n"); varname1.Append(" ?CreatedDateTime, \n"); varname1.Append(" ?ModifiedUser, \n"); varname1.Append(" ?ModifiedMachine, \n"); varname1.Append(" ?ModifiedDateTime)"); oUniversalConnection.CommandText = varname1.ToString(); oUniversalConnection.Parameters.Clear(); oUniversalConnection.Parameters.Add(new Parameter { Name = "Name", Value = (object)oPlayerDTOs.Name ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Address", Value = (object)oPlayerDTOs.Address ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Telephone", Value = (object)oPlayerDTOs.Telephone ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Email", Value = (object)oPlayerDTOs.Email ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Description", Value = (object)oPlayerDTOs.Description ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Type", Value = (object)oPlayerDTOs.Type ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "JoinDate", Value = (object)oPlayerDTOs.JoinDate ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Status", Value = (object)oPlayerDTOs.Status ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserName", Value = (object)oPlayerDTOs.UserName ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Password", Value = (object)oPlayerDTOs.Password ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedUser", Value = (object)oPlayerDTOs.CreatedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedMachine", Value = (object)oPlayerDTOs.CreatedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedDateTime", Value = (object)oPlayerDTOs.CreatedDateTime ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedUser", Value = (object)oPlayerDTOs.ModifiedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedMachine", Value = (object)oPlayerDTOs.ModifiedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedDateTime", Value = (object)oPlayerDTOs.ModifiedDateTime ?? DBNull.Value }); resultCount = oUniversalConnection.ExecuteQuery(); StringBuilder varname2 = new StringBuilder(); varname2.Append("INSERT INTO Users \n"); varname2.Append(" (UserName, \n"); varname2.Append(" Password, \n"); varname2.Append(" UserType, \n"); varname2.Append(" LoginAttempts, \n"); varname2.Append(" CreatedUser, \n"); varname2.Append(" CreatedMachine, \n"); varname2.Append(" CreatedDateTime, \n"); varname2.Append(" ModifiedUser, \n"); varname2.Append(" ModifiedMachine, \n"); varname2.Append(" ModifiedDateTime) \n"); varname2.Append("VALUES (?UserName, \n"); varname2.Append(" ?Password, \n"); varname2.Append(" ?UserType, \n"); varname2.Append(" ?LoginAttempts, \n"); varname2.Append(" ?CreatedUser, \n"); varname2.Append(" ?CreatedMachine, \n"); varname2.Append(" ?CreatedDateTime, \n"); varname2.Append(" ?ModifiedUser, \n"); varname2.Append(" ?ModifiedMachine, \n"); varname2.Append(" ?ModifiedDateTime)"); oUniversalConnection.CommandText = varname2.ToString(); oUniversalConnection.Parameters.Clear(); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserName", Value = (object)oLoginDTOs.UserName ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Password", Value = (object)oLoginDTOs.Password ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserType", Value = (object)oLoginDTOs.UserType ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "LoginAttempts", Value = (object)oLoginDTOs.LoginAttempts ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedUser", Value = (object)oLoginDTOs.CreatedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedMachine", Value = (object)oLoginDTOs.CreatedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "CreatedDateTime", Value = (object)oLoginDTOs.CreatedDateTime ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedUser", Value = (object)oLoginDTOs.ModifiedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedMachine", Value = (object)oLoginDTOs.ModifiedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedDateTime", Value = (object)oLoginDTOs.ModifiedDateTime ?? DBNull.Value }); resultCount = oUniversalConnection.ExecuteQuery(); return(resultCount > 0); } } catch (Exception ex) { Logger.Write(ex); throw ex; } }
public bool PlayerUpdate(PlayerMaintanance oPlayerMaintanance) { PlayerDTO oPlayerDTOs = oPlayerMaintanance.oPlayerDTO; LoginDTO oLoginDTOs = oPlayerMaintanance.oLoginDTO; int resultCount = 0; try { using (UniversalConnection oUniversalConnection = new UniversalConnection(Connection.Common.ConnectionString)) { oUniversalConnection.Parameters.Clear(); StringBuilder varname1 = new StringBuilder(); varname1.Append("UPDATE Player \n"); varname1.Append("SET \n"); varname1.Append(" Name = ?Name, \n"); varname1.Append(" Address = ?Address, \n"); varname1.Append(" Telephone = ?Telephone, \n"); varname1.Append(" Email = ?Email, \n"); varname1.Append(" Description = ?Description, \n"); varname1.Append(" Type = ?Type, \n"); varname1.Append(" JoinDate = ?JoinDate, \n"); varname1.Append(" Status = ?Status, \n"); varname1.Append(" UserName = ?UserName, \n"); varname1.Append(" Password = ?Password, \n"); varname1.Append(" ModifiedUser = ?ModifiedUser, \n"); varname1.Append(" ModifiedMachine = ?ModifiedMachine, \n"); varname1.Append(" ModifiedDateTime = ?ModifiedDateTime \n"); varname1.Append(" WHERE PlayerId = ?PlayerId"); oUniversalConnection.CommandText = varname1.ToString(); oUniversalConnection.Parameters.Add(new Parameter { Name = "PlayerId", Value = (object)oPlayerDTOs.PlayerId ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Name", Value = (object)oPlayerDTOs.Name ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Address", Value = (object)oPlayerDTOs.Address ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Telephone", Value = (object)oPlayerDTOs.Telephone ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Email", Value = (object)oPlayerDTOs.Email ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Description", Value = (object)oPlayerDTOs.Description ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Type", Value = (object)oPlayerDTOs.Type ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "JoinDate", Value = (object)oPlayerDTOs.JoinDate ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Status", Value = (object)oPlayerDTOs.Status ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserName", Value = (object)oPlayerDTOs.UserName ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Password", Value = (object)oPlayerDTOs.Password ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedUser", Value = (object)oPlayerDTOs.ModifiedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedMachine", Value = (object)oPlayerDTOs.ModifiedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedDateTime", Value = (object)oPlayerDTOs.ModifiedDateTime ?? DBNull.Value }); resultCount = oUniversalConnection.ExecuteQuery(); StringBuilder varname2 = new StringBuilder(); varname2.Append("UPDATE Users \n"); varname2.Append(" SET [UserName] = ?UserName \n"); varname2.Append(" ,[Password] = ?Password \n"); varname2.Append(" ,[UserType] = ?UserType \n"); varname2.Append(" ,[LoginAttempts] = ?LoginAttempts \n"); varname2.Append(" ,[ModifiedUser] = ?ModifiedUser \n"); varname2.Append(" ,[ModifiedMachine] = ?ModifiedMachine \n"); varname2.Append(" ,[ModifiedDateTime] = ?ModifiedDateTime \n"); varname2.Append("WHERE UserName = ?UserName \n"); oUniversalConnection.CommandText = varname2.ToString(); oUniversalConnection.Parameters.Clear(); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserName", Value = (object)oLoginDTOs.UserName ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "Password", Value = (object)oLoginDTOs.Password ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "UserType", Value = (object)oLoginDTOs.UserType ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "LoginAttempts", Value = (object)oLoginDTOs.LoginAttempts ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedUser", Value = (object)oLoginDTOs.ModifiedUser ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedMachine", Value = (object)oLoginDTOs.ModifiedMachine ?? DBNull.Value }); oUniversalConnection.Parameters.Add(new Parameter { Name = "ModifiedDateTime", Value = (object)oLoginDTOs.ModifiedDateTime ?? DBNull.Value }); oUniversalConnection.ExecuteQuery(); } return(resultCount > 0); } catch (Exception ex) { Logger.Write(ex); throw ex; } }