public static bool Update(CrewViewModel model)
        {
            bool result = true;

            try
            {
                using (var db = new FleetManagementContext())
                {
                    if (model.Id == 0)
                    {
                        MstCrew crw = new MstCrew();
                        crw.CrewId               = model.CrewId;
                        crw.CrewName             = model.CrewName;
                        crw.DrivingLicenseNumber = model.DrivingLicenseNumber;
                        crw.Address              = model.Address;
                        crw.PlaceOfBirth         = model.PlaceOfBirth;
                        crw.DateOfBirth          = model.DateOfBirth;
                        crw.Gender               = model.Gender;
                        crw.Role     = model.Role;
                        crw.IsActive = model.IsActive;
                        db.MstCrews.Add(crw);
                        db.SaveChanges();
                    }
                    else
                    {
                        MstCrew crw = db.MstCrews.Where(o => o.Id == model.Id).FirstOrDefault();
                        if (crw != null)
                        {
                            crw.CrewId               = model.CrewId;
                            crw.CrewName             = model.CrewName;
                            crw.DrivingLicenseNumber = model.DrivingLicenseNumber;
                            crw.Address              = model.Address;
                            crw.PlaceOfBirth         = model.PlaceOfBirth;
                            crw.DateOfBirth          = model.DateOfBirth;
                            crw.Gender               = model.Gender;
                            crw.Role     = model.Role;
                            crw.IsActive = model.IsActive;
                            db.SaveChanges();
                        }
                    }
                }
            }
            catch (Exception Ex)
            {
                Message = Ex.Message;
                result  = false;
            }

            return(result);
        }
        public static bool Delete(int id)
        {
            bool result = true;

            try
            {
                using (var db = new FleetManagementContext())
                {
                    MstCrew crw = db.MstCrews.Where(o => o.Id == id).FirstOrDefault();
                    if (crw != null)
                    {
                        db.MstCrews.Remove(crw);
                        db.SaveChanges();
                    }
                }
            }
            catch (Exception Ex)
            {
                Message = Ex.Message;
                result  = false;
            }
            return(result);
        }