MARKUS

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Activation;

using System.ServiceModel.Web;

using System.Text;

namespace KCOM_API

{

    [ServiceContract(Namespace = "")]

    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

    public class MarkusService : System.Web.Services.WebService

    {

        [WebGet(UriTemplate = "AddMember?UserId={UserId}&Name={Name}&Company={Company}&Department={Department}&Position={Position}&email={email}", BodyStyle = WebMessageBodyStyle.Wrapped, RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]

        [OperationContract]

        public AddMemberResults AddMember(string UserId,string Name, string Company, string Department,string Position,string email)

        {

            AddMemberResults results = new AddMemberResults(false,null);

            try

            {

                string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;

                using (CIEntities _ci = new CIEntities(sCIConnString))

                {

                    if (_ci.MEMBER.Count(x => x.ID == UserId) == 0)

                    {

                        _ci.AddToMEMBER(new MEMBER

                        {

                            ID = UserId,

                            NAME = Name,

                            COMPANY = Company,

                            DEPARTMENT = Department,

                            POSITION = Position,

                            EMAIL_ADDRESS = email,

                            MODIFIED_DATETIME = DateTime.Now,

                            CREATE_DATETIME = DateTime.Now

                        });

                        _ci.SaveChanges();

                        results.IsSuccess = true;

                    }

                    else

                    {

                        results.Message = "User already exists.";

                    }

                }

            }

            catch (Exception ex)

            {

                results.Message = "system Error";

            }

            finally

            {

            }

            return results;

        }

        [WebInvoke(UriTemplate = "GetMembers",Method ="POST", BodyStyle = WebMessageBodyStyle.Wrapped, RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]

        [OperationContract]

        public GetMembersResults GetMembers()

        {

            GetMembersResults results = new GetMembersResults();

            try

            {

                string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;

                using (CIEntities _ci = new CIEntities(sCIConnString))

                {

                    if (_ci.MEMBER.Count() > 0)

                    {

                        results.Members = _ci.MEMBER.Select(m => new Member

                        {

                            ID = m.ID,

                            NAME = m.NAME,

                            COMPANY = m.COMPANY,

                            DEPARTMENT = m.DEPARTMENT,

                            POSITION = m.POSITION,

                            EMAIL_ADDRESS = m.EMAIL_ADDRESS

                        }).ToArray();

                    }

                }

            }

            catch (Exception ex)

            {

            }

            finally

            {

            }

            return results;

        }

    }

}