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); }
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; }