Beispiel #1
0
        /// <summary>
        /// This method finds a list of customers by their navn.
        /// </summary>
        /// <param name="navn"></param>
        /// <returns>List<Table_Kunde></returns>
        public List <Table_Kunde> FindByNavn(string navn)
        {
            List <Table_Kunde> kunder;

            try
            {
                kunder = (from k in db.Table_Kundes where k.navn.Contains(navn) select k).ToList();
            }

            catch (Exception exception)
            {
                Table_Kunde kunde = new Table_Kunde
                {
                    kunde_id = -1000,
                    navn     = exception.Message
                };

                kunder = new List <Table_Kunde>
                {
                    kunde
                };
            }

            return(kunder);
        }
Beispiel #2
0
        /// <summary>
        /// This method lists all customers
        /// </summary>
        /// <returns>List<Table_Kunde></returns>
        public List <Table_Kunde> ListAll()
        {
            List <Table_Kunde> kunder;

            try
            {
                kunder = (from k in db.Table_Kundes select k).ToList();
            }

            catch (Exception exception)
            {
                Table_Kunde kunde = new Table_Kunde
                {
                    kunde_id = -1000,
                    navn     = exception.Message
                };

                kunder = new List <Table_Kunde>
                {
                    kunde
                };
            }

            return(kunder);
        }
Beispiel #3
0
        /// <summary>
        /// This method finds a customer by its kunde_id.
        /// </summary>
        /// <param name="kundeId"></param>
        /// <returns>Table_Kunde</returns>
        public Table_Kunde FindByKundeId(int kunde_id)
        {
            Table_Kunde kunde;

            try
            {
                kunde = db.Table_Kundes.First(k => k.kunde_id.Equals(kunde_id));
            }

            catch (Exception exception)
            {
                kunde = new Table_Kunde
                {
                    kunde_id = -1000,
                    navn     = exception.Message
                };
            }

            return(kunde);
        }
Beispiel #4
0
        /// <summary>
        /// This method creates a customer.
        /// </summary>
        /// <param name="navn"></param>
        /// <returns>string</returns>
        public string Create(string navn)
        {
            Table_Kunde kunde;
            string      result;

            try
            {
                kunde = new Table_Kunde
                {
                    navn = navn
                };

                db.SubmitChanges();

                result = "Success";
            }

            catch (Exception exception)
            {
                result = exception.Message;
            }

            return(result);
        }
 partial void DeleteTable_Kunde(Table_Kunde instance);
 partial void UpdateTable_Kunde(Table_Kunde instance);
 partial void InsertTable_Kunde(Table_Kunde instance);