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