private void PopulateVehicleListDropDown(object sender, EventArgs e)
{
DataTable dtemail = new DataTable();
MySqlConnection con = new MySqlConnection("Server='localhost'; Database='aspcrud';User='******';Password='******';SslMode=None");
try
{
Int32 CustomerID = QueryOperationsGet.CustomerTableOperations.GetCustomerIDByEmail(Session["username"].ToString());
string sqlemail = "select VehicleNo from vehicledetails where CustuserID=" + CustomerID;
MySqlDataAdapter daemail = new MySqlDataAdapter(sqlemail, con);
daemail.Fill(dtemail);
if (dtemail.Rows.Count > 0)
{
SelectVehicle.DataSource = dtemail;
SelectVehicle.DataTextField = "VehicleNo"; // the items to be displayed in the list items
SelectVehicle.DataBind();
SelectVehicle.Visible = true;
}
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Fetch Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally{ con.Close(); }
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
//#region Factory design pattern
//ConsoleColorMethod("Factory design pattern");
//IFactory factory = CreateFactory.GetObject(ObjectType.Customer);
//Console.WriteLine("Get customer object : " + factory.getName());
//factory = CreateFactory.GetObject(ObjectType.Supplier);
//Console.WriteLine("Get supplier object : " + factory.getName());
//#endregion
//#region Adapter design pattern
//IExport target = new PDF_Class();
//target.Export();
//target = new XLS_Class_ObjectAdapter();
//target.Export();
//target = new XLS_Class_ClassAdapter();
//target.Export();
//#endregion
//#region Builder design pattern
//// Client Code
//ReportDirector reportDirector = new ReportDirector();
//ExcelReport excelReport = new ExcelReport();
//Report report = reportDirector.MakeReport(excelReport);
////report.DisplayReport();
//#endregion
#region Decorator design pattern
IMemoryCache _memoryCache = new MemoryCache(new MemoryCacheOptions());
IWeatherService innerService = new WeatherService();
IWeatherService withCachingDecorator = new WeatherServiceCachingDecorator(innerService, _memoryCache);
IWeatherService withLoggingDecorator = new WeatherServiceLoggingDecorator(withCachingDecorator);
// with no cache - first time
Console.WriteLine(withCachingDecorator.GetCurrentWeather("Bangalore"));
// with cache - second time
Console.WriteLine(withCachingDecorator.GetCurrentWeather("Bangalore"));
// with no cache - first time
Console.WriteLine(withLoggingDecorator.GetCurrentWeather("Bangalore"));
// with cache - second time
Console.WriteLine(withLoggingDecorator.GetCurrentWeather("Bangalore"));
Console.ReadLine();
#endregion
//#region Prototype Design Pattern
//Employee emp1 = new Employee();
//emp1.Name = "Amit Naik";
//emp1.Department = "IT";
//Employee emp2 = emp1.GetClone();
//emp2.Name = "Shwetha";
//Console.WriteLine("Emplpyee 1: ");
//Console.WriteLine("Name: " + emp1.Name + ", Department: " + emp1.Department);
//Console.WriteLine("Emplpyee 2: ");
//Console.WriteLine("Name: " + emp2.Name + ", Department: " + emp2.Department);
//#endregion
//#region Memento Design Pattern
//Employee emp1 = new Employee();
//emp1.Name = "Amit Naik";
//emp1.Department = "IT";
//Employee emp2 = emp1.GetClone();
//emp2.Name = "Shwetha";
//Console.WriteLine("Emplpyee 1: ");
//Console.WriteLine("Name: " + emp1.Name + ", Department: " + emp1.Department);
////Console.WriteLine("Emplpyee 2: ");
////Console.WriteLine("Name: " + emp2.Name + ", Department: " + emp2.Department);
//Employee emp3 = emp1.Revert();
//Console.WriteLine("Reverting ");
//Console.WriteLine("Name: " + emp3.Name + ", Department: " + emp3.Department);
//#endregion
//#region Aggregate root design pattern
//Customer customer = new Customer();
//customer.Add(new Address { Type = 1 });
//customer.Add(new Address { Type = 1 });
//#endregion
//#region Iterator design pattern
//Customer customer = new Customer();
//customer.Add(new Address { Type = 1 });
//customer.Add(new Address { Type = 2 });
//// we can avoid manipulating methods like below in Iterator design pattern
////customer.addresses.Add(new Address { Type = 3 });
//// Implementing via Ienumerable
//foreach (var item in customer.GetAddresses())
//{
// Console.WriteLine($"customer address type : {item.Type}");
//}
//// Implementing via IEnumerator
//foreach (var item in customer)
//{
// Console.WriteLine($"customer address type : {item.Type}");
//}
////var x = customer.GetEnumerator();
//#endregion
#region Generic Repository Design Pattern
ConsoleColorMethod("Generic Repository design pattern");
// Generic
IGenericRepository <Employee> repository = null;
repository = new GenericRepository <Employee>();
try
{
var employee = new Employee()
{
Name = "Amit", Salary = 60000, Gender = "Male", Dept = "IT"
};
repository.Add(employee);
repository.Save();
repository = new GenericRepository <Employee>();
var id = repository.GetById(1);
repository = new GenericRepository <Employee>();
var all = repository.GetAll();
repository = new GenericRepository <Employee>();
var id1 = repository.GetById(1);
if (id1 != null)
{
id1.Name = "Amit Naik";
repository.Update(id1);
repository.Save();
repository = new GenericRepository <Employee>();
repository.Delete(1);
repository.Save();
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error : ID not found");
Console.ForegroundColor = ConsoleColor.White;
}
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error :{ex.Message}");
Console.ForegroundColor = ConsoleColor.White;
}
#endregion
#region Non Generic Repository Design Pattern
ConsoleColorMethod("Non Generic Repository design pattern");
// Generic
EmployeeRepository employeeRepository = null;
employeeRepository = new EmployeeRepository();
try
{
var employee = new Employee()
{
Name = "Shweta", Salary = 600000, Gender = "Female", Dept = "IT"
};
employeeRepository.Add(employee);
employeeRepository.Save();
employeeRepository = new EmployeeRepository();
var id = employeeRepository.GetById(1);
employeeRepository = new EmployeeRepository();
var all = employeeRepository.GetAll();
employeeRepository = new EmployeeRepository();
var id1 = employeeRepository.GetById(2);
if (id1 != null)
{
id1.Name = "Shweta Naik";
employeeRepository.Update(id1);
employeeRepository.Save();
employeeRepository = new EmployeeRepository();
employeeRepository.Delete(1);
employeeRepository.Save();
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error : ID not found");
Console.ForegroundColor = ConsoleColor.White;
}
}
catch (Exception ex)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error :{ex.Message}");
Console.ForegroundColor = ConsoleColor.White;
}
#endregion
#region UOW design pattern for Generic Repository
ConsoleColorMethod("UOW design pattern for Generic Repository");
UOW_Generic <Employee> uowG = new UOW_Generic <Employee>(new EmployeeDBContext());
try
{
var employee = new Employee()
{
Name = "Shweta", Salary = 600000, Gender = "Female", Dept = "IT UOW generic"
};
uowG.employeeRepository.Add(employee);
uowG.Complete();
}
catch (Exception ex)
{
uowG.Dispose();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error : {ex.Message}");
Console.ForegroundColor = ConsoleColor.White;
}
#endregion
#region UOW design pattern for Non Generic Repository
ConsoleColorMethod("UOW design pattern for Non Generic Repository");
UnitOfWork uow = new UnitOfWork(new EmployeeDBContext());
try
{
var employee = new Employee()
{
Name = "Shweta", Salary = 600000, Gender = "Female", Dept = "IT UOW non generic"
};
uow.employeeRepository.Add(employee);
uow.Complete();
}
catch (Exception ex)
{
uow.Dispose();
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine($"Error : {ex.Message}");
Console.ForegroundColor = ConsoleColor.White;
}
#endregion
#region Template design pattern
ConsoleColorMethod("Template design pattern");
TemplateHiringProcess hiringProcess = new CSDepartment();
Console.WriteLine("*** Hiring CS students");
hiringProcess.HireFreshers();
Console.WriteLine(Environment.NewLine);
hiringProcess = new EEEDepartment();
Console.ForegroundColor = ConsoleColor.Yellow;
Console.WriteLine("*** Hiring EEE students");
hiringProcess.HireFreshers();
#endregion
#region Singleton Design Pattern
ConsoleColorMethod("Singleton design pattern");
Singleton s1 = Singleton.getInstance();
Singleton s2 = Singleton.getInstance();
s1.myMethod();
// Test for same instance
//if (s1 == s2)
//{
// Console.WriteLine("Objects are the same instance");
//}
#endregion
#region Replace IF with Polyphormism
ConsoleColorMethod("Replace IF with Polyphormism");
Console.WriteLine("Enter your skill set for job opening (like JavaScript,c#,Net)");
//string knowledge = Console.ReadLine();
string knowledge = "javascript";
Console.WriteLine(SimpleFactoryRIP.Create(knowledge.ToLower()));
#endregion
#region Abstract Factory design pattern
ConsoleColorMethod("Abstract Factory design pattern");
var investmentPrivateFactory = InvestmentFactory.CreateFactory("Private");
string productType = investmentPrivateFactory.GetProduct("ICICI").FD(1000);
Console.WriteLine(productType);
Console.WriteLine(InvestmentFactory.CreateFactory("Public").GetProduct("SBI").MF(50000));
#endregion
#region IOC DI Unity
ConsoleColorMethod("IOC DI Unity");
IUnityContainer container = new UnityContainer();
container.RegisterType <IRechargeHandler, RechargeJIO>("JIO");
container.RegisterType <IRechargeHandler, RechargeVodafone>("Vodafone");
IRechargeHandler recharge = container.Resolve <IRechargeHandler>("JIO");
recharge.DoRecharge();
#endregion
#region Lazy loading
ConsoleColorMethod("Lazy loading");
Console.WriteLine("Enter your skill set for job opening (like JavaScript,c#,Net)");
string knowledgeLazyLoading = "Javascript";
Console.WriteLine(LazyLoadingFactory.Create(knowledgeLazyLoading.ToLower()));
// When we call second time, it doesn't add to temp Dictionary in LazyLoadingFactory class file
Console.WriteLine(LazyLoadingFactory.Create(knowledgeLazyLoading.ToLower()));
#endregion
#region Bridge design pattern
ConsoleColorMethod("Bridge design pattern");
Payment order = new CardPayment();
order.IPaymentSystem = new CitiPaymentSystem();
order.MakePayment();
order.IPaymentSystem = new ICICIPaymentSystem();
order.MakePayment();
order = new NetBankingPayment();
order.IPaymentSystem = new CitiPaymentSystem();
order.MakePayment();
#endregion
#region Composite design pattern
ConsoleColorMethod("Composite design pattern");
IEmployeeCDP John = new EmployeeCDP("John", "IT");
IEmployeeCDP Mike = new EmployeeCDP("Mike", "IT");
IEmployeeCDP Jason = new EmployeeCDP("Jason", "HR");
IEmployeeCDP Eric = new EmployeeCDP("Eric", "HR");
IEmployeeCDP Henry = new EmployeeCDP("Henry", "HR");
IEmployeeCDP James = new ManagerCDP("James", "IT")
{
SubOrdinates = { John, Mike }
};
IEmployeeCDP Philip = new ManagerCDP("Philip", "HR")
{
SubOrdinates = { Jason, Eric, Henry }
};
IEmployeeCDP Bob = new ManagerCDP("Bob", "Head")
{
SubOrdinates = { James, Philip }
};
James.GetDetails(1);
#endregion
#region Facade design pattern
ConsoleColorMethod("Facade design pattern");
AadharFacade aadharFacade = new AadharFacade();
aadharFacade.CreateAadhar();
#endregion
#region Chain of Responsibility design pattern
ConsoleColorMethod("Chain of Responsibility design pattern");
NewVehicle selection = new SelectVehicle();
NewVehicle payment = new MakePayment();
NewVehicle serviceBook = new GenerateServiceBook();
NewVehicle insurance = new Insurance();
NewVehicle delivery = new Delivery();
selection.SetProcess(payment);
payment.SetProcess(serviceBook);
serviceBook.SetProcess(insurance);
insurance.SetProcess(delivery);
selection.Proceed("Bajaj Pulsar");
#endregion
#region Strategy design pattern
ConsoleColorMethod("Strategy design pattern");
HashingContext context;
context = new HashingContext(new MD5Hash());
string strSHA1 = context.HashPassword("Amit Naik");
Console.WriteLine("Amit Naik - " + strSHA1);
context = new HashingContext(new SHA384Hash());
string StrSHA384 = context.HashPassword("Shwetha Naik");
Console.WriteLine("Shwetha Naik - " + StrSHA384);
#endregion
#region Strategy design pattern
ConsoleColorMethod("Strategy design pattern");
IImage Image1 = new ProxyImage("Tiger Image");
Console.WriteLine("Image1 calling DisplayImage first time :");
Image1.DisplayImage(); // loading necessary
Console.WriteLine("Image1 calling DisplayImage second time :");
Image1.DisplayImage(); // loading unnecessary
Console.WriteLine("Image1 calling DisplayImage third time :");
Image1.DisplayImage(); // loading unnecessary
Console.WriteLine();
IImage Image2 = new ProxyImage("Lion Image");
Console.WriteLine("Image2 calling DisplayImage first time :");
Image2.DisplayImage(); // loading necessary
Console.WriteLine("Image2 calling DisplayImage second time :");
Image2.DisplayImage(); // loading unnecessary
#endregion
#region Strategy design pattern
ConsoleColorMethod("Strategy design pattern");
//Create a Product with Out Of Stock Status
Subject IPhone = new Subject("IPhone Mobile", 10000, "Out Of Stock");
//User Anurag will be created and user1 object will be registered to the subject
Observer user1 = new Observer("Amit", IPhone);
//User Pranaya will be created and user1 object will be registered to the subject
Observer user2 = new Observer("Shweta", IPhone);
//User Priyanka will be created and user3 object will be registered to the subject
Observer user3 = new Observer("Krishna", IPhone);
Console.WriteLine("IPhone Mobile current state : " + IPhone.getAvailability());
Console.WriteLine();
// Now product is available
IPhone.setAvailability("Available");
#endregion
#region State design pattern
ConsoleColorMethod("State design pattern");
// Initially Vending Machine will be 'noMoneyState'
VendingMachine vendingMachine = new VendingMachine();
Console.WriteLine("Current VendingMachine State : "
+ vendingMachine.vendingMachineState.GetType().Name + "\n");
vendingMachine.DispenseProduct();
vendingMachine.SelectProductAndInsertMoney(50, "Pepsi");
// Money has been inserted so vending Machine internal state
// changed to 'hasMoneyState'
Console.WriteLine("\nCurrent VendingMachine State : "
+ vendingMachine.vendingMachineState.GetType().Name + "\n");
vendingMachine.SelectProductAndInsertMoney(50, "Fanta");
vendingMachine.DispenseProduct();
// Product has been dispensed so vending Machine internal state
// changed to 'NoMoneyState'
Console.WriteLine("\nCurrent VendingMachine State : "
+ vendingMachine.vendingMachineState.GetType().Name);
#endregion
}
