Skip to main content

#AT Repository and Unit of Work Pattern - 6

we are going to see service file below,

using ContactMang.Business.DB;
using ContactMang.Business.Unit;
using DTO= ContactMangDTO;

public interface IUserService
    {
        List<DTO.LoginUser> GetAllLoginUsers();
        DTO.LoginUser GetLoginUser(string userName);
        DTO.LoginUser GetLoginUser(long userId);
        DTO.LoginUser RegisterLoginUser(DTO.LoginUser loginUser);
    }
------------------------
 public class UserService:IUserService
    {
        private MyUnitOfWork unitOfWork = new MyUnitOfWork();
        public UserService()
        { }

        public List<DTO.LoginUser> GetAllLoginUsers()
        {
            List<DTO.LoginUser> usrList=new List<DTO.LoginUser>();
            DTO.LoginUser usr;
            var useList = unitOfWork.LoginUser.GetData();
            foreach (var item in useList)
            {
                usr = new DTO.LoginUser
                {
                    Id=item.Id,
                    Name = item.Name,
                    Password = item.Password,
                    Status = item.Status
                };
                usrList.Add(usr);
            }
            return usrList;

        }

        public DTO.LoginUser GetLoginUser(long userId)
        {
            DTO.LoginUser luser=new DTO.LoginUser();
            var usr = unitOfWork.LoginUser.FindBy(c => c.Id == userId).FirstOrDefault();
            if (usr!=null)
            {
                luser = new DTO.LoginUser
                {
                    Id = usr.Id,
                    Name = usr.Name,
                    Password = usr.Password,
                    Status = usr.Status
                };
            }
            return luser;
        }

        public DTO.LoginUser GetLoginUser(string userName)
        {
            DTO.LoginUser luser = new DTO.LoginUser();
            var usr = unitOfWork.LoginUser.FindBy(c => c.Name == userName).FirstOrDefault();
            if (usr != null)
            {
                luser = new DTO.LoginUser
                {
                    Id = usr.Id,
                    Name = usr.Name,
                    Password = usr.Password,
                    Status = usr.Status
                };
            }
            return luser;
        }

        public DTO.LoginUser RegisterLoginUser(DTO.LoginUser loginUser)
        {
            LoginUser dbLoginUser = new LoginUser
            {
                Name = loginUser.Name,
                Password = loginUser.Password,
                Status = loginUser.Status
            };
       
            var res= unitOfWork.LoginUser.Insert(dbLoginUser);
            LogRegister lr = new LogRegister { UserId = res.Id ,createdAt = DateTime.Now };
            unitOfWork.LogRegister.Insert(lr);
            unitOfWork.Commit();
       
            return loginUser;

        }
    }
------------------------------------------------
 public interface IContactsService
    {
        DTO.UserContacts GetContacts(long userId);
    }
----------------------------------------------------------
 public class ContactService : IContactsService
    {
        private MyUnitOfWork _unitOfWork;
        public ContactService()
        {
            _unitOfWork = new MyUnitOfWork();
        }

        public DTO.UserContacts GetContacts(long userId)
        {
            DTO.UserContacts usrContacts = new DTO.UserContacts();
            try
            {
                usrContacts.UserId = userId;

                var contactList = _unitOfWork.ContactInfo.FindBy(v => v.UserId == userId);
                List<DTO.Contact> cList = new List<DTO.Contact>();
                if (contactList != null)
                {
                    DTO.Contact contact;
                    foreach (var cont in contactList)
                    {
                        #region contact
                        contact = new DTO.Contact
                        {
                            Id = cont.Id,
                            UserId = cont.UserId,
                            Name = cont.Name,
                            MaildId1 = cont.MaildId1,
                            MaildId2 = cont.MaildId2,
                            Mobile1 = cont.Mobile1,
                            Mobile2 = cont.Mobile2,
                            Mobile3 = cont.Mobile3,
                            Comments = cont.Comments,
                            CreatedAt = cont.CreatedAt,
                            ModifiedAt = cont.ModifiedAt
                        };
                        #endregion

                        var addressList = _unitOfWork.ContactAddress.FindBy(v => v.ContactId == cont.Id);
                        #region Address
                        DTO.Address address;
                        List<DTO.Address> aList = new List<DTO.Address>();
                        if (addressList != null)
                        {
                            foreach (var addr in addressList)
                            {
                                address = new DTO.Address
                                {
                                    id = addr.id,
                                    ContactId = addr.ContactId,
                                    Door = addr.Door,
                                    Street = addr.Street,
                                    Place = addr.Place,
                                    City = addr.City,
                                    Taluk = addr.Taluk,
                                    Distict = addr.City,
                                    State = addr.State,
                                    Country = addr.Country,
                                    Pin = addr.Pin,
                                    Landmark = addr.Landmark
                                };
                                aList.Add(address);
                                contact.AddressList = aList;
                            }
                        }
                        #endregion
                        cList.Add(contact);
                    }
                }
                usrContacts.ContactList = cList;

            }
            catch (Exception)
            {
                 
                throw;
            }

            return usrContacts;
        }
    }

Comments

Popular posts from this blog

Use Log4Net in C# windows form Application

we are going to learn on how to use the Log4Net library for creating logs. Create a new windows form application in VS. Install Log4Net library Add to AssemblyInfo.cs  Configure in  App.config Use in code  Install Log4Net library Then install the Log4Net library from the Nuget Package library.           log4net by The Apache software foundation 2.0.8 (i installed the latest). Add to AssemblyInfo.cs  After installing this package, open up AssemblyInfo .cs file under the Properties folder and add the log4net assembly information into it (under the other assembly information.).    [assembly: log4net.Config.XmlConfigurator(Watch= true )]  Configure in  App.config Now, open the App.config file and enter required details for LogNet to work. <configSections>       <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net, Version=1.2....

#MVC : Why does Html.Label() not work with periods? or Why is @Html.Label() removing some characters

You are misusing the  Html.Label  method. It is for: Returns an HTML label element and the  property name of the property  that is represented by the specified expression. That's why it gets confused if you have a point  .  in the first parameter because it expects a property expression there. However, you can use the second overload: @Html . Label ( "" , String . Format ( "{0}. someText" , 1 )) Or just write out the HTML: <label> @String . Format ( "{0}. someText" , 1 )</ label > or <label class="WelcomeText" style="float: left">Welcome @Html.Label("", Model.USERID + " ( " + Model.ROLE + " )", new { @class = "WelcomeText" })</label> 

#SQL CTE(Common Table expressions)

SQL Server 2005 and on wards, a very powerful feather has been added for the programmers' benefit called CTE. CTE is again a temporary result set derived from the underling definition.  Common Table Expressions offer the same functionality as a view, but are ideal for one-off usages where you don't necessarily need a view defined for the system. CTE offers the advantages of improved readability and ease in maintenance of complex queries . The query can be divided into separate, simple, logical building blocks. These simple blocks can then be used to build more complex, interim CTEs until the final result set is generated. Common Table Expression Syntax A Common Table Expression contains three core parts: The CTE name (this is what follows the WITH keyword) The column list (optional) The query (appears within parentheses after the AS keyword) The query using the CTE must be the first query appearing after the CTE. Syntax : WITH expression_name [ ( column_n...