Ejemplo n.º 1
0
        public void DeleteSalesExecutive(int id)
        {
            SalesExecutive _salesExecutive = _salesExecutiveRepository.GetById(id);

            _salesExecutiveRepository.Delete(_salesExecutive);
            _salesExecutiveRepository.SaveChanges();
        }
Ejemplo n.º 2
0
        public SalesExecutive AddorUpdate(SalesExecutive salesExecutive)
        {
            _salesExecutiveRepository.AddOrUpdate(salesExecutive);
            _salesExecutiveRepository.SaveChanges();

            return(salesExecutive);
        }
Ejemplo n.º 3
0
        public int UpdateSalesExecutive(SalesExecutive objSalesExecutive)
        {
            using (IDbConnection connection = OpenConnection(dataConnection))
            {
                string sql = @"Update SalesExecutive Set SalesExecutiveName=@SalesExecutiveName OUTPUT INSERTED.SalesExecutiveId WHERE SalesExecutiveId=@SalesExecutiveId";


                var id = connection.Execute(sql, objSalesExecutive);
                return(id);
            }
        }
Ejemplo n.º 4
0
        public int InsertSalesExecutive(SalesExecutive objSalesExecutive)
        {
            using (IDbConnection connection = OpenConnection(dataConnection))
            {
                string sql = @"INSERT INTO SalesExecutive (SalesExecutiveName,CreatedBy,CreatedDate,OrganizationId) VALUES(@SalesExecutiveName,@CreatedBy,@CreatedDate,@OrganizationId);
            SELECT CAST(SCOPE_IDENTITY() as int)";


                var id = connection.Query <int>(sql, objSalesExecutive).Single();

                return(id);
            }
        }
Ejemplo n.º 5
0
        public Object GetSalesExecutiveById(int executiveId)
        {
            SalesExecutive salesExecutive = _salesExecutiveRepository.Single(a => a.ExecutiveId == executiveId);

            if (salesExecutive != null)
            {
                return(new
                {
                    SalesExecutive = new { data = salesExecutive, total = 1 }
                });
            }
            else
            {
                return(null);
            }
        }
        static void Main(string[] args)
        {
            Employee Jack = new Employee();

            Jack.SetFullName("Jack Jackson");
            Jack.SetSalary(300000);
            //Employee Jack = new Employee("Jack Jackson", 300000);

            //inherited classes
            ITExecutives Jill = new ITExecutives();

            Jill.SetFullName("Jill White");
            Jill.SetSalary(400000);

            // SalesExecutive John = new SalesExecutive();
            //wont work since no parameterless ctor exists

            SalesExecutive John = new SalesExecutive("John Parker", 300000, 120);

            John.Sales = 20;

            EmployeeInfo(Jack);
            EmployeeInfo(Jill);
            EmployeeInfo(John);

            ///////////////////////////

            //LivingBeing x = new LivingBeing();

            Humans  human = new Humans();
            Cow     cow   = new Cow();
            Cat     cat   = new Cat();
            French  frman = new French();
            Spanish spman = new Spanish();

            List <LivingBeing> livingBeings = new List <LivingBeing>();

            livingBeings.Add(human);
            livingBeings.Add(cat);
            livingBeings.Add(cow);
            livingBeings.Add(frman);
            livingBeings.Add(spman);

            Talk(livingBeings);
            ///////////

            //casting


            Car Nissan = new Car {
                RegNos = 122, TopSpeed = 120
            };
            Car Audi = new Car {
                RegNos = 221, TopSpeed = 170
            };
            Truck Tata = new Truck {
                RegNos = 1011, IsLoaded = false, NoOfTyres = 10
            };
            Truck Mazda = new Truck {
                RegNos = 50501, IsLoaded = true, NoOfTyres = 8
            };
            List <Vehicle> vehicles = new List <Vehicle>
            {
                Nissan,
                Audi,
                Tata,
                Mazda
            };

            VehicleGarrage(vehicles);
            Console.ReadKey();
        }