static void Main(string[] args)
{
//Base class - most senior class
UserController userController = new UserController();
userController.Login("Bart Simpson", "EatMyShorts");
//Inherits from UserController, so gets all it's methods
AdminController adminController = new AdminController();
adminController.Login("Homer Simpson", "Doh");
adminController.SetPermissions("Maggie Simpson");
//Inherits from AdminController, so gets all it's methods and the UserController Methods
SuperAdminController superAdminController = new SuperAdminController();
superAdminController.Login("Marge Simpson", "hmmm...");
superAdminController.SetPermissions("Lisa Simpson");
//Admin inherits name and id from User
Admin admin = new Admin();
admin.id = 123;
admin.name = "batman";
admin.password = "******";
//Buyer inherits name and id from user
Buyer buyer = new Buyer();
buyer.id = 456;
buyer.name = "joker";
//Can't instantantiate because this is an abstract class
//User user = new User();
//MSDBConnection inherited its method from DatabaseConnection Interface
MicrosoftDatabaseConnection dbCon = new MicrosoftDatabaseConnection();
dbCon.OpenConnectionToDatabase("Address");
//Even though these are abstract and interaces we can still construct any object that inherits from them
User user = new Admin();
DatabaseConnection dbConnection = new OracleDatabaseConnection();
Console.ReadLine();
}
public override DbConnection CreateConnection() => OracleDatabaseConnection.CreateConnection(this.As <TestingDb>().ConnectionString);
public List <ProjectBomMode> CallOracleTest(string model, string color)
{
var list = new List <ProjectBomMode>();
var newList = new List <ProjectBomMode>();
try
{
var employeeQuery = @"SELECT
substr(iasy.segment1,1,20) Assembly,( iasy.SEGMENT1||'.'||iasy.SEGMENT2||'.'||iasy.SEGMENT3) ITEM_CODE,iasy.DESCRIPTION,
substr(icmp.segment1,1,20) Component,
substr(comp.component_quantity,1,8) Quantity,
( icmp.SEGMENT1||'.'||icmp.SEGMENT2||'.'||icmp.SEGMENT3) SPARE_ITEM_CODE,icmp.DESCRIPTION SPARE_DESCRIPTION
FROM
apps.mtl_system_items_B iasy,
apps.bom_bill_of_materials bom,
apps.bom_inventory_components comp,
apps.mtl_system_items_B icmp
WHERE
iasy.organization_id = 646 AND
iasy.inventory_item_id = bom.assembly_item_id AND
iasy.organization_id = bom.organization_id AND
bom.bill_sequence_id = comp.bill_sequence_id AND
comp.component_item_id = icmp.inventory_item_id AND
icmp.organization_id = 646 AND
LOWER(icmp.DESCRIPTION) LIKE '%" + model + "%'";
var connection = OracleDatabaseConnection.GetOldConnection();
OracleDataReader oracleDataReader = null;
var oracleCommand = new OracleCommand(employeeQuery, connection)
{
CommandType = CommandType.Text
};
connection.Open();
oracleDataReader = oracleCommand.ExecuteReader();
if (oracleDataReader.HasRows)
{
while (oracleDataReader.Read())
{
var projectBom = new ProjectBomMode
{
ITEM_CODE = oracleDataReader["ITEM_CODE"].ToString(),
DESCRIPTION = oracleDataReader["DESCRIPTION"].ToString(),
Quantity = oracleDataReader["Quantity"].ToString(),
SPARE_ITEM_CODE = oracleDataReader["SPARE_ITEM_CODE"].ToString(),
SPARE_DESCRIPTION = oracleDataReader["SPARE_DESCRIPTION"].ToString()
};
list.Add(projectBom);
}
}
newList = list.Where(a => a.DESCRIPTION.Contains(color)).ToList();
oracleDataReader.Dispose();
connection.Close();
//connection.Dispose();
}
catch (Exception)
{
throw;
}
return(newList);
}
