public void BindGrid()
 {
     DataTable dtTable = new DataTable();
     dtTable = CreateDataTable();
     Asset_mst objAsset = new Asset_mst();
     BLLCollection<Asset_mst> colAsset = new BLLCollection<Asset_mst>();
     colAsset = objAsset.Get_All();
     foreach (Asset_mst obj in colAsset)
     {
         DataRow row;
         row = dtTable.NewRow();
         row["computername"] = Convert.ToString(obj.Computername);
         assetid = Convert.ToInt16(obj.Assetid);
         Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
         objos = objos.Get_By_Assetid(assetid);
         row["osname"] = Convert.ToString(objos.Os_name);
         row["username"] = Convert.ToString(objos.User_name);
         row["productkey"] = Convert.ToString(objos.Product_key);
         Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
         objproduct = objproduct.Get_By_Assetid(assetid);
         row["productname"] = Convert.ToString(objproduct.Product_name);
         row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
         row["serialno"] = Convert.ToString(objproduct.Serial_number);
         Asset_Processor_mst objprocessor = new Asset_Processor_mst();
         objprocessor = objprocessor.Get_By_Assetid(assetid);
         row["processorname"] = Convert.ToString(objprocessor.Processor_name);
         Asset_Memory_mst objmemory = new Asset_Memory_mst();
         objmemory = objmemory.Get_By_Assetid(assetid);
         row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
         dtTable.Rows.Add(row);
     }
     dtgrid.DataSource = dtTable;
     dtgrid.DataBind();
 }
Exemple #2
0
    public void Asset_OS_Info(XmlDocument xmldoc)
    {
        try
        {
            XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
            inventorydate2 = inventory_date.InnerText;

            XmlNode   os_name               = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Name");
            XmlNode   major_version         = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Major_version");
            XmlNode   minor_version         = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Minor_version");
            XmlNode   build_no              = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Build_number");
            XmlNode   add_info              = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Additional_information");
            XmlNode   user_name             = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//User_name");
            XmlNode   reg_to                = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_to");
            XmlNode   reg_org               = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_organization");
            XmlNode   reg_code              = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registration_code");
            XmlNode   localization          = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Locale");
            XmlNode   product_key           = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Product_key");
            Asset_mst objAsset              = new Asset_mst();
            int       varassetid            = objAsset.Get_Current_Assetid();
            Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
            objos.Add_info = add_info.InnerText;
            if (count1 == 0)
            {
                objos.Assetid = varassetid;
            }
            else
            {
                objos.Assetid = Assetid;
            }

            objos.Build_no       = build_no.InnerText;
            objos.Inventory_date = inventorydate2;
            objos.Localization   = localization.InnerText;
            objos.Major_version  = major_version.InnerText;
            objos.Minor_version  = minor_version.InnerText;
            objos.Os_name        = os_name.InnerText;
            objos.Product_key    = product_key.InnerText;
            objos.Reg_code       = reg_code.InnerText;
            objos.Reg_org        = reg_org.InnerText;
            objos.Reg_to         = reg_to.InnerText;
            objos.User_name      = user_name.InnerText;
            objos.Insert();
        }
        catch (Exception ex)
        {
            ex.ToString();
        }
    }
Exemple #3
0
    public void BindGrid()
    {
        DataTable dtTable = new DataTable();

        dtTable = CreateDataTable();
        Asset_mst objAsset = new Asset_mst();
        BLLCollection <Asset_mst> colAsset = new BLLCollection <Asset_mst>();

        colAsset = objAsset.Get_All();
        foreach (Asset_mst obj in colAsset)
        {
            DataRow row;
            row = dtTable.NewRow();
            row["computername"] = Convert.ToString(obj.Computername);
            assetid             = Convert.ToInt32(obj.Assetid);
            Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
            objos             = objos.Get_By_Assetid(assetid);
            row["osname"]     = Convert.ToString(objos.Os_name);
            row["username"]   = Convert.ToString(objos.User_name);
            row["productkey"] = Convert.ToString(objos.Product_key);
            Asset_ProductInfo_mst objproduct = new Asset_ProductInfo_mst();
            objproduct         = objproduct.Get_By_Assetid(assetid);
            row["productname"] = Convert.ToString(objproduct.Product_name);
            row["productmanu"] = Convert.ToString(objproduct.Product_manufacturer);
            row["serialno"]    = Convert.ToString(objproduct.Serial_number);
            Asset_Processor_mst objprocessor = new Asset_Processor_mst();
            objprocessor         = objprocessor.Get_By_Assetid(assetid);
            row["processorname"] = Convert.ToString(objprocessor.Processor_name);
            Asset_Memory_mst objmemory = new Asset_Memory_mst();
            objmemory             = objmemory.Get_By_Assetid(assetid);
            row["physicalmemory"] = Convert.ToString(objmemory.Physical_mem);
            dtTable.Rows.Add(row);
        }
        dtgrid.DataSource = dtTable;
        dtgrid.DataBind();
    }
    public void Asset_OS_Info(XmlDocument xmldoc)
    {
        try
        {
            XmlNode inventory_date = xmldoc.DocumentElement.SelectSingleNode("//Computer//Created_on");
            inventorydate2 = inventory_date.InnerText;

            XmlNode os_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Name");
            XmlNode major_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Major_version");
            XmlNode minor_version = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Minor_version");
            XmlNode build_no = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Build_number");
            XmlNode add_info = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Additional_information");
            XmlNode user_name = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//User_name");
            XmlNode reg_to = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_to");
            XmlNode reg_org = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registered_organization");
            XmlNode reg_code = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Registration_code");
            XmlNode localization = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Locale");
            XmlNode product_key = xmldoc.DocumentElement.SelectSingleNode("//Computer//General_info//Operating_system//Product_key");
            Asset_mst objAsset = new Asset_mst();
            int varassetid = objAsset.Get_Current_Assetid();
            Asset_OperatingSystem_mst objos = new Asset_OperatingSystem_mst();
            objos.Add_info = add_info.InnerText;
            if (count1 == 0)
            {
                objos.Assetid = varassetid;
            }
            else
            {
                objos.Assetid = Assetid;
            }

            objos.Build_no = build_no.InnerText;
            objos.Inventory_date = inventorydate2;
            objos.Localization = localization.InnerText;
            objos.Major_version = major_version.InnerText;
            objos.Minor_version = minor_version.InnerText;
            objos.Os_name = os_name.InnerText;
            objos.Product_key = product_key.InnerText;
            objos.Reg_code = reg_code.InnerText;
            objos.Reg_org = reg_org.InnerText;
            objos.Reg_to = reg_to.InnerText;
            objos.User_name = user_name.InnerText;
            objos.Insert();
        }
        catch (Exception ex)
        {
            ex.ToString();
        }
    }
 public int Update_Asset_OperatingSystem_mst_By_id(Asset_OperatingSystem_mst objAssetOperatingSystem)
 {
     return (int)ExecuteNonQuery(Sp_Asset_OperatingSystem_Update, new object[] { objAssetOperatingSystem.Add_info, objAssetOperatingSystem.Assetid, objAssetOperatingSystem.Assetoperatingid, objAssetOperatingSystem.Build_no, objAssetOperatingSystem.Install_date, objAssetOperatingSystem.Inventory_date, objAssetOperatingSystem.Localization, objAssetOperatingSystem.Login_date, objAssetOperatingSystem.Major_version, objAssetOperatingSystem.Minor_version, objAssetOperatingSystem.Os_name, objAssetOperatingSystem.Product_key, objAssetOperatingSystem.Reg_code, objAssetOperatingSystem.Reg_org, objAssetOperatingSystem.Reg_to, objAssetOperatingSystem.User_name });
 }
 public object GenerateAssetOperatingSystem_mst_ByAssetidObject(ref IDataReader returnData)
 {
     Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst();
     while (returnData.Read())
     {
         obj.Assetid = (int)returnData["assetid"];
         obj.Assetoperatingid = (int)returnData["assetoperatingid"];
         obj.Add_info = (string)returnData["add_info"];
         obj.Build_no = (string)returnData["build_no"];
         obj.Localization = (string)returnData["localization"];
         obj.Major_version = (string)returnData["major_version"];
         obj.Minor_version = (string)returnData["minor_version"];
         obj.Os_name = (string)returnData["os_name"];
         obj.Product_key = (string)returnData["product_key"];
         obj.Reg_code = (string)returnData["reg_code"];
         obj.Reg_org = (string)returnData["reg_org"];
         obj.Reg_to = (string)returnData["reg_to"];
         obj.User_name = (string)returnData["user_name"];
     }
     returnData.Close();
     returnData.Dispose();
     return obj;
 }
    public object GenerateAssetOperatingSystem_mstObject(ref IDataReader returnData)
    {
        Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst();
        while (returnData.Read())
        {
            obj.Assetid = (int)returnData["assetid"];
            obj.Assetoperatingid = (int)returnData["assetoperatingid"];
            obj.Add_info = (string)returnData["add_info"];
            DateTime inventorydatetime = new DateTime();
            inventorydatetime = (DateTime)returnData["inventorydate"];
            obj.Inventory_date = inventorydatetime.ToString();
            obj.Build_no = (string)returnData["build_no"];
            obj.Localization = (string)returnData["localization"];
            obj.Major_version = (string)returnData["major_version"];
            obj.Minor_version = (string)returnData["minor_version"];
            obj.Os_name = (string)returnData["os_name"];
            obj.Product_key = (string)returnData["product_key"];
            obj.Reg_code = (string)returnData["reg_code"];
            obj.Reg_org = (string)returnData["reg_org"];
            obj.Reg_to = (string)returnData["reg_to"];
            obj.User_name = (string)returnData["user_name"];
            DateTime installdatetime = new DateTime();
            installdatetime = (DateTime)returnData["install_date"];
            obj.Install_date = installdatetime.ToString();
            DateTime logindatetime = new DateTime();
            logindatetime = (DateTime)returnData["login_date"];
            obj.Login_date = logindatetime.ToString();

        }
        returnData.Close();
        returnData.Dispose();
        return obj;
    }
 public CollectionBase GenerateAssetOperatingSystem_mstCollectionUsers(ref IDataReader returnData)
 {
     BLLCollection<Asset_OperatingSystem_mst> col = new BLLCollection<Asset_OperatingSystem_mst>();
     while (returnData.Read())
     {
         Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst();
         if (returnData["user_name"] != "")
         {
             obj.User_name = (string)returnData["user_name"];
         }
         col.Add(obj);
     }
     returnData.Close();
     returnData.Dispose();
     return col;
 }
    public CollectionBase GenerateAssetOperatingSystem_mstCollection(ref IDataReader returnData)
    {
        BLLCollection<Asset_OperatingSystem_mst> col = new BLLCollection<Asset_OperatingSystem_mst>();
        while (returnData.Read())
        {
            Asset_OperatingSystem_mst obj = new Asset_OperatingSystem_mst();

            obj.Assetid = (int)returnData["assetid"];
            obj.Assetoperatingid = (int)returnData["assetoperatingid"];
            obj.Add_info = (string)returnData["add_info"];
            DateTime inventorydatetime = new DateTime();
            inventorydatetime = (DateTime)returnData["inventory_date"];
            obj.Inventory_date = inventorydatetime.ToString();
            obj.Build_no = (string)returnData["build_no"];
            obj.Localization = (string)returnData["localization"];
            obj.Major_version = (string)returnData["major_version"];
            obj.Minor_version = (string)returnData["minor_version"];
            obj.Os_name = (string)returnData["os_name"];
            obj.Product_key = (string)returnData["product_key"];
            obj.Reg_code = (string)returnData["reg_code"];
            obj.Reg_org = (string)returnData["reg_org"];
            obj.Reg_to = (string)returnData["reg_to"];
            obj.User_name = (string)returnData["user_name"];
            DateTime installdatetime = new DateTime();
            if (returnData["install_date"] != DBNull.Value)
            {
                installdatetime = (DateTime)returnData["install_date"];
                obj.Install_date = installdatetime.ToString();
            }

            DateTime logindatetime = new DateTime();
            if (returnData["login_date"] != DBNull.Value)
            {
                logindatetime = (DateTime)returnData["login_date"];
                obj.Login_date = logindatetime.ToString();
            }

            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }