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