public IHttpActionResult AddPersonelInCompany(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblPersonelInCompany NewPersonelInCompany = JsonObject.ToObject <ViewModel.tblPersonelInCompany>(); ViewModel.Search PersonelInCompanySearch = new ViewModel.Search(); PersonelInCompanySearch.Filter = " AND tblPersonelInCompany.NationalCode = '" + NewPersonelInCompany.NationalCode + "'"; PersonelInCompanySearch.JsonResult = " FOR JSON PATH "; JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyJsonData(PersonelInCompanySearch); if (JsonPersonelInCompany.HasValues) { return(NotFound()); } byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]); MemoryStream ms = new MemoryStream(imageBytes, 0, imageBytes.Length); ms.Write(imageBytes, 0, imageBytes.Length); Image imagePersonelInCompany = 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\PersonelInCompany\" + NewPersonelInCompany.IDPersonelInCompany + FileType; NewPersonelInCompany.PicUrl = FileUrl; bool retAdd = BisPersonelInCompany.AddPersonelInCompany(NewPersonelInCompany); if (retAdd) { try { imagePersonelInCompany.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(Ok(retAdd)); } catch (Exception) { ViewModel.tblPersonelInCompany delete = new ViewModel.tblPersonelInCompany(); delete.IDPersonelInCompany = NewPersonelInCompany.IDPersonelInCompany; bool retDelete = BisPersonelInCompany.DeletePersonelInCompany(delete); return(NotFound()); } } else { return(NotFound()); } } else { return(NotFound()); } } catch { return(NotFound()); } }
public IHttpActionResult UpdatePersonelInCompany(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblPersonelInCompany UpdatePersonelInCompany = JsonObject.ToObject <ViewModel.tblPersonelInCompany>(); string FileUrl = ""; ViewModel.Search PersonelInCompanySearch = new ViewModel.Search(); PersonelInCompanySearch.Filter = " AND tblPersonelInCompany.IDPersonelInCompany ='" + UpdatePersonelInCompany.IDPersonelInCompany + "'"; PersonelInCompanySearch.JsonResult = " FOR JSON PATH "; JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyJsonData(PersonelInCompanySearch); if (UpdatePersonelInCompany.PicUrl == "" && File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonPersonelInCompany[0]["PicUrl"].ToString())) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonPersonelInCompany[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 imagePersonelInCompany = 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\PersonelInCompany\" + Guid.NewGuid() + FileType; UpdatePersonelInCompany.PicUrl = FileUrl; imagePersonelInCompany.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl); } } } bool retUpdate = BisPersonelInCompany.UpdatePersonelInCompany(UpdatePersonelInCompany); if (retUpdate) { return(Ok(retUpdate)); } else { File.Delete(AppDomain.CurrentDomain.BaseDirectory + FileUrl); return(NotFound()); } } catch (Exception ex) { return(NotFound()); } }
public IHttpActionResult GetCompleteDataByNationalCode(ViewModel.tblPersonelInCompany obj) { try { JArray JsonPersonelInCompany = BisPersonelInCompany.GetCompleteDataByNationalCode(obj); return(Ok(JsonPersonelInCompany)); } catch { return(NotFound()); } }
public IHttpActionResult GetCompletePersonelInCompanyByIDXForSite(ViewModel.tblPersonelInCompany obj) { try { JArray JsonPersonelInCompany = BisPersonelInCompany.GetCompletePersonelInCompanyForSite(obj); return(Ok(JsonPersonelInCompany)); } catch { return(NotFound()); } }
public IHttpActionResult GetPersonelInCompanyByNationalCodeAndFullName(object obj) { try { JObject JsonObject = JObject.Parse(obj.ToString()); ViewModel.tblPersonelInCompany personelInCompany = JsonObject.ToObject <ViewModel.tblPersonelInCompany>(); JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyByNationalCodeAndFullName(personelInCompany); return(Ok(JsonPersonelInCompany)); } catch { return(NotFound()); } }
public IHttpActionResult DeletePersonelInCompany(ViewModel.tblPersonelInCompany DelPersonelInCompany) { try { ViewModel.Search objSearch = new ViewModel.Search(); objSearch.Filter = " AND tblPersonelInCompany.IDPersonelInCompany = '" + DelPersonelInCompany.IDPersonelInCompany + "'"; objSearch.JsonResult = " For Json Path"; JArray JsonPersonelInCompany = BisPersonelInCompany.GetPersonelInCompanyJsonData(objSearch); bool ret = BisPersonelInCompany.DeletePersonelInCompany(DelPersonelInCompany); if (ret) { File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonPersonelInCompany[0]["PicUrl"]); return(Ok(ret)); } else { return(NotFound()); } } catch { return(NotFound()); } }
public bool DeletePersonelInCompany(ViewModel.tblPersonelInCompany PersonelInCompany) { return(sqlHelper.RunProcedure("sp_tblPersonelInCompany_Delete", PersonelInCompany, true) > 0); }
public bool AddPersonelInCompany(ViewModel.tblPersonelInCompany PersonelInCompany) { return(sqlHelper.RunProcedure("sp_tblPersonelInCompany_Insert", PersonelInCompany, true) > 0); }
public JArray GetCompleteDataByNationalCode(ViewModel.tblPersonelInCompany PersonelInCompany) { return(sqlHelper.ReturnJsonData("sp_tblPersonelInCompany_GetByNationalCode", PersonelInCompany)); }
public JArray GetCompletePersonelInCompanyForSite(ViewModel.tblPersonelInCompany PersonelInCompany) { return(sqlHelper.ReturnJsonData("sp_tblPersonelInCompany_GetCompleteDataForSite", PersonelInCompany)); }
public JArray GetPersonelInCompanyByNationalCodeAndFullName(ViewModel.tblPersonelInCompany PersonelInCompany) { return(sqlHelper.ReturnJsonData("sp_tblPersonelInCompany_GetPersonelInCompanyByNationalCodeAndFullName", PersonelInCompany)); }