public IHttpActionResult Unsubscribe(ViewModel.tblBulkEmail BulkEmail) { try { bool ret = false; { ViewModel.Search searchBulk = new ViewModel.Search(); searchBulk.Filter = " AND Email = '" + BulkEmail.Email + "'"; searchBulk.JsonResult = " FOR JSON PATH"; JArray jsBulkEmail = BisBulkEmail.GetSentEmailData(searchBulk); if (jsBulkEmail.HasValues) { ret = BisBulkEmail.Unsubscribe_To_True(BulkEmail); } } { ViewModel.Search searchContactWay = new ViewModel.Search(); searchContactWay.Filter = " AND tblContactWay.Input = '" + BulkEmail.Email + "'"; searchContactWay.JsonResult = " FOR JSON PATH"; JArray jsContactWay = BisContactWay.GetContactWayJsonData(searchContactWay); if (jsContactWay.HasValues) { ViewModel.tblContactWay ContactWay = new ViewModel.tblContactWay(); ContactWay.Input = BulkEmail.Email; ret = BisContactWay.Unsubscribe_To_True(ContactWay); } } if (ret) { return(Ok()); } else { return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
public bool Unsubscribe_To_True(ViewModel.tblBulkEmail tblBulkEmail) { return(sqlHelper.RunProcedure("sp_tblBulkEmail_Update_Unsubscribe_To_True", tblBulkEmail) > 0); }