private JsonCarrier Ac02putStartTime(JsonCarrier data) { var result = ""; var tb01_Id = data.Email0; var tb02_YYYYMMDD = data.StartDateTime.Substring(0, 8); var tb02_Id = data.Email0 + tb02_YYYYMMDD; // なければinsert, あればupdat var recordTb02 = new Tb02DailyRecord_ { Tb02DailyRecord_Id = tb02_Id, Tb02DailyRecord_MMDDYYYY = tb02_YYYYMMDD, Tb02DailyRecord_StartTimeStamp = data.StartDateTime, Tb01Name_Id = tb01_Id }; appDb.Tb02DailyRecord.AddOrUpdate(recordTb02); try { appDb.SaveChanges(); result = "processOK"; } catch (System.SystemException ex) { result = "processNG " + ex.Message; } return(new JsonCarrier { Email0 = tb01_Id, ActionResult = result }); }
private JsonCarrier Ac04getMonthlyData(JsonCarrier data) { var result = ""; var tb01_Id = data.Email0; var tb02_memo = data.MemoColumn; var searchKey = tb02_memo.Substring(2, 6); // 対象の月のレコードを返す try { var recordTb02 = appDb.Tb02DailyRecord .Where(t2 => t2.Tb01Name_Id == tb01_Id) .Where(t2 => t2.Tb02DailyRecord_MMDDYYYY.Substring(0, 2) == tb02_memo.Substring(0, 2)) .Where(t2 => t2.Tb02DailyRecord_MMDDYYYY.Substring(4, 4) == tb02_memo.Substring(4, 4)); var monthlyList = recordTb02.Select(t2 => (t2.Tb02DailyRecord_MMDDYYYY + " " + t2.Tb02DailyRecord_StartTimeStamp + " " + t2.Tb02DailyRecord_EndTimeStamp)).ToArray(); result = "processOK"; return(new JsonCarrier { Email0 = tb01_Id, ActionResult = result, MonthlyList = monthlyList }); } catch (System.SystemException ex) { result = tb01_Id + " processNG " + ex.Message; } return(new JsonCarrier { Email0 = tb01_Id, ActionResult = result }); }
// POST: api/MytimeApi public JsonCarrier Post(JsonCarrier data) { var act = data.ActionType; var res = data; switch (act) { case ConstMytime.AC01_CHK_ID: res = Ac01checkId(data); break; case ConstMytime.AC02_ST_TIME: res = Ac02putStartTime(data); break; case ConstMytime.AC03_END_TIME: res = Ac03putEndTime(data); break; case ConstMytime.AC04_MONTH_DATA: res = Ac04getMonthlyData(data); break; default: break; } return(res); }
private JsonCarrier Ac03putEndTime(JsonCarrier data) { var result = ""; var tb01_Id = data.Email0; var tb02_memo = data.MemoColumn; var tb02_MMDDYYYY = data.EndDateTime.Substring(0, 8); var tb02_Id = ""; if (tb02_memo.Length > 0) { tb02_Id = data.Email0 + tb02_memo; } else { tb02_Id = data.Email0 + tb02_MMDDYYYY; } // 1レコードであればupdate var recordTb02 = appDb.Tb02DailyRecord.Where(t2 => t2.Tb02DailyRecord_Id == tb02_Id); try { var target = recordTb02.Single(); var startTime = target.Tb02DailyRecord_StartTimeStamp; if (startTime != null && startTime.Length > 0) { target.Tb02DailyRecord_EndTimeStamp = data.EndDateTime; target.Tb02DailyRecord_Memo = data.MemoColumn; appDb.SaveChanges(); result = "processOK"; } else { result = "processNG 開始時間の登録がありません"; } } catch (System.SystemException ex) { result = tb02_Id + " processNG " + ex.Message; } return(new JsonCarrier { Email0 = tb01_Id, ActionResult = result }); }
private JsonCarrier Ac01checkId(JsonCarrier data) { var result = ""; var userId = data.Email0; var checkResult = appDb.Tb01Id.Where(id => id.Tb01Name_Id == userId).Count(); if (checkResult == 1) { result = "checkOK"; } else if (checkResult > 1) { result = "checkNG 正しくないメールアドレスです"; } else { result = "checkNG メールアドレスの登録がありません"; } return(new JsonCarrier { GroupeName = data.GroupeName, Email0 = data.Email0, ActionResult = result }); }