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);
