Friday 28 December 2012

login Page

create style.css with following code:

body{ margin:0; padding:0; font:normal 11px arial; color:#000;}
#container{ width:100%; }
.header{}
.logo{ padding:5px 10px;}
.headertape{ background:#40a3c0; height:25px;}
.logincontent{width:100%; margin:0 auto; margin:100px 0;}
.login{ border:1px solid #40a3c0; width:320px; height:170px; border-radius:10px;}
.signintitle{ background:#40a3c0; font-size:18px; color:#fff; padding:10px;  border-radius:10px 10px 0 0; text-align:left;}
.username{ padding:20px 0 10px 10px;}
.loginlbl{ color:#3c3c3c; padding:4px 0 5px 0; width:65px; float:left;}
.logintxt{ color:#3c3c3c; padding:0 2px; border:1px solid #40a3c0; width:227px; height:19px; float:left;}
.password{ padding:10px 0 10px 10px; clear:both;}
.submit{ width:320px; text-align:right; clear:both;}
.loginbtn{ background:#b9131a; font-size:12px; font-weight:bold; color:#fff; border:0; padding:3px 10px; border-radius:5px; margin:10px;}
.footer{ bottom:0; background:#ccdfe5; text-align:center; position:fixed; width:100%; padding:5px 0;}


AND

aspx with code of :

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login.aspx.cs" Inherits="Sulekha.Order.Login" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <form id="form1" runat="server">
    <div id="container">
        <div class="header">
            <div class="logo">
                <img src="images/logo.gif" alt="Sulekha" /></div>
            <div class="headertape">
                &nbsp;</div>
        </div>
        <div class="logincontent" align="center">
        <div class="login">
            <div class="signintitle">
                Sign In
            </div>
            <div class="username">
                <asp:Label ID="Label1" runat="server" Text="User Name" CssClass="loginlbl"></asp:Label>
                <asp:TextBox ID="username" runat="server" CssClass="logintxt"></asp:TextBox>
            </div>
            <div class="password">
                <asp:Label ID="Label2" runat="server" Text="Password" CssClass="loginlbl"></asp:Label>
                <asp:TextBox ID="password" runat="server" CssClass="logintxt" TextMode="Password"></asp:TextBox>
            </div>
            <div class="submit"><asp:Button ID="butsign" runat="server" OnClick="Button1_Click" Text="Sign in" CssClass="loginbtn" /></div>
        </div>
        </div>
    </div>
    <div class="footer">&copy; Copyright 2012</div>
    </form>
</body>
</html>

Code in c charp:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.ServiceModel.Description;
using System.Net;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using System.Data;
using System.Data.SqlClient;
using Microsoft.Xrm.Sdk.Query;
using System.Configuration;
using Sulekha.Order.CrmSdk;
using System.Linq.Expressions;
using Xrm;
using System.ComponentModel;
using System.Drawing;



namespace Sulekha.Order
{

    public partial class Login : System.Web.UI.Page
    {
       // public string accountname;


        protected void Page_Load(object sender, EventArgs e)
        {

        }

        public void Button1_Click(object sender, EventArgs e)
        {
            //SqlConnection con = new

            //Entity contacts = new Entity("contact");


            string user = username.Text.ToString();
            string pass = password.Text.ToString();

           
       

            ClientCredentials credentials = new ClientCredentials();
            credentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
            Uri OrganizationUri = new Uri("http://smdev-crm/SulekhaCRM/XRMServices/2011/Organization.svc");
            Uri HomeRealmUri = null;
            using (OrganizationServiceProxy serviceProxy = new OrganizationServiceProxy(OrganizationUri, HomeRealmUri, credentials, null))
            {
                Microsoft.Xrm.Sdk.IOrganizationService service = (Microsoft.Xrm.Sdk.IOrganizationService)serviceProxy;

              


                ConditionExpression condition = new ConditionExpression();
                condition.AttributeName = "new_name";
                condition.Operator = ConditionOperator.Equal;
                condition.Values.Add(user);

                ConditionExpression condition1 = new ConditionExpression();
                condition1.AttributeName = "new_password";
                condition1.Operator = ConditionOperator.Equal;
                condition1.Values.Add(pass);

                FilterExpression filter1 = new FilterExpression();
                filter1.FilterOperator = LogicalOperator.And;
                filter1.Conditions.Add(condition);
                filter1.Conditions.Add(condition1);

                QueryExpression query = new QueryExpression("new_vendorlogindetails");
                query.ColumnSet.AddColumns("new_name", "new_password","new_vendoraccount");
                query.Criteria.AddFilter(filter1);
               

                EntityCollection queryresult = serviceProxy.RetrieveMultiple(query);

      
               

                if (queryresult.Entities.Count > 0)
                {
                    foreach (var a in queryresult.Entities)
                    {

                       // string usernn = a.Attributes["new_name"].ToString();

                        EntityReference vendoraccount = (EntityReference)a.Attributes["new_vendoraccount"];

                        //Guid accountids = vendoraccount.Id;
                        Session["accountname"] = vendoraccount.Name;                     
                       
                    }

                    Response.Redirect("Order_Details.aspx");

                   // ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('valid Username and Password')</script>");

                }
                else
                {
                    ClientScript.RegisterStartupScript(Page.GetType(), "validation", "<script language='javascript'>alert('invalid Username and Password')</script>");
                }
                                
               

            }
        }
    }
}

No comments:

Post a Comment