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