public static List <ActionEventModel> GetDataSyncActionEventDiaryDetails() { try { string strEventDiaryDetails = SQLiteDatabase.Instance.GetDataSyncActionDetails() [0].Data.ToDecrypt(); DataSyncActionDetailsModel dataSyncActionDetailsModel = JsonConvert.DeserializeObject <DataSyncActionDetailsModel> (strEventDiaryDetails); List <ActionEventModel> listActionEventDiary = null; listActionEventDiary = (from ActionEventDairy in dataSyncActionDetailsModel.ActionEventDiaryDetails where ActionEventDairy.EventID.ToString() == GlobalVariables.RemarkID select ActionEventDairy).ToList(); foreach (ActionEventUpdate actionEventUpdate in SQLiteDatabase.Instance.DataSyncGetActionEvent(GlobalVariables.RemarkID)) { int EventId = actionEventUpdate.EventID; ActionEventModel AEU = listActionEventDiary.Where(item => item.EventID == EventId).ToList() [0]; AEU.Status = actionEventUpdate.Status.ToString(); AEU.CommencementDate = actionEventUpdate.CommencementDt; AEU.CommenceComment = actionEventUpdate.CommencementRemark; AEU.ClosureDate = actionEventUpdate.ClosureDt; AEU.ClosureComment = actionEventUpdate.ClosureRemark; } return(listActionEventDiary); } catch { return(null); } }
public static List <ActionEventDiaryListModel> GetDataSyncActionEventDiaryList(string CustomerEntityID, string AccountEntityID) { try { string strActionDetails = SQLiteDatabase.Instance.GetDataSyncActionDetails() [0].Data.ToDecrypt(); DataSyncActionDetailsModel dataSyncActionDetailsModel = JsonConvert.DeserializeObject <DataSyncActionDetailsModel> (strActionDetails); List <ActionEventDiaryListModel> listActionEventDiary = null; if (!(string.IsNullOrEmpty(AccountEntityID) || AccountEntityID == "0")) { listActionEventDiary = (from ActionEvent in dataSyncActionDetailsModel.GetActionEventDiaryList where ActionEvent.CustomerEntityID == CustomerEntityID && ActionEvent.TableName == "GetActionEventDiaryList" && ActionEvent.AccountEntityID == AccountEntityID select ActionEvent).ToList(); } listActionEventDiary = (from ActionEvent in dataSyncActionDetailsModel.GetActionEventDiaryList where ActionEvent.CustomerEntityID == CustomerEntityID && ActionEvent.TableName == "GetActionEventDiaryList" select ActionEvent).ToList(); foreach (ActionEventUpdate actionEventUpdate in SQLiteDatabase.Instance.DataSyncGetActionEventList()) { string EventId = actionEventUpdate.EventID.ToString(); string Status = string.Empty; if (actionEventUpdate.Status == 20) { Status = "Allotted"; } else if (actionEventUpdate.Status == 30) { Status = "In Process"; } else if (actionEventUpdate.Status == 10) { Status = "Done"; } listActionEventDiary.Where(item => item.EventID == EventId).ToList() [0].Status = Status; } return(listActionEventDiary); } catch { return(null); } }