public IHttpActionResult UpdateIncident(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblIncident UpdateIncident = JsonObject.ToObject <ViewModel.tblIncident>(); string FileUrl = ""; ViewModel.tblIncident IncidentSearch = new ViewModel.tblIncident(); IncidentSearch.IDIncident = UpdateIncident.IDIncident; JArray JsonIncident = BisIncident.GetIncidentJsonData_ByIDIncident(IncidentSearch); if (UpdateIncident.PicUrl == "" && File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonIncident[0]["PicUrl"].ToString())) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonIncident[0]["PicUrl"].ToString()); } if (JsonObject["PicFile"].ToString() != "{}") { byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); Image imageIncident = Image.FromStream(ms); FileTypes ft = new FileTypes(); string FileType = ft.FindImageTypeInString(JsonObject["PicFile"].ToString().Split(',')[0]); if (imageBytes.Length < 1024 * 1024 && ft.IsImage(FileType)) { if (imageBytes.Length > 0) { FileUrl = @"Picture\Incident\" + Guid.NewGuid() + FileType; UpdateIncident.PicUrl = FileUrl; imageIncident.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); } } } bool retUpdate = BisIncident.UpdateIncident(UpdateIncident); if (retUpdate) { return(Ok(retUpdate)); } else { File.Delete(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetIncidentData_ByIDX(ViewModel.tblIncident IncidentSearch) { try { JArray JsonIncident = BisIncident.GetIncidentJsonData_ByIDX(IncidentSearch); return(Ok(JsonIncident)); } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult AddIncident(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblIncident NewIncident = JsonObject.ToObject <ViewModel.tblIncident>(); byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); Image imageIncident = Image.FromStream(ms); FileTypes ft = new FileTypes(); string FileType = ft.FindImageTypeInString(JsonObject["PicFile"].ToString().Split(',')[0]); if (imageBytes.Length < 1024 * 1024 && ft.IsImage(FileType)) { string FileUrl = @"Picture\Incident\" + Guid.NewGuid() + FileType; NewIncident.PicUrl = FileUrl; bool retAdd = BisIncident.AddIncident(NewIncident); if (retAdd) { try { imageIncident.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(Ok(retAdd)); } catch (Exception) { ViewModel.tblIncident delete = new ViewModel.tblIncident(); delete.IDIncident = NewIncident.IDIncident; bool retDelete = BisIncident.DeleteIncident(delete); return(NotFound()); } } else { return(NotFound()); } } else { return(NotFound()); } } catch { return(NotFound()); } }
public IHttpActionResult DeleteIncident(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblIncident DelIncident = JsonObject.ToObject <ViewModel.tblIncident>(); bool ret = BisIncident.DeleteIncident(DelIncident); if (ret) { return(Ok(ret)); } else { return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
public JArray GetIncidentJsonData(ViewModel.tblIncident tblIncident) { return(sqlHelper.ReturnJsonData("sp_tblIncident_GetData", tblIncident)); }
public bool DeleteIncident(ViewModel.tblIncident tblIncident) { return(sqlHelper.RunProcedure("sp_tblIncident_Delete", tblIncident) > 0); }
public bool AddIncident(ViewModel.tblIncident tblIncident) { return(sqlHelper.RunProcedure("sp_tblIncident_Insert", tblIncident) > 0); }