public bool DeleteContactInfo(ContactInfoData objContactInfoData, IDbTransaction objOrgTran = null) { bool bolResult = false; try { if (null == objOrgTran) { using (var objConnect = GetDBConnection()) { objConnect.Delete(objContactInfoData); } } else { GetDBConnection().Delete(objContactInfoData, objOrgTran); } bolResult = true; } catch (Exception ex) { throw ex; } return(bolResult); }
public ActionResult Edit(long lContactInfoID) { ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); ContactInfoData objContactInfoData = objContactInfoRepository.GetContactInfo(lContactInfoID); return(View(objContactInfoData)); }
public bool AddUpdateContactInfo(ContactInfoData objContactInfoData) { bool bolResult = false; try { using (var objConnect = GetDBConnection()) { using (var objTran = objConnect.BeginTransaction()) { try { AddContactInfo(objContactInfoData, objTran); objContactInfoData.Nickname = (string.IsNullOrWhiteSpace(objContactInfoData.Nickname) ? objContactInfoData.Name : objContactInfoData.Nickname); UpdateContactInfo(objContactInfoData, objTran); objTran.Commit(); bolResult = true; } catch (Exception ex) { objTran.Rollback(); throw ex; } } } } catch (Exception ex) { throw ex; } return(bolResult); }
public void SetContactData(ContactInfoData pData) { _Data = pData; OnPropertyChanged("Name"); //OnPropertyChanged("ContactStateType"); }
public ActionResult Create_AjaxModelPost(ContactInfoData objContactInfoData) { try { if (ModelState.IsValid) { ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); objContactInfoRepository.AddContactInfo(objContactInfoData); var returnData = new { IsSuccess = true }; return(Content(JsonConvert.SerializeObject(returnData), "application/json")); } else { ModelState.AddModelError("InsertError", "新增失敗!"); var returnData = new { IsSuccess = false, ModelStateErrors = ModelState.Where(p => p.Value.Errors.Count > 0).ToDictionary(p => p.Key, p => p.Value.Errors.Select(e => e.ErrorMessage).ToArray()) }; return(Content(JsonConvert.SerializeObject(returnData), "application/json")); } } catch (Exception ex) { var returnData = new { IsSuccess = false, ExceptionMsg = ex.Message }; return(Content(JsonConvert.SerializeObject(returnData), "application/json")); } }
public UpdateResponse Update(UpdateRequest objUpdateRequest) { UpdateResponse objUpdateResponse = new UpdateResponse(); ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); try { #region [Validation] bool bolCheckSign = Utility.CheckSHA(objUpdateRequest.Sign.Trim(), GetSign(objUpdateRequest, ApiSignKey)); if (!bolCheckSign) { objUpdateResponse.Result = $"{MsgFail} : Sign Validate Error"; return(objUpdateResponse); } #endregion #region [Logic] ContactInfoData objContactInfoData = objContactInfoRepository.GetContactInfo(Convert.ToInt64(objUpdateRequest.ContactInfoID)); if (null == objContactInfoData) { objUpdateResponse.Result = $"{MsgFail} : No Data"; } else { objContactInfoData.Name = objUpdateRequest.Name.Trim(); objContactInfoData.Nickname = (!string.IsNullOrWhiteSpace(objUpdateRequest.Nickname) ? objUpdateRequest.Nickname.Trim() : null); objContactInfoData.Gender = (ContactInfoData.EnumGender?)objUpdateRequest.Gender; objContactInfoData.Age = objUpdateRequest.Age; objContactInfoData.PhoneNo = objUpdateRequest.PhoneNo.Trim(); objContactInfoData.Address = objUpdateRequest.Address.Trim(); bool bolUpdateResult = objContactInfoRepository.UpdateContactInfo(objContactInfoData); if (bolUpdateResult) { objUpdateResponse.Result = MsgSuccess; objUpdateResponse.Data = objContactInfoData; objUpdateResponse.Sign = GetSign(objUpdateResponse, ApiSignKey); } else { objUpdateResponse.Result = $"{MsgFail} : Update Data Error"; } } return(objUpdateResponse); #endregion } catch (Exception ex) { #region [Exception] objUpdateResponse.Result = $"{MsgException} : {ex.Message}"; return(objUpdateResponse); #endregion } }
public IHttpActionResult Get(long id) { QueryResponse objQueryResponse; if (ModelState.IsValid) { try { ContactInfoRESTfulRepository objContactInfoRESTfulRepository = new ContactInfoRESTfulRepository(); ContactInfoData objContactInfoData = objContactInfoRESTfulRepository.Query(id); if (null == objContactInfoData) { objQueryResponse = new QueryResponse() { Result = $"{ MsgFail } : No Data" }; } else { objQueryResponse = new QueryResponse() { Result = MsgSuccess, Data = objContactInfoData }; } } catch (Exception ex) { objQueryResponse = new QueryResponse() { Result = $"{MsgException} : {ex.Message}" }; } //return Ok(objQueryResponse); } else { //return BadRequest(ModelState); string strErrorMsg = string.Empty; foreach (var item in ModelState.Values) { strErrorMsg += string.Join(",", item.Errors.Select(e => e.ErrorMessage)); } objQueryResponse = new QueryResponse() { Result = string.IsNullOrWhiteSpace(strErrorMsg) ? "Request Format Error" : strErrorMsg }; } //轉換JSON格式回傳 HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(Utility.GetJSON(objQueryResponse), Encoding.GetEncoding("UTF-8"), "application/json") }; return(ResponseMessage(result)); }
public DeleteResponse Delete(DeleteRequest objDeleteRequest) { DeleteResponse objDeleteResponse = new DeleteResponse(); ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); try { #region [Validation] bool bolCheckSign = Utility.CheckSHA(objDeleteRequest.Sign.Trim(), GetSign(objDeleteRequest, ApiSignKey)); if (!bolCheckSign) { objDeleteResponse.Result = $"{MsgFail} : Sign Validate Error"; return(objDeleteResponse); } #endregion #region [Logic] ContactInfoData objContactInfoData = objContactInfoRepository.GetContactInfo(Convert.ToInt64(objDeleteRequest.ContactInfoID)); if (null == objContactInfoData) { objDeleteResponse.Result = $"{MsgFail} : No Data"; } else { bool bolDeleteResult = objContactInfoRepository.DeleteContactInfo(objContactInfoData); if (bolDeleteResult) { objDeleteResponse.Result = MsgSuccess; objDeleteResponse.Sign = GetSign(objDeleteResponse, ApiSignKey); } else { objDeleteResponse.Result = $"{MsgFail} : Delete Data Error"; } } return(objDeleteResponse); #endregion } catch (Exception ex) { #region [Exception] objDeleteResponse.Result = $"{MsgException} : {ex.Message}"; return(objDeleteResponse); #endregion } }
public bool Delete(ContactInfoData objContactInfoData) { bool bolResult = false; try { using (var db = new SqlConnection(DBConnectString)) { db.Delete <ContactInfoData>(objContactInfoData); } bolResult = true; } catch (Exception ex) { throw ex; } return(bolResult); }
public ActionResult Create(ContactInfoData objContactInfoData) { try { if (ModelState.IsValid) { ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); objContactInfoRepository.AddContactInfo(objContactInfoData); return(RedirectToAction("Index")); } else { ModelState.AddModelError("InsertError", "新增失敗!"); return(View(objContactInfoData)); } } catch { ModelState.AddModelError("InsertError", "新增失敗!"); return(View(objContactInfoData)); } }
public ContactInfoData GetContactInfo(long ContactInfoID) { ContactInfoData objContactInfoData = null; try { using (var objConnect = GetDBConnection()) { StringBuilder sbSQL = new StringBuilder(); sbSQL.AppendLine("SELECT * FROM Tbl_ContactInfo"); sbSQL.AppendLine("WHERE ContactInfoID=@ContactInfoID"); sbSQL.AppendLine("ORDER BY ContactInfoID DESC"); objContactInfoData = objConnect.Query <ContactInfoData>(sbSQL.ToString(), new { ContactInfoID = ContactInfoID }).FirstOrDefault(); } } catch (Exception ex) { throw ex; } return(objContactInfoData); }
public ActionResult Edit(long lContactInfoID, FormCollection objFormCollection) { try { ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); ContactInfoData objContactInfoData = objContactInfoRepository.GetContactInfo(lContactInfoID); if (null != objContactInfoData && TryUpdateModel <ContactInfoData>(objContactInfoData, "", objFormCollection.AllKeys, new string[] { "ContactInfoID", "CreateTime", "UpdateTime" })) { objContactInfoRepository.UpdateContactInfo(objContactInfoData); return(RedirectToAction("Index")); } else { ModelState.AddModelError("UpdateError", "更新失敗!"); return(View(objContactInfoData)); } } catch { ModelState.AddModelError("UpdateError", "更新失敗!"); return(View()); } }
public ActionResult Delete(long lContactInfoID, FormCollection objFormCollection) { try { ContactInfoRepository objContactInfoRepository = new ContactInfoRepository(); ContactInfoData objContactInfoData = objContactInfoRepository.GetContactInfo(lContactInfoID); if (null != objContactInfoData) { objContactInfoRepository.DeleteContactInfo(objContactInfoData); return(RedirectToAction("Index")); } else { ModelState.AddModelError("DeleteError", "刪除失敗!"); return(View(objContactInfoData)); } } catch { ModelState.AddModelError("DeleteError", "刪除失敗!"); return(View()); } }
public bool AddContactInfo(ContactInfoData objContactInfoData, IDbTransaction objOrgTran = null) { bool bolResult = false; try { if (null == objOrgTran) { using (var objConnect = GetDBConnection()) { objContactInfoData.IsEnable = true; objContactInfoData.CreateTime = DateTime.Now; long?ContactInfoID = objConnect.Insert(objContactInfoData); objContactInfoData.ContactInfoID = Convert.ToInt64(ContactInfoID); } } else { objContactInfoData.IsEnable = true; objContactInfoData.CreateTime = DateTime.Now; long?ContactInfoID = GetDBConnection().Insert(objContactInfoData, objOrgTran); objContactInfoData.ContactInfoID = Convert.ToInt64(ContactInfoID); } bolResult = true; } catch (Exception ex) { throw ex; } return(bolResult); }
public bool Insert(ContactInfoData objContactInfoData) { bool bolResult = false; try { using (var db = new SqlConnection(DBConnectString)) { objContactInfoData.IsEnable = true; objContactInfoData.CreateTime = DateTime.Now; long?lContactInfoID = db.Insert <ContactInfoData>(objContactInfoData); objContactInfoData.ContactInfoID = Convert.ToInt64(lContactInfoID); } bolResult = true; } catch (Exception ex) { throw ex; } return(bolResult); }
public void SetContactData(ContactInfoData pData) { _Data = pData; OnPropertyChanged("Name"); OnPropertyChanged("_GreenDotVisibility"); }
public IHttpActionResult Post([FromBody] AddRequest objAddRequest) { AddResponse objAddResponse; if (null != objAddRequest && ModelState.IsValid) { try { ContactInfoData objContactInfoData = new ContactInfoData(); objContactInfoData.Name = objAddRequest.Name.Trim(); objContactInfoData.Nickname = (!string.IsNullOrWhiteSpace(objAddRequest.Nickname) ? objAddRequest.Nickname.Trim() : null); objContactInfoData.Gender = (ContactInfoData.EnumGender?)objAddRequest.Gender; objContactInfoData.Age = objAddRequest.Age; objContactInfoData.PhoneNo = objAddRequest.PhoneNo.Trim(); objContactInfoData.Address = objAddRequest.Address.Trim(); ContactInfoRESTfulRepository objContactInfoRESTfulRepository = new ContactInfoRESTfulRepository(); bool bolResult = objContactInfoRESTfulRepository.Insert(objContactInfoData); if (bolResult) { objAddResponse = new AddResponse() { Result = MsgSuccess, Data = objContactInfoData }; } else { objAddResponse = new AddResponse() { Result = $"{MsgFail} : Insert Data Error" }; } } catch (Exception ex) { objAddResponse = new AddResponse() { Result = $"{MsgException} : {ex.Message}" }; } //return Ok(objAddResponse); } else { //return BadRequest(ModelState); string strErrorMsg = string.Empty; foreach (var item in ModelState.Values) { strErrorMsg += string.Join(",", item.Errors.Select(e => e.ErrorMessage)); } objAddResponse = new AddResponse() { Result = string.IsNullOrWhiteSpace(strErrorMsg) ? "Request Format Error" : strErrorMsg }; } //轉換JSON格式回傳 HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(Utility.GetJSON(objAddResponse), Encoding.GetEncoding("UTF-8"), "application/json") }; return(ResponseMessage(result)); }