public static int UpdateRecord(eTblPurchaseHistory eobj) { using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPurchaseHistory obj = (OneFineRate.tblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPurchaseHistory()); db.tblPurchaseHistories.Attach(obj); db.Entry(obj).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } throw; } catch (Exception) { throw; } } }
public static long AddRecordAndGetId(eTblPurchaseHistory eobj) { using (OneFineRateEntities db = new OneFineRateEntities()) { try { OneFineRate.tblPurchaseHistory purchangeHistory = (OneFineRate.tblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(eobj, new OneFineRate.tblPurchaseHistory()); db.tblPurchaseHistories.Add(purchangeHistory); var status = db.SaveChanges(); return(purchangeHistory.iPurchaseId); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } throw; } catch (Exception) { throw; } } }
public static eTblPurchaseHistory GetRecord(int purchaseId) { eTblPurchaseHistory eobj = null; using (OneFineRateEntities db = new OneFineRateEntities()) { var dbobj = db.tblPurchaseHistories.Find(purchaseId); if (dbobj != null) { eobj = (eTblPurchaseHistory)OneFineRateAppUtil.clsUtils.ConvertToObject(dbobj, new eTblPurchaseHistory()); } } return(eobj); }