public DataResponse <EntityColumnLookup> InsertReportColumnLookup(EntityColumnLookup entity)
{
var response = new DataResponse <EntityColumnLookup>();
try
{
base.DBInit();
var model = new Database.LookupServiceColumn
{
Text = entity.Text,
ColumnId = entity.ColumnId,
CreatedBy = entity.CreatedBy,
CreatedOn = System.DateTime.UtcNow
};
if (base.DBSave(model) > 0)
{
entity.Id = model.Id;
response.CreateResponse(entity, DataResponseStatus.OK);
}
else
{
response.CreateResponse(DataResponseStatus.InternalServerError);
}
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public DataResponse <EntityColumnLookup> UpdateReportColumnLookup(EntityColumnLookup entity)
{
var response = new DataResponse <EntityColumnLookup>();
try
{
base.DBInit();
var model = DBEntity.LookupServiceColumns.FirstOrDefault(a => a.Id == entity.Id);
model.Text = entity.Text;
model.ColumnId = entity.ColumnId;
model.UpdatedBy = entity.UpdatedBy;
model.UpdatedOn = System.DateTime.UtcNow;
if (base.DBSaveUpdate(model) > 0)
{
return(GetReportColumnLookupById(model.Id));
}
else
{
response.CreateResponse(DataResponseStatus.InternalServerError);
}
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public IHttpActionResult UpdateReportColumnLookup(ReportColumnLookupModel model)
{
var response = new DataResponse <EntityColumnLookup>();
var entityColumnLookup = new EntityColumnLookup();
entityColumnLookup.Id = model.Id;
entityColumnLookup.Text = model.Text;
entityColumnLookup.UpdatedBy = CurrentUserId;
entityColumnLookup.ColumnId = model.ColumnId;
response = repository.UpdateReportColumnLookup(entityColumnLookup);
return(Ok <DataResponse>(response));
}
