কম্পিউটার-মোবাইলে চোখ, যেভাবে যত্ন নেবেন

সারাদিন কম্পিউটার-মোবাইলে চোখ, যেভাবে যত্ন নেবেন

সারাদিন বিভিন্ন কাজের জন্য চোখ রাখতে হয় কম্পিউটার ও মোবাইলে। আর এর জন্য চোখের ওপর অনেক চাপ পড়ে। তাই নিতে হবে চোখের যত্ন। কাজের সময় চোখ ভালো রাখতে মাঝেমধ্যে চোখে পানির ঝাপটা দিন।

টানা আট থেকে নয় ঘণ্টা কম্পিউটারের সামনে বসে থেকে কাজ করা ও ফোনে সারাদিন কথা বলা। সব মিলিয়ে চোখের সমস্যা হওয়া খুবই স্বাভাবিক। তাই এখন বেশিরভাগ মানুষই চমশা ব্যবহার করেন।

কম্পিউটার ও মোবাইল প্রতিনিয়ত ব্যবহার করলে অবশ্যই চোখের যত্ন নিতে হবে। বার্তা সংস্থা ইউএনবি প্রকাশ করেছে এ-সংক্রান্ত একটি প্রতিবেদন। আসুন জেনে নিই কীভাবে চোখের যত্ন নেবেন-

১. কাজের সময় খেয়াল রাখুন চারদিক থেকে অতিরিক্ত আলো যেন আপনার কম্পিউটারে না আসে।

২. চোখ ভালো রাখতে কম্পিটারের আলোর সমন্বয় করে নিতে হবে।

৩. প্রতি তিন থেকে চার সেকেন্ড পর পর চোখের পাতা ফেলা চোখের ছোটখাটো সমস্যার সমাধান করে। তাই ঘন ঘন চোখের পাতা ফেলুন।

৪. একটানা কাজ করবেন না। মাঝে মাঝে চোখ বন্ধ করে চোখকে বিশ্রামও দিন। এতে দৃষ্টিশক্তি ভালো থাকে।

৫. কম্পিউটার ও মোবাইল ফোন অতিরিক্ত ব্যবহার করলে চোখের রেটিনা শুকিয়ে যাওয়ার সমস্যা দেখা দিতে পারে। তাই এই ‘আই ব্লিংকিং’ ব্যায়াম করলে চোখ ভালো থাকে।

৬. কাজের ফাঁকে ফাঁকে চোখকে বিশ্রাম দিন। ৩০ মিনিট পর পর কাজ বন্ধ রাখুন দুই থেকে তিন মিনিটের জন্য। এতে চোখের রক্ত সরবরাহ বাড়বে এবং চোখের পেশি সক্রিয় থাকবে।

৭. সারাক্ষণ বসে থাকবেন না। এদিক-ওদিক হেঁটে আসুন।

৮. মাঝেমধ্যে চোখে পানির ঝাপটা দিন। সারা দিনে ১০ থেকে ১৫ বার চোখে পানির ঝাপটা দিতে পারেন। এতে চোখ ঠাণ্ডা থাকে।

৯. চোখের পানির ঝাপটা দিলে চোখ আর্দ্র হয় ও রক্ত সঞ্চালন বাড়ে। তবে একদম ঠাণ্ডা বা মাত্রাতিরিক্ত গরম পানি চোখে দেবেন না।

১০. প্রচুর পরিমাণে সবুজ শাকসবজি, বাদাম, কমলালেবু খেতে পারেন। এসব খাবার চোখের কর্নিয়া ভালো রাখে।

১২. পর্যাপ্ত ঘুমাতে হবে। সারাদিনের কাজের পর অন্তত আট ঘণ্টা ঘুম জরুরি।

Magic of Asp.net 5. Configure and develop asp.net application inside Mac OSXhare on LinkedIn

• Share on Facebook
• Share on Twitter

Hope you all are fine. Being a senior developer i always like to work/develop in any platforms. It could be either in Windows or Mac. Last couple of days, I was looking new Asp.net 5 and i was wondering to see it's feature of platform independence. Its really amazing. Now any one can develop web application using asp.net 5 inside Mac machine. I am also a proud owner of MacBook Pro :). I was thinking why not i use my Mac as a asp.net development machine. Cool, right? My plan is to cover up the followings:

• What is asp.net 5
• Prerequisite/Installation
• Free awesome editor "Visual Studio Code"
• Basic overview about Yeoman
• Creating Project and running in Mac

What is asp.net 5

According to Asp.net it is as follows:
ASP.NET 5 is a new open-source and cross-platform framework for building modern cloud-based Web applications using .NET. It built from the ground up to provide an optimized development framework for apps that are either deployed to the cloud or run on-premises. It consists of modular components with minimal overhead, so you retain flexibility while constructing your solutions. You can develop and run your ASP.NET 5 applications cross-platform on Windows, Mac and Linux. ASP.NET 5 is fully open source on GitHub. Cool... :)

Prerequisite/Installation

Before jumping into the development, we need to prepare the environment first. Also need to install couple of tools. They are listed down as follows:

• Install Mono for OS X (required by Visual Studio Code).
• Install Visual Studio Code
• Install ASP.NET 5 for Mac OS X 

What is Mono

Mono is a platform independent dot net framework.

https://www.linkedin.com/pulse/magic-aspnet-5-configure-develop-application-inside-mac-arif?trk=hb_ntf_MEGAPHONE_ARTICLE_POST

Domain Driven Design

Domain Driven Design

Domain Driven Design is all about understanding the customer real business need. We have heard of different domains such as Banking, Telecom, Supply chain, health care, etc .So here domain means the business knowledge about that particular industry. Similarly domain driven design is something which focuses more into the business need not focusing on the technology.

We are about to start to write a system, here we first try to understand exactly what customer is looking for, what business they are going to do with the new set of applications in the system. During the initial phase you don’t even think about architecture or programming. Your prime goal is to understand all the terms of business that customer uses and how he/she models the requirement domain.

So what we follow is that the customer discuss each business case in business meetings. Domain driven design purely based on these assumptions to map the business requirement into domain model.

Domain Driven Design is all about how you model your Domain. It means each Domain class should have a direct relation to what it represents in the business domain. It is addressing either in the physical or real world. So a Customer object should be named a Customer in code - it should have the same rules as a Customer does in the real world or as close as it is possible.

Thinking of domain driven design over Normal Layered Architecture

Normal applications follow the following architecture. It works as expected but reaches many drawbacks when it comes to big enterprise systems.



The above architecture fails when the systems keep on growing for an enterprise application.

Typically a large enterprise application, when code base is more maintaining the code is difficult as one simple change in one place may affect in other place. So In this case we should think of domains. The following points are the key considerations for thinking for a domain model.

• You have a complex system to develop with many external, separate or legacy systems involved, large team size or multiple development teams.
• Your system has the same functionality implemented in the same way or different in different places. As developers are not aware about code of other sub systems or other applications in the codebase they change code at one place and it impacts at other place.
• You have more than one object for the same item.
• You have objects that have properties that are not actually attributes of that object.
• You have no or very poor relationship among related items.
• Looking at your objects it is not possible to understand what actually the whole application is all about.
• Where the business requirements change fast with high essential complexity (with a lot of correlated business rules).
• Fatty service layer code keep on going large day by day. No proper code organization and not easy to test the components.
• Business logic is isolated from non-domain and framework code.
• Adding or changing the service does not influence the domain or other services.
• Complexity is in the domain not the technology.

Concepts of Domain Driven Design

Context

Contexts are portions of the solutions space. The setting in which a word or statement appears that determines its meaning.

Domain

The subject area to which the user applies a program is the domain of the software. It is also termed as sphere of knowledge. In a banking system the following are the highlighted domain models.



Model

A system of abstractions that describes selected aspects of a domain and can be used to solve problems related to that domain. The Domain Model itself could be a diagram, code examples or even written documentation of the problem. The important thing is, the Domain Model should be accessible and understandable by everyone who is involved with the system.

Domain Expert

Domain expert is a person who is an owner in a particular area or topic.

Consider a banking system there can be different domains such as Retail Banking, Corporate Banking, Home Lending, Investment Banking, Insurance, cards services, ATMS are of different type of domains. One dedicated person with expertise to a specific domain will be responsible to handle end to end business deliverables and solutions what a business need. Domain experts works closely with developers, end user, project management to successfully deliver a system.

Ubiquitous Language

Ubiquitous language is a language communicated around the domain model and used by all team members to connect all the activities of the team with the software.



Bounded context

A Bounded Context is the boundary in which domain model particular works. This keeps isolated from other domains.

Multiple domain models are in play on any large application. When code based on distinct models is combined, software becomes buggy, unreliable, and difficult to understand. So it is recommended to keep the domain model thin.

Context map

A Context Map is the integration of all the domain models in the systems. Each model might have been developed independent of each other. Over the time the proper integration needs to be done in order to make the system to work from end to end.

For example, an online-retail store company might have one system putting in orders, one for inventory, one for shipping (including tracking), one for payments, etc. Here combination of everything makes the stores business efficient and complete.

Architecture of DDD and Element of DDD

When going for Domain driven design, these are the element of domain driven design.



Entity: An object that can be identified uniquely or by its identifier. Entity can be identified either by its ids or combination of some attributes. Entity is an identity.

Bank Accounts, Loan Account number, Borrower Info, Underwriting Decision, Funding Request are few example of an entity in a banking application.

Value Object: An object that contains attributes but has no conceptual identity.

They are descriptors or properties which are important in the domain you are modelling. Value objects mainly have no setters and immutable in nature. They don't have an identity but they describe the things that do have identities.

Person: is an entity.

Address: is a value object; because 2 people can have same address.

Aggregate : A collection of objects that are bound together by a root entity, otherwise known as an aggregate root. The aggregate root guarantees the consistency of changes being made within the aggregate by forbidding external objects from holding references to its members. The idea of an aggregate is to guarantee consistency, being the root responsible for data integrity and forcing invariants.

Example: When you drive a car, you do not have to worry about what the attribute make it move, making the engine combust with spark and fuel, etc.; you are simply driving the car. In this context, the car is an aggregate of several other objects and serves as the aggregate root to all the other systems.

Domain Event: A domain object that defines an event (something that happens) and is an event that domain experts care about.

Service: Services can be categorized into three types in domain driven design.

Services can be of three types:

• Domain Services
• Application Services
• Infrastructure Services

Domain Services: Domain Services contain operations, actions, or business process and provides the functionality that the domain needs. It deals with all the domain related manipulation.

An example of domain services are catalog service for ecommerce domain which deals with all the catalog related information or account service in accounts domain which deals with all information related to accounts.

Application Services: Application Services are the services used by the outside world which may have representations of data. Example of application service is a database CRUD operation.

Infrastructure services: An Infrastructure Service is service that communicates directly with external resource . For example, accessing file system, registry, SMTP, database etc in the application.

This is some of the basic understanding of Domain driven design. I hope you now have an understanding of Domain Driven Design. Thanks for reading.

Product Windward Report

Windward Report does not run from local machine......


{"There was no endpoint listening at http://funds.julyservices.com/windwardReportServer.svc that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details."}

sql

SELECT     PF.ProductFeeId, PF.FeeItemType, ST.ServiceTypeName, FI.FeeItemName, FI.FeeDescription,
                      CASE WHEN PF.AmountType = 'Percent' THEN dbo.fnFormatPercentage(MIN(Amount), 2) ELSE dbo.fnFormatCurrency(MIN(Amount), 2) END AS Amount, PF.FeeId,FI.SequenceNumber
FROM         dbo.tblProductFees AS PF INNER JOIN
                      dbo.tblFeeItems AS FI ON PF.FeeId = FI.FeeId LEFT OUTER JOIN
                      dbo.ServiceType AS ST ON PF.ServiceTypeID = ST.ServiceTypeID
WHERE     (PF.ProductId = 250)
GROUP BY PF.ProductFeeId, PF.FeeItemType, ST.ServiceTypeName, FI.FeeItemName, FI.FeeDescription, PF.AmountType, PF.FeeId,FI.SequenceNumber
order by Case when PF.feeitemtype='Implementation Fees' then 1
when PF.feeitemtype='Core Recurring Fees' then 2
when PF.feeitemtype='Optional Core Fees' then 3
when PF.feeitemtype='Transaction Fees' then 4
when PF.feeitemtype='Brokerage Window' then 5
Else 6 End,FI.SequenceNumber
///////////////////////////////////////////////////////
SELECT CompanyID,CompanyName,Count(*) AS test FROM vw_ServiceProvider  WHERE CompanyTypeiD=3 and CompanyID in(7016,10797,4694,10607,11372)
Group by CompanyID,CompanyName
order by Case when CompanyName='Mid Atlantic Trust Company' then 1
when CompanyName='Matrix Trust Company' then 2
when CompanyName='Pershing LLC' then 3
when CompanyName='Charles Schwab Trust Company' then 4
Else 5 End
///////////////////////////////////////////////////
SELECT 0 AS CompanyID,'' AS CompanyName
UNION
SELECT DISTINCT CompanyID,CompanyName FROM vw_ServiceProvider  WHERE CompanyTypeiD=3 and CompanyID in(10797,4694,10607,11372)
////////////////////////////////////////////////////////

FK

USE [TPAManager_be]
GO

/****** Object:  Table [dbo].[States]    Script Date: 08/27/2015 01:55:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[States](
[StateNumber] [int] IDENTITY(1,1) NOT NULL,
[State] [nvarchar](50) NULL,
[abrv] [nvarchar](2) NULL,
[ts_upsize] [timestamp] NOT NULL,
 CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED
(
[StateNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]

GO


*******************************
USE [TPAManager_be]
GO

/****** Object:  Table [dbo].[tblCompanyEntityType]    Script Date: 08/27/2015 02:03:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblCompanyEntityType](
[EntityTypeID] [int] IDENTITY(1,1) NOT NULL,
[EntityTypeName] [nvarchar](100) NULL,
[Status] [nvarchar](20) NULL,
 CONSTRAINT [PK_tblCompanyEntityType] PRIMARY KEY CLUSTERED
(
[EntityTypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

****************************************************

USE [TPAManager_be]
GO
/****** Object:  Table [dbo].[States]    Script Date: 08/27/2015 02:02:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[States](
[StateNumber] [int] IDENTITY(1,1) NOT NULL,
[State] [nvarchar](50) NULL,
[abrv] [nvarchar](2) NULL,
[ts_upsize] [timestamp] NOT NULL,
 CONSTRAINT [PK_States] PRIMARY KEY CLUSTERED
(
[StateNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[States] ON
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (1, N'Alabama', N'AL')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (2, N'Alaska', N'AK')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (3, N'Arkansas', N'AR')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (4, N'Arizona', N'AZ')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (5, N'California', N'CA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (6, N'Colorado', N'CO')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (7, N'Connecticut', N'CT')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (8, N'Delaware', N'DE')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (9, N'Florida', N'FL')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (10, N'Georgia', N'GA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (11, N'Hawaii', N'HI')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (12, N'Idaho', N'ID')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (13, N'Indiana', N'IN')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (14, N'Illinois', N'IL')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (15, N'Iowa', N'IA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (16, N'Kansas', N'KS')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (17, N'Kentucky', N'KY')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (18, N'Louisiana', N'LA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (19, N'Maine', N'ME')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (20, N'Maryland', N'MD')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (21, N'Massachusetts', N'MA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (22, N'Michigan', N'MI')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (23, N'Minnesota', N'MN')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (24, N'Mississippi', N'MS')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (25, N'Missouri', N'MO')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (26, N'Montana', N'MT')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (27, N'Nebraska', N'NE')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (28, N'Nevada', N'NV')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (29, N'New Mexico', N'NM')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (30, N'New Hampshire', N'NH')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (31, N'New Jersey', N'NJ')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (32, N'New York', N'NY')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (33, N'North Carolina', N'NC')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (34, N'North Dakota', N'ND')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (35, N'Ohio', N'OH')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (36, N'Oklahoma', N'OK')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (37, N'Oregon', N'OR')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (38, N'Pennsylvania', N'PA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (39, N'Rhode Island', N'RI')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (40, N'South Carolina', N'SC')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (41, N'South Dakota', N'SD')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (42, N'Tennessee', N'TN')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (43, N'Texas', N'TX')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (44, N'Utah', N'UT')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (45, N'Vermont', N'VT')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (46, N'Virginia', N'VA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (47, N'Washington', N'WA')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (48, N'D.C.', N'DC')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (49, N'West Virginia', N'WV')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (50, N'Wisconsin', N'WI')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (51, N'Wyoming', N'WY')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (52, N'Guam', N'GU')
INSERT [dbo].[States] ([StateNumber], [State], [abrv]) VALUES (54, N'Virgin Islands', N'VI')
SET IDENTITY_INSERT [dbo].[States] OFF
/****** Object:  Table [dbo].[tblCompanyEntityType]    Script Date: 08/27/2015 02:02:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tblCompanyEntityType](
[EntityTypeID] [int] IDENTITY(1,1) NOT NULL,
[EntityTypeName] [nvarchar](100) NULL,
[Status] [nvarchar](20) NULL,
 CONSTRAINT [PK_tblCompanyEntityType] PRIMARY KEY CLUSTERED
(
[EntityTypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[tblCompanyEntityType] ON
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (1, N'C-Corporation', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (2, N'LLC Taxed as Corporation', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (3, N'Limited Liability Partnership', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (4, N'Non Profit Corporation', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (5, N'Partnership', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (6, N'Professional Service Corporation', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (7, N'S-Corporation', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (8, N'Sole Proprietor', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (9, N'Other', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (10, N'LLC Taxed as Partnership', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (11, N'Government', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (12, N'LLC Taxed as Sole Proprietorship', N'Active')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (13, N'Sole Proprietorhip', N'Inactive')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (14, N'LLC', N'Inactive')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (15, N'PLLC', N'Inactive')
INSERT [dbo].[tblCompanyEntityType] ([EntityTypeID], [EntityTypeName], [Status]) VALUES (16, N'LLC Taxed as S- Corporation', N'Active')
SET IDENTITY_INSERT [dbo].[tblCompanyEntityType] OFF

Blog

Omar Al Zabir

http://omaralzabir.com/
http://www.codeproject.com/script/Articles/MemberArticles.aspx?amid=138289



Abu Zafor Khairuzzaman
http://azkhairuzzaman.blogspot.com/2010_10_01_archive.html

Mahedee

http://mahedee.net/category/asp-net-mvc-2/

USA

http://www.myprioritydate.com/

http://travel.state.gov/content/visas/english/law-and-policy/bulletin.html

sharepoint

http://softtiger2:4717/_admin/SiteCollections.aspx?ReturnSelectionPage=/applications.aspx
http://softtiger2/_layouts/viewlsts.aspx
http://softtiger2:4717/_admin/SiteCollections.aspx?ReturnSelectionPage=/applications.aspx
http://softtiger2:4717/_layouts/people.aspx?MembershipGroupId=3
http://softtiger2/sites/swd/default.aspx
http://softtiger2:4717/default.aspx

View

http://www.dummies.com/how-to/content/create-a-standard-view-in-sharepoint-2010.html

Refactoring

http://c2.com/cgi/wiki?WhatIsRefactoring

SendEmail

 public void SendEmail(string email, string body, string subject, string sender)
    {
        if (email.Trim() != "" && email.Trim() != " ")
        {
            if (isEmail(email))
            {
                try
                {
                    System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
                    if (sender != "")
                    {
                        message.From = new MailAddress(sender);
                    }
                    else
                    {
                        message.From = new MailAddress("serviceteam@julyservices.com");
                    }

                    var emails = email.Split(new Char[] { ',', ';' });
                    foreach (var to in emails)
                    {
                        if (!String.IsNullOrEmpty(to))
                            message.To.Add(new MailAddress(to));
                    }

                    message.To.Add(new MailAddress(email));
                    message.Subject = subject;
                    message.Body = body;
                    message.Priority = System.Net.Mail.MailPriority.High;
                    message.IsBodyHtml = true;

                    //SmtpClient smtpClient = new SmtpClient("mail.texaspension.com");
                    //smtpClient.UseDefaultCredentials = true;

                    System.Net.Mail.SmtpClient smtpClient = new SmtpClient();
                    smtpClient.Host = "mail.julyservices.com";
                    System.Net.NetworkCredential SMTPUserInfo = new System.Net.NetworkCredential("dp_smtp", "Dp$123456", "julyservices");
                    smtpClient.Credentials = SMTPUserInfo;
                    smtpClient.DeliveryMethod = SmtpDeliveryMethod.Network;

                    smtpClient.Send(message);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }
    }

Upload a file in ASP.NET

http://www.codeproject.com/Articles/1757/File-Upload-with-ASP-NET

public string UploadPersonalFile(HttpPostedFile myFile, string ContactID)
        {
          
            proposalcenterfunctions proposalfunctions = new proposalcenterfunctions();
this.strRootFilePath = @"" + ConfigurationManager.AppSettings["CensusDataFilesParentDirectory"];

            ProjectPath = "Contacts\\" + ContactID;
            PhysicalDirPath = strRootFilePath + ProjectPath;
            DirectoryInfo clientDir = new DirectoryInfo(PhysicalDirPath);
            if (clientDir.Exists == false)
            {
                clientDir.Create();
            }
            // Get size of uploaded file
            int nFileLen = myFile.ContentLength;
            try
            {
                // make sure the size of the file is > 0
                if (nFileLen > 0)
                {
                    // Allocate a buffer for reading of the file
                    byte[] myData = new byte[nFileLen];
                    // Read uploaded file from the Stream
                    myFile.InputStream.Read(myData, 0, nFileLen);
                    // Create a name for the file to store
                    string strFilename = Path.GetFileName(myFile.FileName);
                    string Extension = strFilename.Remove(0, strFilename.LastIndexOf('.'));
                    string fileName = strFilename.Substring(0, strFilename.Length - Extension.Length);
                    var dateTime = DateTime.Now.ToString("MMddyy_hh-mm-ss");
                    strFilename = fileName + "_" + dateTime + Extension;
                    strFullFilePath = PhysicalDirPath + "\\" + strFilename;
                    proposalfunctions.WriteToFile(strFullFilePath, ref myData);
                }
                else
                {
                    strFullFilePath = "";
                }
            }
            catch (Exception ex)
            {
                ExceptionLogger.WriteLog(ex, "UploadFile");
            }

            return strFullFilePath;
        }



 public void WriteToFile(string strPath, ref byte[] Buffer)
        {
            FileStream stream = new FileStream(strPath, FileMode.Create);
            stream.Write(Buffer, 0, Buffer.Length);
            stream.Close();
        }