internal ApiResult SavePegasusSystem(PegasusSystem req) { ApiResult apiResult = new ApiResult(); try { if (!req.IsValid()) { apiResult.SetFailuresAsStatusInResponseFields(req.StatusDesc); return(apiResult); } req.Save(); apiResult.PegPayID = "" + req.Id; apiResult.SetSuccessAsStatusInResponseFields(); return(apiResult); } catch (Exception ex) { HandleError(nameof(SaveRole), "EXCEPTION", ex.Message); apiResult.SetFailuresAsStatusInResponseFields(ex.Message); } return(apiResult); }
internal int ExecuteNonQuery(string SqlQuery, TimeBoundAccessRequest tbar) { try { PegasusSystem system = PegasusSystem.QueryWithStoredProc("GetSystemById", tbar.SystemCode).FirstOrDefault(); if (system == null) { throw new Exception($"UNABLE TO EXECUTE QUERY ON {tbar.SystemCode} AT THIS TIME"); } ThirdPartyDB thirdPartyDB = new ThirdPartyDB(system.ConnectionString); int rowsAffected = thirdPartyDB.ExecuteNonQuery(SqlQuery); DbQueryLog dbQueryLog = new DbQueryLog(); dbQueryLog.CreatedOn = DateTime.Now; dbQueryLog.CreatedBy = tbar.UserId; dbQueryLog.ModifiedBy = tbar.UserId; dbQueryLog.ModifiedOn = DateTime.Now; dbQueryLog.NumberOfRowsAffected = "Rows Affected = " + rowsAffected; dbQueryLog.QuerySql = SqlQuery; dbQueryLog.RecordDate = DateTime.Now; dbQueryLog.UserId = tbar.UserId; //save db query async Task.Factory.StartNew(() => { dbQueryLog.SaveLog(); }); return(rowsAffected); } catch (Exception ex) { Task.Factory.StartNew(() => { DatabaseHandler dh = new DatabaseHandler(); dh.LogError(nameof(SendOneTimePIN), $"{SqlQuery}, Error:{ex.Message}"); }); throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { try { PegasusSystem system = new PegasusSystem(); system.CreatedBy = (Session["User"] as SystemUser)?.Username; system.CreatedOn = DateTime.Now; system.ModifiedBy = (Session["User"] as SystemUser)?.Username; system.ModifiedOn = DateTime.Now; system.ConnectionString = txtConnectionString.Text; system.SystemCode = txtSysCode.Text; system.SystemName = txtSysName.Text; system.SystemType = ddSysTypes.SelectedValue; ApiResult apiResult = BussinessLogic.cRSystemAPIClient.SavePegasusSystem(system); if (apiResult.StatusCode != Globals.SUCCESS_STATUS_CODE) { //Show Error Message string msg = "ERROR:" + apiResult.StatusDesc; Master.ErrorMessage = msg; return; } DataTable dt = BussinessLogic.cRSystemAPIClient.ExecuteDataSet("GetSystemsForDropDown", new object[] { system.ModifiedBy }).Tables[0]; dataGridResults.DataSource = dt; dataGridResults.DataBind(); string msg1 = "SUCCESS: System Saved Successfully"; Master.ErrorMessage = msg1; return; } catch (Exception ex) { //Show Error Message string msg = "ERROR:" + ex.Message; Master.ErrorMessage = msg; return; } }
internal ApiResult Seed() { ApiResult apiResult = new ApiResult(); try { SystemUser user = new SystemUser(); user.CompanyCode = "PEGASUS"; user.Email = "*****@*****.**"; user.Username = "******"; user.RoleCode = "SUPER-ADMIN"; user.ModifiedBy = "Admin"; user.PhoneNumber = "256752001311"; user.FullName = "Nsubuga Kasozi"; SaveSystemUser(user); //TimeBoundAccessRequest tbar = new TimeBoundAccessRequest(); //tbar.Approver = "nsubugak"; //tbar.ApproverReason = "Test"; //tbar.DurationInMinutes = 15; //tbar.Reason = "To Test"; //tbar.StartTime = DateTime.Now; //tbar.Status = "APPROVED"; //tbar.SystemCode = "ChangeRequestDB"; //tbar.TBPAccessId = DateTime.Now.Ticks.ToString(); //tbar.TypeOfAccess = "FULL"; //tbar.UserId = "nsubugak"; //SaveTimeBoundAccessRequest(tbar); SystemSetting setting = new SystemSetting(); setting.SettingKey = Globals.FILE_PATH_TO_APPROVE_CR_EMAIL_TEMPLATE; setting.SettingValue = @"E:\PePay\ChangeRequestProject\ChangeRequestAPI\ChangeRequestSubSystem\ApproveChangeRequestEmail.html"; SaveSystemSetting(setting); setting = new SystemSetting(); setting.SettingKey = Globals.FILE_PATH_TO_APPROVE_TBAR_EMAIL_TEMPLATE; setting.SettingValue = @"E:\PePay\ChangeRequestProject\ChangeRequestAPI\ChangeRequestSubSystem\ApproveTBAREmail.html"; SaveSystemSetting(setting); setting = new SystemSetting(); setting.SettingKey = Globals.APPROVE_CR_URL; setting.SettingValue = @"localhost:25235/ApproveChangeRequest.aspx"; SaveSystemSetting(setting); setting = new SystemSetting(); setting.SettingKey = Globals.APPROVE_TBAR_URL; setting.SettingValue = @"localhost:25235/ApproveTbarRequest.aspx"; SaveSystemSetting(setting); PegasusSystem system = new PegasusSystem(); system.ConnectionString = "Data Source=(local);Initial Catalog=TestMerchantCoreDB;User Id=sa;Password=T3rr1613;"; system.CreatedBy = "nsubugak"; system.CreatedOn = DateTime.Now; system.ModifiedBy = "nsubugak"; system.ModifiedOn = DateTime.Now; system.SystemCode = "TestMerchantCoreDB"; system.SystemName = "TestMerchantCoreDB"; system.SystemType = "DATABASE"; SavePegasusSystem(system); system = new PegasusSystem(); system.ConnectionString = "192.168.33.8"; system.CreatedBy = "nsubugak"; system.CreatedOn = DateTime.Now; system.ModifiedBy = "nsubugak"; system.ModifiedOn = DateTime.Now; system.SystemCode = "TERMINAL_SVR_1"; system.SystemName = "Terminal Server 1 (33.8)"; system.SystemType = "SERVER"; SavePegasusSystem(system); system = new PegasusSystem(); system.ConnectionString = "192.168.33.9"; system.CreatedBy = "nsubugak"; system.CreatedOn = DateTime.Now; system.ModifiedBy = "nsubugak"; system.ModifiedOn = DateTime.Now; system.SystemCode = "TERMINAL_SVR_2"; system.SystemName = "Terminal Server 2 (33.9)"; system.SystemType = "SERVER"; SavePegasusSystem(system); system = new PegasusSystem(); system.ConnectionString = "Data Source=(local);Initial Catalog=TestGenericPegPayApi;User Id=sa;Password=T3rr1613;"; system.CreatedBy = "nsubugak"; system.CreatedOn = DateTime.Now; system.ModifiedBy = "nsubugak"; system.ModifiedOn = DateTime.Now; system.SystemCode = "TestGenericPegPayApi"; system.SystemName = "TestGenericPegPayApi"; system.SystemType = "DATABASE"; SavePegasusSystem(system); system = new PegasusSystem(); system.ConnectionString = "Data Source=(local);Initial Catalog=ChangeRequestDB;User Id=sa;Password=T3rr1613;"; system.CreatedBy = "nsubugak"; system.CreatedOn = DateTime.Now; system.ModifiedBy = "nsubugak"; system.ModifiedOn = DateTime.Now; system.SystemCode = "ChangeRequestDB"; system.SystemName = "ChangeRequestDB"; system.SystemType = "DATABASE"; SavePegasusSystem(system); SystemType type = new SystemType(); type.CreatedBy = "nsubugak"; type.CreatedOn = DateTime.Now; type.ModifiedBy = "nsubugak"; type.ModifiedOn = DateTime.Now; type.TypeCode = "DATABASE"; type.TypeName = "Database"; SaveSystemType(type); type = new SystemType(); type.CreatedBy = "nsubugak"; type.CreatedOn = DateTime.Now; type.ModifiedBy = "nsubugak"; type.ModifiedOn = DateTime.Now; type.TypeCode = "FIREWALL"; type.TypeName = "Firewall"; SaveSystemType(type); type = new SystemType(); type.CreatedBy = "nsubugak"; type.CreatedOn = DateTime.Now; type.ModifiedBy = "nsubugak"; type.ModifiedOn = DateTime.Now; type.TypeCode = "OTHER_NETWORK"; type.TypeName = "Other Network Device"; SaveSystemType(type); type = new SystemType(); type.CreatedBy = "nsubugak"; type.CreatedOn = DateTime.Now; type.ModifiedBy = "nsubugak"; type.ModifiedOn = DateTime.Now; type.TypeCode = "SERVER"; type.TypeName = "Server"; SaveSystemType(type); AccessType acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "UPDATE"; acesstype.AccessTypeName = "Update Database Data"; acesstype.SystemTypeCode = "DATABASE"; SaveAccessType(acesstype); acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "DELETE"; acesstype.AccessTypeName = "Delete Database Data"; acesstype.SystemTypeCode = "DATABASE"; SaveAccessType(acesstype); acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "INSERT"; acesstype.AccessTypeName = "INSERT Database Data"; acesstype.SystemTypeCode = "DATABASE"; SaveAccessType(acesstype); acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "CREATE"; acesstype.AccessTypeName = "CREATE Database Objects"; acesstype.SystemTypeCode = "DATABASE"; SaveAccessType(acesstype); acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "FULL"; acesstype.AccessTypeName = "FULL Database Access.(Any Query)"; acesstype.SystemTypeCode = "DATABASE"; SaveAccessType(acesstype); acesstype = new AccessType(); acesstype.CreatedBy = "nsubugak"; acesstype.CreatedOn = DateTime.Now; acesstype.ModifiedBy = "nsubugak"; acesstype.ModifiedOn = DateTime.Now; acesstype.AccessTypeCode = "ADMIN_SERVER_ACCESS"; acesstype.AccessTypeName = "Admin Server Access."; acesstype.SystemTypeCode = "SERVER"; SaveAccessType(acesstype); } catch (Exception ex) { apiResult = HandleException(nameof(SendOneTimePIN), $"SeedError, Error:{ex.Message}", ex); } return(apiResult); }
public ApiResult SavePegasusSystem(PegasusSystem req) => cRSubSystemAPI.SavePegasusSystem(req);
public ApiResult SavePegasusSystem(PegasusSystem req) => bll.SavePegasusSystem(req);