internal void PopulateControls(string assno) { using (AccetManagementEntities db = new AccetManagementEntities()) { var assDetails = db.ASSETs.Where(c => c.ASSETNO == assno).ToList(); var assetId = assDetails[0].ASSETTYPEID; var dd = db.ASSETTYPEs.Where(e => e.ASSETTYPEID == assetId).Select(e => e.ASSETTYPE1).ToList(); var loc = assDetails[0].LOCATIONID; var ddLoc = db.LOCATIONs.Where(e => e.LOCATIONID == loc).Select(e => e.LOCATIONNAME).ToList(); var statusId = assDetails[0].STATUSID; var ddsi = db.STATUS.Where(e => e.STATUSID == statusId).Select(e => e.STATUSNAME).ToList(); var cond = assDetails[0].CONDITIONID; var ddCon = db.CONDITIONs.Where(e => e.CONDITIONID == cond).Select(e => e.CONDITIONNAME).ToList(); txtDesription.Text = assDetails[0].DESCRIPTION; cmBAssetType.Text = dd[0].ToString(); cmBLocation.Text = ddLoc[0].ToString(); txtmanu.Text = assDetails[0].MANUFACTURER; txtBrand.Text = assDetails[0].BRAND; txtAssetNumber.Text = assDetails[0].ASSETNO; userControl11.txtserial.Text = assDetails[0].SERIALNUMBER; userControl11.cmBStatus.Text = ddsi[0].ToString(); userControl11.cmBCondition.Text = ddCon[0].ToString(); userControl11.txtcheckedOutto.Text = assDetails[0].EMPNAME.ToString(); userControl11.dueDatepicker.Text = assDetails[0].DUEDATE.ToString(); userControl11.txtNotes.Text = assDetails[0].NOTES; this.Text = "Edit Asset " + assDetails[0].ASSETNO; var er = userControlFinance1.Controls.Find("txtPoNumber", true); var financeTableData = db.FINANCEs.SingleOrDefault(c => c.ASSETNO == assno); if (financeTableData != null) { if (financeTableData.VENDORNO != "") { var vendorId = db.VENDORs.Where(e => e.VENDORNO == financeTableData.VENDORNO).ToList(); userControlFinance1.txtPoNumber.Text = financeTableData.PONO; userControlFinance1.cmdVendor.Text = vendorId[0].VENDORNAME; userControlFinance1.recPeriod.Value = financeTableData.RECOVERYPERIOD; userControlFinance1.txtPurchasePrice.Text = financeTableData.PURCHASEPRICE.ToString(); userControlFinance1.txtScrapValue.Text = financeTableData.SCRAPEVALUE.ToString(); userControlFinance1.txtMarketVlaue.Text = financeTableData.MARKETVALUE.ToString(); userControlFinance1.dtpPurchase.Value = financeTableData.PURCHASEDATE; userControlFinance1.dtpWarranty.Value = financeTableData.WARRANTYEND; userControlFinance1.dtpService.Value = financeTableData.INSERVICEDATE; } } CommonData.SelectedEmpId = assDetails[0].EMPID; //picture string fileName = db.ASSETIMAGEs.Where(f => f.ASSETID == assno).Select(f => f.Filepath).FirstOrDefault(); if (fileName != null && fileName != "") { userControl11.pictureBox1.Image = UserControl1.ResizeImage(Image.FromFile(fileName), this.Width, this.Height); } else { } } }