public int Update(Pilates_Info data) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data)); } }
public int Update(long PilatesId, Pilates_Info data, IEnumerable <string> columns) { using (var db = new DBExecutor().GetDatabase()) { return(db.Update(data, PilatesId, columns)); } }
public long Insert(Pilates_Info data) { using (var db = new DBExecutor().GetDatabase()) { long NewID = 0; var result = db.Insert(data); if (result != null) { long.TryParse(result.ToString(), out NewID); } return(NewID); } }
public long Insert(Pilates_Info data) { long newID = 0; try { newID = new Pilates_Repo().Insert(data); } catch (Exception ex) { log.Exception(ex); } return(newID); }
public bool Update(Pilates_Info data) { return(new Pilates_Repo().Update(data) > 0); }
public bool Update(long PilatesId, Pilates_Info data, IEnumerable <string> columns) { return(new Pilates_Repo().Update(PilatesId, data, columns) > 0); }
public JsonResult SavePilates(Pilates_Info data) { ResultBase result = new ResultBase(); result.setMessage("Done"); if (data.IsActive == 1) { //審核專用 var verdata = PilatesMan.GetBySN(data.PilatesId); verdata.IsActive = 1; verdata.VerifiedDate = DateTime.Now; PilatesMan.Update(verdata); return(Json(result, JsonRequestBehavior.DenyGet)); } else { //一但有任何異動,自動下架 data.IsActive = 0; } if (string.IsNullOrEmpty(data.RegID)) { result.setErrorMessage("課程代號為必選"); } if (data.PublishDate == DateTime.MinValue) { result.setErrorMessage("開課日期格式錯誤,正確格式為YYYY/MM/DD"); } if (string.IsNullOrEmpty(data.RegName)) { result.setErrorMessage("課程名稱不得為空白"); } if (string.IsNullOrEmpty(data.ContentBody)) { result.setErrorMessage("發布內容不得為空白"); } if (string.IsNullOrEmpty(data.TimeStart)) { result.setErrorMessage("上課開始時間不得為空白"); } if (string.IsNullOrEmpty(data.TimeEnd)) { result.setErrorMessage("上課結束時間不得為空白"); } string timesample = "2000/01/01 {0}"; DateTime temptime; if (!DateTime.TryParse(string.Format(timesample, data.TimeStart), out temptime)) { result.setErrorMessage("無效的上課開始時間"); } if (!DateTime.TryParse(string.Format(timesample, data.TimeEnd), out temptime)) { result.setErrorMessage("無效的上課結束時間"); } if (result.JsonReturnCode > -1) { data.LastUpdate = DateTime.Now; data.LastUpdator = sessionData.trading.LoginId; var olddata = PilatesMan.GetBySN(data.PilatesId); if (data.PilatesId > 0) { PilatesMan.Update(data); } else { PilatesMan.Insert(data); } } return(Json(result, JsonRequestBehavior.DenyGet)); }