public Object GetRecord(String BillID) { BillLayoutMaster bill = new BillLayoutMaster(); try { bill = DAL.DALBILLClass.GetBillHeader(BillID); } catch (Exception ex) { throw; } return bill; }
public static BillLayoutMaster GetBillHeader(String BillNo) { BillLayoutMaster bill = new BillLayoutMaster(); try { using (var context = new SycousCon()) { try { var parBillNo = new SqlParameter { ParameterName = "BillNo", Value = BillNo, Direction = ParameterDirection.Input }; bill = context.ExecuteStoreQuery<BillLayoutMaster>("exec SYCOUS.GetBillHeaderInfo @BillNo", parBillNo).FirstOrDefault(); } catch (Exception ex) { context.Dispose(); throw; } }// using } catch (Exception ex) { throw; } return bill; }