private void fillVendor()
        {
            clsObject.companyId = Session["companyid"].ToString();
            clsObject.action    = "selectVendor";
            ds = clsObject.ManageAsset();
            drop_vendorName.DataSource     = ds;
            drop_vendorName.DataTextField  = "VenderName";
            drop_vendorName.DataValueField = "nid";
            drop_vendorName.DataBind();

            ListItem li = new ListItem("--Select--", "");

            drop_vendorName.Items.Insert(0, li);
            drop_vendorName.SelectedIndex = 0;
        }
        public static string getAllAsset(string prefixText, string companyid)
        {
            Cls_Asset     objts  = new Cls_Asset();
            DataSet       ds1    = new DataSet();
            GeneralMethod objgen = new GeneralMethod();

            objts.name      = "";
            objts.action    = "selectforautocompleter";
            objts.companyId = companyid;
            objts.nid       = "";
            ds1             = objts.ManageAsset();
            string result = objgen.serilizeinJson(ds1.Tables[0]);

            return(result);
        }
Exemple #3
0
        public static string getAssetDetail(string nid)
        {
            StringBuilder sb = new StringBuilder();

            Cls_Asset objts = new Cls_Asset();
            DataSet   ds    = new DataSet();

            objts.action = "select";
            objts.nid    = nid;
            ds           = objts.ManageAsset();

            if (ds.Tables[0].Rows.Count > 0)
            {
                sb.Append(ds.Tables[0].Rows[0]["assetname"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["assetCode"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["categoryname"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["Location"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["transferedon"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["transferid"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["transferDate"].ToString() + "###");
            }
            return(sb.ToString());
        }
        public static string getAllAssetData(string nid)
        {
            StringBuilder sb = new StringBuilder();

            assetId = nid;
            Cls_Asset objts = new Cls_Asset();
            DataSet   ds    = new DataSet();

            objts.action = "select";
            objts.nid    = nid;
            ds           = objts.ManageAsset();

            if (ds.Tables[0].Rows.Count > 0)
            {
                currentLocation = ds.Tables[0].Rows[0]["currentLocation"].ToString();
                sb.Append(ds.Tables[0].Rows[0]["assetname"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["assetCode"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["categoryname"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["currentLocation"].ToString() + "###");
                sb.Append(ds.Tables[0].Rows[0]["creationdate"].ToString() + "###");
            }
            return(sb.ToString());
        }
        public void fillVendor()
        {
            objAsset.companyId = Session["companyid"].ToString();
            objAsset.action    = "selectVendor";
            ds = objAsset.ManageAsset();
            dropvendor.DataSource     = ds;
            dropvendor.DataTextField  = "VenderName";
            dropvendor.DataValueField = "nid";
            dropvendor.DataBind();

            DropRepairvndr.DataSource     = ds;
            DropRepairvndr.DataTextField  = "VenderName";
            DropRepairvndr.DataValueField = "nid";
            DropRepairvndr.DataBind();

            ListItem li = new ListItem("--Select--", "");

            dropvendor.Items.Insert(0, li);
            dropvendor.SelectedIndex = 0;

            ListItem li1 = new ListItem("--Select Vendor--", "");

            DropRepairvndr.Items.Insert(0, li1);
            DropRepairvndr.SelectedIndex = 0;
        }