protected void BindListBox() { int contractid = Convert.ToInt32(Request.QueryString[0]); Asset_mst ObjAsset = new Asset_mst(); BLLCollection <Asset_mst> col = new BLLCollection <Asset_mst>(); string varAsset = Session["AssetContract"].ToString(); string[] arrAsset = varAsset.Split(','); int FlagCount = arrAsset.Length; for (int i = 0; i < FlagCount; i++) { if (arrAsset[i] != "," && arrAsset[i] != "") { ContractToAssetMapping objCoAsset = new ContractToAssetMapping(); ListItem item = new ListItem(); int flagcount; Asset_mst obj = new Asset_mst(); obj = ObjAsset.Get_By_id(Convert.ToInt32(arrAsset[i].ToString())); flagcount = objCoAsset.Get_by_Contractid_Assetid(contractid, Convert.ToInt32(arrAsset[i].ToString())); if (flagcount == 0) { item.Text = obj.Computername; item.Value = Convert.ToString(obj.Assetid); ListAsset.Items.Add(item); } } } }
protected void BindListBox() { int contractid = Convert.ToInt32(Request.QueryString[0]); Asset_mst ObjAsset = new Asset_mst(); BLLCollection<Asset_mst> col = new BLLCollection<Asset_mst>(); string varAsset = Session["AssetContract"].ToString(); string[] arrAsset = varAsset.Split(','); int FlagCount = arrAsset.Length; for (int i = 0; i < FlagCount; i++) { if (arrAsset[i] != "," && arrAsset[i] != "") { ContractToAssetMapping objCoAsset = new ContractToAssetMapping(); ListItem item = new ListItem(); int flagcount; Asset_mst obj = new Asset_mst(); obj = ObjAsset.Get_By_id(Convert.ToInt32(arrAsset[i].ToString())); flagcount = objCoAsset.Get_by_Contractid_Assetid(contractid, Convert.ToInt32(arrAsset[i].ToString())); if (flagcount == 0) { item.Text = obj.Computername; item.Value = Convert.ToString(obj.Assetid); ListAsset.Items.Add(item); } } } }
public int Update_ContractToAssetMapping_By_id(ContractToAssetMapping objContractToAssetMapping) { return (int)ExecuteNonQuery(sp_ContractToAssetMapping_Update, new object[] { objContractToAssetMapping.Contractid, objContractToAssetMapping.Assetid }); }
public int Insert_ContractToAssetMapping(ContractToAssetMapping objContractToAssetMapping) { return (int)ExecuteNonQuery(sp_ContractToAssetMapping_Insert, new object[] { objContractToAssetMapping.Contractid, objContractToAssetMapping.Assetid }); }
public object GenerateContractToAssetMappingObject(ref IDataReader returnData) { ContractToAssetMapping obj = new ContractToAssetMapping(); while (returnData.Read()) { obj.Contractid = (int)returnData["Contractid"]; obj.Assetid = (int)returnData["Assetid"]; } returnData.Close(); returnData.Dispose(); return obj; }
public CollectionBase GenerateContractToAssetMappingCollection(ref IDataReader returnData) { BLLCollection<ContractToAssetMapping> col = new BLLCollection<ContractToAssetMapping>(); while (returnData.Read()) { ContractToAssetMapping obj = new ContractToAssetMapping(); obj.Contractid = (int)returnData["Contractid"]; obj.Assetid = (int)returnData["Assetid"]; col.Add(obj); } returnData.Close(); returnData.Dispose(); return col; }