Exemple #1
0
        public ActionResult Search()
        {
            _search.Payment  = new List <Models.Payment>();
            _search.Vehicles = new List <Models.Vehicle>();
            //Fetch data from DB
            using (SoumavoEntities _ent = new SoumavoEntities())
            {
                var paymentDetails = (from a in _ent.Payments select a).ToList();
                foreach (var item in paymentDetails)
                {
                    _search.Payment.Add(new Models.Payment()
                    {
                        Currency = item.Payment_Curr
                    });
                }

                var vehicleDetails = (from a in _ent.Vehicles select a).ToList();
                foreach (var item in vehicleDetails)
                {
                    _search.Vehicles.Add(new Models.Vehicle()
                    {
                        Name = item.Vehicle_Name
                    });
                }
            }

            return(View(_search));
        }
Exemple #2
0
        public ActionResult Update(Models.Search _search)
        {
            string retval = string.Empty;

            using (SoumavoEntities _ent = new SoumavoEntities())
            {
                var result = (from a in _ent.Employees where a.Id.Equals(_search.Id) select a).FirstOrDefault();

                if (result != null)
                {
                    Employee _emp = new Employee()
                    {
                        FromDate = _search.FromDate,
                        Name     = _search.Name,
                        Payment  = _search.PaymentName,
                        ToDate   = _search.ToDate,
                        Vehicle  = _search.VehicleName,
                        Id       = _search.Id,
                    };
                    _ent.Entry(result).CurrentValues.SetValues(_emp);
                    _ent.SaveChanges();
                    TempData["Message"] = "Updated Successfully";
                }
                else
                {
                    TempData["Message"] = "Error Occured";
                }
            }
            return(RedirectToAction("SeeData"));
        }
Exemple #3
0
        public ActionResult Delete(int id)
        {
            bool res = false;

            using (SoumavoEntities _ent = new SoumavoEntities())
            {
                var result = (from a in _ent.Employees where a.Id.Equals(id) select a).FirstOrDefault();
                if (result != null)
                {
                    _ent.Employees.Remove(result);
                    _ent.SaveChanges();
                    res = true;
                }
            }
            return(Json(res));
        }
Exemple #4
0
        public ActionResult Edit(int id)
        {
            List <Models.Vehicle> _veh = new List <Models.Vehicle>();
            List <Models.Payment> _pay = new List <Models.Payment>();

            //new object for every request
            Models.Search _s = new Models.Search();
            using (SoumavoEntities _ent = new SoumavoEntities())
            {
                //populate the vehicle dropdown
                var _vehicleList = (from a in _ent.Vehicles select a).ToList();
                foreach (var item in _vehicleList)
                {
                    _veh.Add(new Models.Vehicle()
                    {
                        Name      = item.Vehicle_Name,
                        VehicleId = item.Id
                    });
                }
                //populate the Payment Dropdown
                var _paymentList = (from a in _ent.Payments select a).ToList();
                foreach (var item in _paymentList)
                {
                    _pay.Add(new Models.Payment()
                    {
                        Currency   = item.Payment_Curr,
                        CurrencyId = item.Id
                    });
                }


                var result = (from a in _ent.Employees where a.Id.Equals(id) select a).FirstOrDefault();
                _s.Name        = result.Name;
                _s.FromDate    = result.FromDate;
                _s.ToDate      = result.ToDate;
                _s.VehicleName = result.Vehicle;
                _s.PaymentName = result.Payment;
                _s.Id          = result.Id;
                _s.Payment     = _pay;
                _s.Vehicles    = _veh;
            }
            return(PartialView(_s));
        }
Exemple #5
0
 public ActionResult Search(Models.Search _search)
 {
     //Save the data to Database
     if (_search != null)
     {
         using (SoumavoEntities _ent = new SoumavoEntities())
         {
             Employee _emp = new Employee()
             {
                 Name     = _search.Name,
                 FromDate = Convert.ToDateTime(Convert.ToDateTime(_search.FromDate).ToShortDateString()),
                 ToDate   = Convert.ToDateTime(Convert.ToDateTime(_search.ToDate).ToShortDateString()),
                 Payment  = _search.PaymentName,
                 Vehicle  = _search.VehicleName
             };
             _ent.Employees.Add(_emp);
             _ent.SaveChanges();
             TempData["Message"] = "Saved";
         }
     }
     return(RedirectToAction("Search", "Home"));
 }
Exemple #6
0
        public List <Employee> SeeData()
        {
            List <Employee> emp = new List <Employee>();

            using (SoumavoEntities _ent = new SoumavoEntities())
            {
                var employeeDetails = (from a in _ent.Employees select a).ToList();
                foreach (var item in employeeDetails)
                {
                    emp.Add(new Employee()
                    {
                        FromDate = item.FromDate,
                        Name     = item.Name,
                        Payment  = item.Payment,
                        ToDate   = item.ToDate,
                        Vehicle  = item.Vehicle,
                        Id       = item.Id
                    });
                }
            }
            return(emp);
        }