public long GetMaxReportRightsId() { POS_REPORT_RIGHTS entity = new POS_REPORT_RIGHTS(); long id = 0; try { entity = _objEntityModel.POS_REPORT_RIGHTS.OrderByDescending(x => x.REPORT_RIGHTS_ID).FirstOrDefault(); if (entity == null) { id = 1; } else { id = entity.REPORT_RIGHTS_ID + 1; } return(id); } catch (Exception ex) { ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error); throw new DALException(); } }
public int UpdateReportRights(List <POS_REPORT_RIGHTS> lstReportRights, long userId) { int isRowsCreated = 0; try { foreach (var item in lstReportRights) { if (item.Selection == true) { POS_REPORT_RIGHTS entity = new POS_REPORT_RIGHTS(); entity.REPORT_RIGHTS_ID = GetMaxReportRightsId(); entity.REPORT_ID = item.REPORT_ID; entity.USER_ID = userId; entity.ISPOSTED_FLAG = false; entity.CREATEDBY = item.CREATEDBY; entity.CREATEDWHEN = item.CREATEDWHEN; _objEntityModel.POS_REPORT_RIGHTS.Add(entity); isRowsCreated = _objEntityModel.SaveChanges(); } } } catch (Exception ex) { //ExceptionLogger.WriteExceptionInDB(ex, ExceptionLevel.DAL, ExceptionType.Error); throw new DALException(ex.Message.ToString()); } return(isRowsCreated); }