public int Update(TExpenseItem model) { TravelExpence TE = DbContext.TravelExpences.SingleOrDefault(m => m.Id == model.Id); TE.Companyid = model.Companyid; TE.EmpId = model.EmpId; TE.TDate = model.TDate; TE.Country = model.Country; TE.TFromDate = model.TFromDate; TE.TToDate = model.TToDate; TE.Fare = model.Fare; TE.FromDate = model.FromDate; TE.ToDate = model.ToDate; TE.City = model.City; TE.Id = model.Id; TE.AccomodationExp = model.AccomodationExp; TE.FoodExp = model.FoodExp; TE.OtherExp = model.OtherExp; TE.Remarks = model.Remarks; TE.Conv_Exp = model.Conv_Exp; TE.Status = model.Status; TE.UpdatedBy = model.UpdatedBy; TE.UpdatedDate = model.UpdatedDate; return(DbContext.SaveChanges()); }
public TExpenseItem GetById(int id) { Mapper.CreateMap <TravelExpence, TExpenseItem>(); TravelExpence objTExp = DbContext.TravelExpences.SingleOrDefault(m => m.Id == id); TExpenseItem objTExpItem = Mapper.Map <TExpenseItem>(objTExp); return(objTExpItem); }
public int Insert(TExpenseItem model) { try { TravelExpence TE = new TravelExpence(); TE.Companyid = model.Companyid; TE.EmpId = model.EmpId; TE.TDate = model.TDate; TE.Country = model.Country; TE.TFromDate = model.TFromDate; TE.TToDate = model.TToDate; TE.Fare = model.Fare; TE.FromDate = model.FromDate; TE.ToDate = model.ToDate; TE.City = model.City; TE.Id = model.Id; TE.AccomodationExp = model.AccomodationExp; TE.FoodExp = model.FoodExp; TE.OtherExp = model.OtherExp; TE.Conv_Exp = model.Conv_Exp; TE.Remarks = model.Remarks; TE.Status = model.Status; TE.CreatedBy = model.CreatedBy; TE.CreatedDate = model.CreatedDate; DbContext.TravelExpences.Add(TE); return(DbContext.SaveChanges()); //Mapper.CreateMap<TExpenseItem, TravelExpence>(); //TravelExpence objTExp = Mapper.Map<TravelExpence>(model); //DbContext.TravelExpences.Add(objTExp); //return DbContext.SaveChanges(); } catch (Exception ex) { throw; } }