protected void BindContract()
{
int contractid = Convert.ToInt16(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract!=null )
{
lblContractName.Text = objContract.Contractname;
lblContractId.Text = objContract.Contractid.ToString();
lblActiveFrom.Text = objContract.Activefrom.ToString();
lblActiveTo.Text = objContract.Activeto.ToString();
objVendor = objVendor.Get_By_id(objContract.Vendorid);
lblVendorname.Text = objVendor.Vendorname.ToString();
lblDesc.Text = objContract.Description.ToString();
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
grdvwViewAsset.DataSource = colAsset;
grdvwViewAsset.DataBind();
}
objConRenewed = objConRenewed.Get_By_id(contractid);
if (objConRenewed.Contractid!=0)
{
lblRen.Visible = true;
Contract_mst obj = new Contract_mst();
obj = obj.Get_By_id(objConRenewed.Contractid);
lblRenInfo.Text = obj.Contractname;
lblRenInfo.Visible = true;
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid != 0)
{
lblUsers.Text = objContractNotfy.Sentto;
lblDays.Text = Convert.ToString(objContractNotfy.Beforedays);
}
else
{
lblUsers.Text = "-";
lblDays.Text = "-";
}
}
protected void BindContract()
{
int contractid = Convert.ToInt16(Request.QueryString[0]);
objContract = objContract.Get_By_id(contractid);
if (objContract != null)
{
lblContractName.Text = objContract.Contractname;
lblContractId.Text = objContract.Contractid.ToString();
lblActiveFrom.Text = objContract.Activefrom.ToString();
lblActiveTo.Text = objContract.Activeto.ToString();
objVendor = objVendor.Get_By_id(objContract.Vendorid);
lblVendorname.Text = objVendor.Vendorname.ToString();
lblDesc.Text = objContract.Description.ToString();
colContractToAssetMapping = objContractToAsset.Get_All_By_contractid(objContract.Contractid);
foreach (ContractToAssetMapping obj in colContractToAssetMapping)
{
Asset_mst objA = new Asset_mst();
objA = objA.Get_By_id(obj.Assetid);
colAsset.Add(objA);
}
grdvwViewAsset.DataSource = colAsset;
grdvwViewAsset.DataBind();
}
objConRenewed = objConRenewed.Get_By_id(contractid);
if (objConRenewed.Contractid != 0)
{
lblRen.Visible = true;
Contract_mst obj = new Contract_mst();
obj = obj.Get_By_id(objConRenewed.Contractid);
lblRenInfo.Text = obj.Contractname;
lblRenInfo.Visible = true;
}
objContractNotfy = objContractNotfy.Get_By_id(contractid);
if (objContractNotfy.Contractid != 0)
{
lblUsers.Text = objContractNotfy.Sentto;
lblDays.Text = Convert.ToString(objContractNotfy.Beforedays);
}
else
{
lblUsers.Text = "-";
lblDays.Text = "-";
}
}
public int Update_ContractRenewed_By_id(ContractRenewed objContractRenewed)
{
return (int)ExecuteNonQuery(sp_ContractRenewed_Update, new object[] { objContractRenewed.Renewedcontractid, objContractRenewed.Contractid });
}
public int Insert_ContractRenewed(ContractRenewed objContractRenewed)
{
return (int)ExecuteNonQuery(sp_ContractRenewed_Insert, new object[] { objContractRenewed.Renewedcontractid, objContractRenewed.Contractid });
}
public object GenerateContractRenewedObject(ref IDataReader returnData)
{
ContractRenewed obj = new ContractRenewed();
while (returnData.Read())
{
obj.Contractid = (int)returnData["Contractid"];
obj.Renewedcontractid = (int)returnData["Renewedcontractid"];
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Reneweddate"];
obj.Reneweddate = Mydatetime.ToString();
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateContractRenewedCollection(ref IDataReader returnData)
{
BLLCollection<ContractRenewed> col = new BLLCollection<ContractRenewed>();
while (returnData.Read())
{
ContractRenewed obj = new ContractRenewed();
obj.Contractid = (int)returnData["Contractid"];
obj.Renewedcontractid = (int)returnData["Renewedcontractid"];
DateTime Mydatetime = new DateTime();
Mydatetime = (DateTime)returnData["Reneweddate"];
obj.Reneweddate = Mydatetime.ToString();
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}