Friday, March 15, 2013

TABLES JOIN CLAUSE in LINQ ENTITY

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

using System.IO;

namespace LinqSamples
{
    public partial class WebForm5 : System.Web.UI.Page
    {
        TMSMASTEREntities1 SDC = new TMSMASTEREntities1();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TMSMASTERConnectionString"].ConnectionString.ToString());
                BindGrid();             

            }

        }
        private void BindGrid()
        {

            //var query = from d in SDC.Employees
            //            from l in SDC.Students.Where(loc => loc.StudentId == d.EmpID).DefaultIfEmpty()
            //            where d.Emp_Name.Contains("fg") || l.Name.Contains("fgh")
            //            select new
            //            {
            //                Employees = d,
            //                Students = l,
                          
            //            };

            //var results = (from r in query.AsEnumerable()
            //               select new
            //               {
            //                   Emp_Name = r.Employees.Emp_Name,
            //                   Emp_Address = r.Employees.Emp_Address,                              
            //                   StudentId = r.Students.StudentId,
            //                   Name = r.Students.Name,
            //                   Address = r.Students.Address,
            //                   BirthDate = r.Students.BirthDate,
            //                   Image = r.Students.Image,
            //                   Email = r.Students.Email,
            //                   Mobile = r.Students.Mobile,
            //                   Description = r.Students.Description
                             
            //               }).ToList();


            var results = (from d in SDC.Employees
                           join l in SDC.Students on d.EmpID equals l.StudentId                         
                           select new
                           {
                               Emp_Name =d.Emp_Name,
                               Emp_Address =d.Emp_Address,
                               StudentId = l.StudentId,
                               Name = l.Name,
                               Address = l.Address,
                               BirthDate = l.BirthDate,
                               Image = l.Image,
                               Email = l.Email,
                               Mobile = l.Mobile,
                               Description = l.Description
                           }).ToList();
           

            grid.DataSource = results;
            grid.DataBind();

        }

    }
}
- No comments:

JOIN CLAUSE in LINQ ENTITY

 public class Books
    {
        public string ID { get; set; }
        public string Title { get; set; }
        public decimal Price { get; set; }
        public DateTime DateOfRelease { get; set; }

        public static List<Books> GetBooks()
        {
            List<Books> list = new List<Books>();
            list.Add(new Books  {  ID = "001",Title = "Programming in C#", Price = 634.76m, DateOfRelease = Convert.ToDateTime("2010-02-05")  });

            list.Add(new Books  {  ID = "002",Title = "Learn Jave in 30 days", Price = 250.76m, DateOfRelease = Convert.ToDateTime("2011-08-15")  });

            list.Add(new Books  {  ID = "003",Title = "Programming in ASP.Net 4.0", Price = 700.00m, DateOfRelease = Convert.ToDateTime("2011-02-05") });

            list.Add(new Books  {  ID = "004",Title = "VB.Net Made Easy", Price = 500.99m, DateOfRelease = Convert.ToDateTime("2011-12-31")  });

            list.Add(new Books  {  ID = "005",Title = "Programming in C", Price = 314.76m, DateOfRelease = Convert.ToDateTime("2010-02-05")  });

            list.Add(new Books  {  ID = "006",Title = "Programming in C++", Price = 456.76m, DateOfRelease = Convert.ToDateTime("2010-02-05") });

            list.Add(new Books  {  ID = "007",Title = "Datebase Developement",  Price = 1000.76m, DateOfRelease = Convert.ToDateTime("2010-02-05")  });
            return list;
        }

    }



 public class Salesdetails
    {
        public int sales { get; set; }
        public int pages { get; set; }
        public string ID { get; set; }

        public static IEnumerable<Salesdetails> getsalesdetails()
        {
                    Salesdetails[] sd =
              {
              new Salesdetails { ID = "001", pages=678, sales = 110000},
              new Salesdetails { ID = "002", pages=789, sales = 60000},
              new Salesdetails { ID = "003", pages=456, sales = 40000},
              new Salesdetails { ID = "004", pages=900, sales = 80000},
              new Salesdetails { ID = "005", pages=456, sales = 90000},
              new Salesdetails { ID = "006", pages=870, sales = 50000},
              new Salesdetails { ID = "007", pages=675, sales = 40000},
              };
              return sd.OfType<Salesdetails>();
        }
    }


 List<Books> books = Books.GetBooks();

            //SELECT Title from Books
            var booktitles = from b in books select b.Title;
           

            foreach (var title in booktitles)
                Label1.Text += String.Format("{0} <br />", title);

            //The Join clause:
            //query on both the tables using the join clause

            IEnumerable<Books> books1 = Books.GetBooks();
            IEnumerable<Salesdetails> sales =
                                Salesdetails.getsalesdetails();
            var booktitles1 = from b in books1
                             join s in sales
                             on b.ID equals s.ID
                             select new { Name = b.Title, Pages = s.pages };
            foreach (var title in booktitles1)
                Label2.Text += String.Format("{0} <br />", title);


            //The Where clause:
            //The 'where clause' allows adding some conditional filters to the query.

            var booktitles2 = from b in books
                             join s in sales
                             on b.ID equals s.ID
                             where s.pages > 500
                             select new { Name = b.Title, Pages = s.pages };

            foreach (var title in booktitles2)
                Label3.Text += String.Format("{0} <br />", title);

            //The Orderby and Orderbydescending clauses:
            //These clauses allow sorting the query results.

            var booktitles3 = from b in books
                             join s in sales
                             on b.ID equals s.ID
                             orderby b.Price
                             select new
                             {
                                 Name = b.Title,
                                 Pages = s.pages,
                                 Price = b.Price
                             };

            foreach (var title in booktitles3)
                Label4.Text += String.Format("{0} <br />", title);

            //The Let clause:
            //The let clause allows defining a variable and assigning it a value calculated from the data values.

            var booktitles4 = from b in books
                             join s in sales
                             on b.ID equals s.ID
                             let totalprofit = (b.Price * s.sales)
                             select new { Name = b.Title, TotalSale = totalprofit };
            foreach (var title in booktitles4)
                Label5.Text += String.Format("{0} <br />", title);



- No comments:

CREATE READ UPDATE and DELETE - CRUD operations using Entity Framework 4

<table width="80%" cellspacing="1" cellpadding="5" style="background: #ccc">

    <tr style="background: #fff">

        <td colspan="2">

            <strong>Student Management</strong>

        </td>

    </tr>

    <tr style="background: #fff">

        <td colspan="2">

            <asp:Label ID="statusLabel" runat="server" Text="" ForeColor="Red">

            </asp:Label>

        </td>

    </tr>

    <tr style="background: #fff">

        <td colspan="2">

            <asp:GridView ID="grid"

                          runat="server"

                          DataKeyNames="StudentId"                                           

                          OnSelectedIndexChanging="grid_SelectedIndexChanging"

                          OnRowDeleting="grid_RowDeleting"

                          AutoGenerateColumns="false"

                          Width="100%">

            <Columns>

                <asp:TemplateField>

                    <HeaderTemplate>

                        <table width="100%" cellpadding="5" cellspacing="1">

                            <tr>

                                <td align="center" style="width: 5%;">

                                    nbsp;                                 

                                </td>

                                <td align="center" style="width: 5%;">

                                    &nbsp;

                                </td>

                                <td align="left" style="width: 15%">

                                    Name

                                </td>

                                <td align="left" style="width: 15%">

                                    Address

                                </td>

                                <td align="left" style="width: 15%">

                                    Birthdate

                                </td>

                                <td align="left" style="width: 10%">

                                    Photo

                                </td>

                                <td align="left" style="width: 20%">

                                    Email

                                </td>

                                <td align="left" style="width: 15%">

                                    Mobile

                                </td>

                            </tr>

                        </table>

                    </HeaderTemplate>

                    <ItemTemplate>

                        <table width="100%" cellpadding="0" cellspacing="1">

                            <tr>

                                <td align="center" style="width: 5%;">

                                    <asp:ImageButton ID="ImageButton1"

                                                    runat="server"                                                                                CommandName="Select"

                                                     EnableTheming="false"

                                                     ImageUrl="~/Images/edit.png"
                                                    
                                                     AlternateText="Edit"

                                                     CausesValidation="false" />

                                </td>

                                <td align="center" style="width: 5%;">

                                    <asp:ImageButton ID="LinkButton2"

                                                     runat="server"

                                                      ImageUrl="~/Images/delete.png"

                                                      AlternateText="Delete"

                                                     CommandName="Delete"

                                                       EnableTheming="false"

                                                     CausesValidation="false" />

                                </td>

                                <td align="left" style="width: 15%">

                                    <asp:Label ID="lblName" runat="server"

                                              Text='<%# Eval("Name")%>'></asp:Label>

                                </td>

                                <td align="left" style="width: 15%">

                                    <asp:Label ID="lblAddress" runat="server"

                                              Text='<%# Eval("Address")%>'></asp:Label>

                                </td>

                                <td align="center" style="width: 15%">

                                    <asp:Label ID="lblBirthdate" runat="server"

                                             Text='<%# Eval("Birthdate")%>'></asp:Label>

                                </td>

                                <td align="center" style="width: 10%">

                                    <asp:Image ID="imgPhoto" runat="server" Width="30"                                           Height="30"

                                        ImageUrl='<%# "~/Images/" + Eval("Image")%>' />

                                </td>

                                <td align="left" style="width: 20%">

                                    <asp:Label ID="lblEmail" runat="server"

                                              Text='<%# Eval("Email")%>'></asp:Label>

                                </td>

                                <td align="left" style="width: 15%">

                                    <asp:Label ID="lblMobile" runat="server"

                                              Text='<%# Eval("Mobile")%>'></asp:Label>

                                </td>

                            </tr>

                        </table>

                    </ItemTemplate>

                </asp:TemplateField>

            </Columns>

        </asp:GridView>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Name<asp:HiddenField ID="hdnId" runat="server" />

    </td>

    <td>

        <asp:TextBox ID="txtName" runat="server"></asp:TextBox>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Address

    </td>

    <td>

        <asp:TextBox ID="txtAddress" runat="server" TextMode="MultiLine"></asp:TextBox>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Birthdate

    </td>

    <td>

        <asp:TextBox ID="txtBirthdate" runat="server"></asp:TextBox>

        <asp:Calendar ID="calBirthdate" runat="server" 

                      OnSelectionChanged="calBirthdate_SelectionChanged">

        </asp:Calendar>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Image

    </td>

    <td>

        <asp:Image ID="imgThumb" runat="server" Width="100" Height="100" />

        <asp:FileUpload ID="fupImage" runat="server" />

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Email

    </td>

    <td>

        <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Mobile

    </td>

    <td>

        <asp:TextBox ID="txtMobile" runat="server"></asp:TextBox>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        Description

    </td>

    <td>

        <asp:TextBox ID="txtDescription" runat="server" TextMode="MultiLine">

        </asp:TextBox>

    </td>

</tr>

<tr style="background: #fff">

    <td>

        &nbsp;

    </td>

    <td>

        <asp:Button ID="btnAdd" ValidationGroup="add" OnClick="btnAdd_Click"                               runat="server" Text="Submit">

        </asp:Button>

        <asp:Button ID="btnReset" OnClick="btnReset_Click" runat="server"                                        CausesValidation="false" Text="Reset">

        </asp:Button>

        <asp:Button ID="btnUpdate" ValidationGroup="add" OnClick="btnUpdate_Click"                            runat="server" Text="Update">

        </asp:Button>

        <asp:Button ID="btnCancel" CausesValidation="false" OnClick="btnCancel_Click"                      runat="server" Text="Cancel">

        </asp:Button>

    </td>

</tr>

</table>


using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;

using System.IO;

namespace LinqSamples
{
    public partial class WebForm4 : System.Web.UI.Page
    {
        //StudentDbDataContext SDC = new StudentDbDataContext();
        TMSMASTEREntities1 SDC = new TMSMASTEREntities1();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                btnUpdate.Visible = false;

                btnCancel.Visible = false;

                SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TMSMASTERConnectionString"].ConnectionString.ToString());



                BindGrid();

                checkMax();

                bindDDL();

            }

        }
        private void BindGrid()
        {
            var students = from student in SDC.Students

                           select new {
                               student.StudentId,
                               student.Name,
                               student.Address,
                               student.BirthDate,
                               student.Image,
                               student.Email,
                               student.Mobile,
                               student.Description
                           };

            grid.DataSource = students;
            grid.DataBind();

        }



        protected void grid_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
        {

            btnAdd.Visible = false;

            btnReset.Visible = false;

            btnUpdate.Visible = true;

            btnCancel.Visible = true;



            int id =Convert.ToInt32( grid.DataKeys[e.NewSelectedIndex].Value.ToString());

            hdnId.Value = id.ToString();



            //SDC = new StudentDbDataContext();
            SDC = new TMSMASTEREntities1();

            var singleStudent = SDC.Students.Single(student => student.StudentId == id);

         

            txtName.Text = singleStudent.Name;

            txtAddress.Text = singleStudent.Address;

            txtBirthdate.Text = singleStudent.BirthDate.ToString();

            imgThumb.ImageUrl = "~//images//" + singleStudent.Image;

            imgThumb.Visible = true;

            txtEmail.Text = singleStudent.Email;

            txtMobile.Text = singleStudent.Mobile.ToString();

            txtDescription.Text = singleStudent.Description;



        }



        protected void btnAdd_Click(object sender, EventArgs e)
        {

            try
            {

                //SDC = new StudentDbDataContext();
                SDC = new TMSMASTEREntities1();
                Student student = new Student();



                student.Name = txtName.Text;

                student.Address = txtAddress.Text;

                student.BirthDate = Convert.ToDateTime(txtBirthdate.Text);

                if (fupImage.HasFile)
                {

                    student.Image = fupImage.FileName;

                    string path = Server.MapPath(".") + "\\images\\";

                    fupImage.SaveAs(path + fupImage.FileName);

                }

                student.Email = txtEmail.Text;

                student.Mobile = Convert.ToInt64(txtMobile.Text);

                student.Description = txtDescription.Text;



                //SDC.Students.InsertOnSubmit(student);

                //SDC.SubmitChanges();

                SDC.AddToStudents(student);
              
              
                SDC.SaveChanges();
             

                ClearControls();

                statusLabel.Text = "Record Inserted Successfully.";

            }

            catch (Exception Err)
            {

                statusLabel.Text = Err.Message;

            }



            BindGrid();

        }



        protected void btnReset_Click(object sender, EventArgs e)
        {

            ClearControls();

        }



        protected void btnCancel_Click(object sender, EventArgs e)
        {

            ClearControls();



            btnAdd.Visible = true;

            btnReset.Visible = true;

            btnUpdate.Visible = false;

            btnCancel.Visible = false;

        }



        protected void btnUpdate_Click(object sender, EventArgs e)
        {

            try
            {

                //SDC = new StudentDbDataContext();
                int Id=Convert.ToInt32(hdnId.Value);

                SDC = new TMSMASTEREntities1();

                var singleStudent = SDC.Students.Single(student => student.StudentId == Id);

                string ImageName = singleStudent.Image;

                string path = Server.MapPath(".") + "\\images\\";



                singleStudent.Name = txtName.Text;

                singleStudent.Address = txtAddress.Text;

                singleStudent.BirthDate = Convert.ToDateTime(txtBirthdate.Text);



                if (fupImage.HasFile)
                {

                    if (File.Exists(path + ImageName))

                        File.Delete(path + ImageName);



                    ImageName = fupImage.FileName;



                    fupImage.SaveAs(path + ImageName);



                    singleStudent.Image = ImageName;

                }



                singleStudent.Email = txtEmail.Text;

                singleStudent.Mobile = Convert.ToInt64(txtMobile.Text);

                singleStudent.Description = txtDescription.Text;

                //SDC.SubmitChanges();
           
                SDC.SaveChanges();

                ClearControls();

                statusLabel.Text = "Record Inserted Successfully.";



                btnAdd.Visible = true;

                btnReset.Visible = true;

                btnUpdate.Visible = false;

                btnCancel.Visible = false;

            }

            catch (Exception Err)
            {

                statusLabel.Text = Err.Message;

            }



            BindGrid();

        }



        protected void grid_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {

            int id =Convert.ToInt32( grid.DataKeys[e.RowIndex].Value.ToString());



            //StudentDbDataContext SDC = new StudentDbDataContext();
            TMSMASTEREntities1 SDC = new TMSMASTEREntities1();

            var singleStudent = SDC.Students.Single(student => student.StudentId == id);



            string path = Server.MapPath(".") + "\\images\\";

            if (File.Exists(path + singleStudent.Image))
            {

                File.Delete(path + singleStudent.Image);

            }



            //SDC.Students.DeleteOnSubmit(singleStudent);

            //SDC.SubmitChanges();

            SDC.DeleteObject(singleStudent);

            SDC.SaveChanges();

            BindGrid();

        }



        private void ClearControls()
        {

            txtName.Text = string.Empty;

            txtAddress.Text = string.Empty;

            txtEmail.Text = string.Empty;

            txtMobile.Text = string.Empty;

            txtDescription.Text = string.Empty;

            txtBirthdate.Text = string.Empty;

            imgThumb.Visible = false;

        }

        public void checkMax()
        {
            int? maxEmpID = SDC.Students.Max(q => (int?)q.StudentId) ;

            int? ID = (from n in SDC.Students
                         where n.Name == "fgh"
                      select (int?)n.StudentId).Max<int?>();

            if (maxEmpID != null)
            {
                maxEmpID = maxEmpID + 1;
                hdnId.Value = maxEmpID.ToString();
            }
            else
            {
                maxEmpID = 1000;
                hdnId.Value = maxEmpID.ToString();
            }
        }

        public void bindDDL()
        {
            var display = from e in SDC.Students select new { e.StudentId };

            ddlStudentID.DataSource = display.ToList();
            ddlStudentID.DataTextField = "StudentId";
            ddlStudentID.DataValueField = "StudentId";
            ddlStudentID.DataBind();
            ddlStudentID.Items.Insert(0, "--Select--");

        
        }

        protected void calBirthdate_SelectionChanged(object sender, EventArgs e)
        {

            txtBirthdate.Text = calBirthdate.SelectedDate.ToShortDateString();

        }

        protected void ddlStudentID_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddlStudentID.SelectedItem.Text != "--Select--")
            {

                int id = Convert.ToInt16(ddlStudentID.SelectedValue.ToString());

                var display = from student in SDC.Students

                              where student.StudentId.Equals(id)

                              select new
                              {
                                  student.StudentId,
                                  student.Name,
                                  student.Address,
                                  student.BirthDate,
                                  student.Image,
                                  student.Email,
                                  student.Mobile,
                                  student.Description
                              };



                foreach (var v in display)
                {

                    txtName.Text = v.Name;

                    txtAddress.Text = v.Address;

                    txtBirthdate.Text = v.BirthDate.ToString();

                    imgThumb.ImageUrl = "~//images//" + v.Image;

                    imgThumb.Visible = true;

                    txtEmail.Text = v.Email;

                    txtMobile.Text = v.Mobile.ToString();

                    txtDescription.Text = v.Description;

                }

            }
        }
    }
}
- No comments:

Wednesday, March 13, 2013

XML code for Grouping in SSRS Reports

<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">
  <DataSources>
    <DataSource Name="global">
      <ConnectionProperties>
        <DataProvider>System.Data.DataSet</DataProvider>
        <ConnectString>/* Local Connection */</ConnectString>
      </ConnectionProperties>
      <rd:DataSourceID>760a313d-7bf2-4ccc-a32e-ad6c4d5b93c1</rd:DataSourceID>
    </DataSource>
  </DataSources>
  <DataSets>
    <DataSet Name="DataSet">
      <Fields>
        <Field Name="locName">
          <DataField>locName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="locCode">
          <DataField>locCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrProjectText">
          <DataField>asrProjectText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrReuseCondText">
          <DataField>asrReuseCondText</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="ADM_DEPT_MST">
          <DataField>ADM_DEPT_MST</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ADM_DEPT_MSTReference">
          <DataField>ADM_DEPT_MSTReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AdmLocationMst">
          <DataField>AdmLocationMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AdmLocationMstReference">
          <DataField>AdmLocationMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntCostDtls">
          <DataField>AsmMntCostDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntDues">
          <DataField>AsmMntDues</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntInwardMpgs">
          <DataField>AsmMntInwardMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntInwardTrxes">
          <DataField>AsmMntInwardTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntOutwardMpgs">
          <DataField>AsmMntOutwardMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntOutwardTrxes">
          <DataField>AsmMntOutwardTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntScheduleDtls">
          <DataField>AsmMntScheduleDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsmMntTrxes">
          <DataField>AsmMntTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentMpgs">
          <DataField>AsoIncidentMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentMpgs1">
          <DataField>AsoIncidentMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoIncidentTrxes">
          <DataField>AsoIncidentTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfInwardNoteMpgs">
          <DataField>AsoTrfInwardNoteMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfInwardNoteMpgs1">
          <DataField>AsoTrfInwardNoteMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleAssetMpgs">
          <DataField>AsoTrfScheduleAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleAssetMpgs1">
          <DataField>AsoTrfScheduleAssetMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsoTrfScheduleHdrs">
          <DataField>AsoTrfScheduleHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetActivityHdrs">
          <DataField>AsrAssetActivityHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetActivityResourceDtls">
          <DataField>AsrAssetActivityResourceDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetAssociationDtls">
          <DataField>AsrAssetAssociationDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetClassMst">
          <DataField>AsrAssetClassMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetClassMstReference">
          <DataField>AsrAssetClassMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetKbDtls">
          <DataField>AsrAssetKbDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMiscInfs">
          <DataField>AsrAssetMiscInfs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMntHdrs">
          <DataField>AsrAssetMntHdrs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMntResourceDtls">
          <DataField>AsrAssetMntResourceDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetMsts">
          <DataField>AsrAssetMsts</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetSovDtls">
          <DataField>AsrAssetSovDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetStatutoryDtls">
          <DataField>AsrAssetStatutoryDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetTypeMst">
          <DataField>AsrAssetTypeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetTypeMstReference">
          <DataField>AsrAssetTypeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AsrAssetWarrantyDtls">
          <DataField>AsrAssetWarrantyDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssAsnActivityAssetDtls">
          <DataField>AssAsnActivityAssetDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssAsnActivityAssetMpgs">
          <DataField>AssAsnActivityAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipAssetMpgs">
          <DataField>AssDslDutySlipAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipAssetMpgs1">
          <DataField>AssDslDutySlipAssetMpgs1</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssDslDutySlipTrxes">
          <DataField>AssDslDutySlipTrxes</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssSchActivityAssetDtls">
          <DataField>AssSchActivityAssetDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="AssSchActivityAssetMpgs">
          <DataField>AssSchActivityAssetMpgs</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="CustodyEmpEmployeeMst">
          <DataField>CustodyEmpEmployeeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="CustodyEmpEmployeeMstReference">
          <DataField>CustodyEmpEmployeeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="DealerVndVendorMst">
          <DataField>DealerVndVendorMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="DealerVndVendorMstReference">
          <DataField>DealerVndVendorMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="MakeVndVendorMst">
          <DataField>MakeVndVendorMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="MakeVndVendorMstReference">
          <DataField>MakeVndVendorMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="OwnerEmpEmployeeMst">
          <DataField>OwnerEmpEmployeeMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="OwnerEmpEmployeeMstReference">
          <DataField>OwnerEmpEmployeeMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetAssociationDtls">
          <DataField>ParentAsrAssetAssociationDtls</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetMst">
          <DataField>ParentAsrAssetMst</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="ParentAsrAssetMstReference">
          <DataField>ParentAsrAssetMstReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="PrjProjectInf">
          <DataField>PrjProjectInf</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="PrjProjectInfReference">
          <DataField>PrjProjectInfReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="VndVendorModelDtl">
          <DataField>VndVendorModelDtl</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="VndVendorModelDtlReference">
          <DataField>VndVendorModelDtlReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacConReuse">
          <DataField>XacConReuse</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacConReuseReference">
          <DataField>XacConReuseReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacCtgAsset">
          <DataField>XacCtgAsset</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacCtgAssetReference">
          <DataField>XacCtgAssetReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacSttMaintenance">
          <DataField>XacSttMaintenance</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="XacSttMaintenanceReference">
          <DataField>XacSttMaintenanceReference</DataField>
          <rd:TypeName />
        </Field>
        <Field Name="asrActive">
          <DataField>asrActive</DataField>
          <rd:TypeName>System.Byte</rd:TypeName>
        </Field>
        <Field Name="asrBizUnit">
          <DataField>asrBizUnit</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrCategory">
          <DataField>asrCategory</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrClass">
          <DataField>asrClass</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrCode">
          <DataField>asrCode</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrCrtdBy">
          <DataField>asrCrtdBy</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrCrtdOn">
          <DataField>asrCrtdOn</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="asrCustody">
          <DataField>asrCustody</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDFld1">
          <DataField>asrDFld1</DataField>
          <rd:TypeName>System.Nullable`1[[System.DateTime, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDealer">
          <DataField>asrDealer</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDept">
          <DataField>asrDept</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrDesc">
          <DataField>asrDesc</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrImage">
          <DataField>asrImage</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrLocation">
          <DataField>asrLocation</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMake">
          <DataField>asrMake</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMandatory">
          <DataField>asrMandatory</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrMntCond">
          <DataField>asrMntCond</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrModBy">
          <DataField>asrModBy</DataField>
          <rd:TypeName>System.Int16</rd:TypeName>
        </Field>
        <Field Name="asrModOn">
          <DataField>asrModOn</DataField>
          <rd:TypeName>System.DateTime</rd:TypeName>
        </Field>
        <Field Name="asrModel">
          <DataField>asrModel</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrNFld1">
          <DataField>asrNFld1</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrNFld2">
          <DataField>asrNFld2</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrName">
          <DataField>asrName</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrOwner">
          <DataField>asrOwner</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrPK">
          <DataField>asrPK</DataField>
          <rd:TypeName>System.Int32</rd:TypeName>
        </Field>
        <Field Name="asrParent">
          <DataField>asrParent</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrPartNo">
          <DataField>asrPartNo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrProject">
          <DataField>asrProject</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrRegnNo">
          <DataField>asrRegnNo</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrRemarks">
          <DataField>asrRemarks</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrReuseCond">
          <DataField>asrReuseCond</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrStatus">
          <DataField>asrStatus</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrTFld1">
          <DataField>asrTFld1</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrTFld2">
          <DataField>asrTFld2</DataField>
          <rd:TypeName>System.String</rd:TypeName>
        </Field>
        <Field Name="asrType">
          <DataField>asrType</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrYear">
          <DataField>asrYear</DataField>
          <rd:TypeName>System.Nullable`1[[System.Int16, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="asrxFlag">
          <DataField>asrxFlag</DataField>
          <rd:TypeName>System.Nullable`1[[System.Byte, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]</rd:TypeName>
        </Field>
        <Field Name="EntityKey">
          <DataField>EntityKey</DataField>
          <rd:TypeName>System.Data.EntityKey</rd:TypeName>
        </Field>
        <Field Name="ExtensionData">
          <DataField>ExtensionData</DataField>
          <rd:TypeName>System.Runtime.Serialization.ExtensionDataObject</rd:TypeName>
        </Field>
      </Fields>
      <Query>
        <DataSourceName>global</DataSourceName>
        <CommandText>/* Local Query */</CommandText>
      </Query>
      <rd:DataSetInfo>
        <rd:DataSetName>global</rd:DataSetName>
      </rd:DataSetInfo>
    </DataSet>
  </DataSets>
  <Body>
    <ReportItems>
      <Tablix Name="Tablix2">
        <TablixBody>
          <TablixColumns>
            <TablixColumn>
              <Width>1.25048in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>2.00049in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.61384in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.67756in</Width>
            </TablixColumn>
            <TablixColumn>
              <Width>1.55258in</Width>
            </TablixColumn>
          </TablixColumns>
          <TablixRows>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox1">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location Name</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#dee3ed</BackgroundColor>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox6">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location Code</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox6</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#dee3ed</BackgroundColor>
                      </Style>
                    </Textbox>
                    <ColSpan>3</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="LocationMaster">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                      </Style>
                    </Textbox>
                    <ColSpan>2</ColSpan>
                    <rd:Selected>true</rd:Selected>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell>
                  <CellContents>
                    <Textbox Name="locationCode">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locCode.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                      </Style>
                    </Textbox>
                    <ColSpan>3</ColSpan>
                  </CellContents>
                </TablixCell>
                <TablixCell />
                <TablixCell />
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.25in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox11">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Code</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox17">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Name</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox18">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Location</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox19">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Project</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox20">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>Condition</Value>
                              <Style>
                                <FontFamily>Verdana</FontFamily>
                                <FontWeight>Bold</FontWeight>
                                <Color>#506c92</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox1</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>LightGrey</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#eef3fb</BackgroundColor>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
            <TablixRow>
              <Height>0.27083in</Height>
              <TablixCells>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="asrCode2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrCode.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>asrCode</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="Textbox21">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>Textbox4</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="AdmLocationMst2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!locName.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>AdmLocationMst</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="PrjProjectInf2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=IIf(IsNothing(Fields!asrProjectText.Value), "Idle Project",Fields!asrProjectText.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>PrjProjectInf</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
                <TablixCell>
                  <CellContents>
                    <Textbox Name="XacConReuse2">
                      <CanGrow>true</CanGrow>
                      <KeepTogether>true</KeepTogether>
                      <Paragraphs>
                        <Paragraph>
                          <TextRuns>
                            <TextRun>
                              <Value>=Code.HTMLDecode(Fields!asrReuseCondText.Value)</Value>
                              <Style>
                                <FontStyle>Normal</FontStyle>
                                <FontFamily>Verdana</FontFamily>
                                <FontSize>9pt</FontSize>
                                <FontWeight>Normal</FontWeight>
                                <Color>#263d62</Color>
                              </Style>
                            </TextRun>
                          </TextRuns>
                          <Style />
                        </Paragraph>
                      </Paragraphs>
                      <rd:DefaultName>XacConReuse</rd:DefaultName>
                      <Style>
                        <Border>
                          <Color>#c6d3e7</Color>
                          <Style>Solid</Style>
                        </Border>
                        <BackgroundColor>#ffffff</BackgroundColor>
                        <PaddingLeft>2pt</PaddingLeft>
                        <PaddingRight>2pt</PaddingRight>
                        <PaddingTop>2pt</PaddingTop>
                        <PaddingBottom>2pt</PaddingBottom>
                      </Style>
                    </Textbox>
                  </CellContents>
                </TablixCell>
              </TablixCells>
            </TablixRow>
          </TablixRows>
        </TablixBody>
        <TablixColumnHierarchy>
          <TablixMembers>
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
            <TablixMember />
          </TablixMembers>
        </TablixColumnHierarchy>
        <TablixRowHierarchy>
          <TablixMembers>
            <TablixMember>
              <KeepWithGroup>After</KeepWithGroup>
            </TablixMember>
            <TablixMember>
              <Group Name="Group2">
                <GroupExpressions>
                  <GroupExpression>=Fields!asrLocation.Value</GroupExpression>
                </GroupExpressions>
              </Group>
              <SortExpressions>
                <SortExpression>
                  <Value>=Fields!asrType.Value</Value>
                </SortExpression>
              </SortExpressions>
              <TablixMembers>
                <TablixMember>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Visibility>
                    <Hidden>true</Hidden>
                    <ToggleItem>LocationMaster</ToggleItem>
                  </Visibility>
                  <KeepWithGroup>After</KeepWithGroup>
                </TablixMember>
                <TablixMember>
                  <Group Name="Details1" />
                  <Visibility>
                    <Hidden>true</Hidden>
                    <ToggleItem>LocationMaster</ToggleItem>
                  </Visibility>
                </TablixMember>
              </TablixMembers>
            </TablixMember>
          </TablixMembers>
        </TablixRowHierarchy>
        <DataSetName>DataSet</DataSetName>
        <Left>0.00001in</Left>
        <Height>1.02083in</Height>
        <Width>8.09495in</Width>
        <Style>
          <Border>
            <Style>None</Style>
          </Border>
        </Style>
      </Tablix>
    </ReportItems>
    <Height>1.04167in</Height>
    <Style />
  </Body>
  <ReportParameters>
    <ReportParameter Name="HeaderImage">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
    <ReportParameter Name="FromDate">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
    <ReportParameter Name="ToDate">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <AllowBlank>true</AllowBlank>
      <Prompt>ReportParameter1</Prompt>
    </ReportParameter>
  </ReportParameters>
  <Code>Function HTMLDecode(byVal EncodedString) As String
  Dim DecodedString, i
  DecodedString = EncodedString
  DecodedString = Replace(DecodedString, "&amp;quot;", chr(34) )
  DecodedString = Replace(DecodedString, "&amp;lt;"  , chr(60) )
  DecodedString = Replace(DecodedString, "&amp;gt;"  , chr(62) )
  DecodedString = Replace(DecodedString, "&amp;amp;" , chr(38) )
  DecodedString = Replace(DecodedString, "&amp;nbsp;", chr(32) )
  For i = 1 to 255
    DecodedString = Replace(DecodedString, "&amp;#" &amp; i &amp; ";", chr( i ) )
  Next
  Return DecodedString
End Function</Code>
  <Width>8.09497in</Width>
  <Page>
    <PageHeader>
      <Height>1.157in</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Image Name="Image3">
          <Source>External</Source>
          <Value>=Parameters!HeaderImage.Value</Value>
          <MIMEType>image/png</MIMEType>
          <Left>0.11082in</Left>
          <Height>1.157in</Height>
          <Width>2.597in</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
          </Style>
        </Image>
        <Textbox Name="Textbox3">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>Asset By Locations</Value>
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>18pt</FontSize>
                    <FontWeight>Bold</FontWeight>
                  </Style>
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Center</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox3</rd:DefaultName>
          <Top>0.49517in</Top>
          <Left>2.93207in</Left>
          <Height>0.35416in</Height>
          <Width>3.80208in</Width>
          <ZIndex>1</ZIndex>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageHeader>
    <PageFooter>
      <Height>0.29167in</Height>
      <PrintOnFirstPage>true</PrintOnFirstPage>
      <PrintOnLastPage>true</PrintOnLastPage>
      <ReportItems>
        <Textbox Name="Textbox2">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>Generated Through : Grand Trust</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Left</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox1</rd:DefaultName>
          <Top>0.01041in</Top>
          <Height>0.20139in</Height>
          <Width>3.06764in</Width>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
          </Style>
        </Textbox>
        <Textbox Name="Textbox5">
          <CanGrow>true</CanGrow>
          <KeepTogether>true</KeepTogether>
          <Paragraphs>
            <Paragraph>
              <TextRuns>
                <TextRun>
                  <Value>="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()</Value>
                  <Style />
                </TextRun>
              </TextRuns>
              <Style>
                <TextAlign>Right</TextAlign>
              </Style>
            </Paragraph>
          </Paragraphs>
          <rd:DefaultName>Textbox2</rd:DefaultName>
          <Top>0.01041in</Top>
          <Left>6.13542in</Left>
          <Height>0.22917in</Height>
          <Width>1.95955in</Width>
          <ZIndex>1</ZIndex>
          <Style>
            <Border>
              <Style>None</Style>
            </Border>
            <PaddingLeft>2pt</PaddingLeft>
            <PaddingRight>2pt</PaddingRight>
            <PaddingTop>2pt</PaddingTop>
            <PaddingBottom>2pt</PaddingBottom>
          </Style>
        </Textbox>
      </ReportItems>
      <Style>
        <Border>
          <Style>None</Style>
        </Border>
      </Style>
    </PageFooter>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <rd:ReportID>c1519f46-fed8-4b94-8026-7a2a2af605de</rd:ReportID>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>
- No comments:
Subscribe to: Posts (Atom)

Using Authorization with Swagger in ASP.NET Core

 Create Solution like below LoginModel.cs using System.ComponentModel.DataAnnotations; namespace UsingAuthorizationWithSwagger.Models {     ...