public DataTable PictureVideos_Insert(PictureVideosBase pictureVideoBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@Assigned", pictureVideoBase.Assigned), new MyParameter("@MediaExtention", pictureVideoBase.MediaExtention), new MyParameter("@MediaName", pictureVideoBase.MediaName), new MyParameter("@Description", pictureVideoBase.Description), new MyParameter("@PicType", pictureVideoBase.PicType), new MyParameter("@DefaultPic", pictureVideoBase.DefaultPic), // new MyParameter("@EncodeArray",pictureVideoBase.EncodeArray), new MyParameter("@EncodeState", pictureVideoBase.EncodeState), new MyParameter("@FilePath", pictureVideoBase.FilePath), new MyParameter("@EncodeFaceValues", pictureVideoBase.EncodeFaceValues), new MyParameter("@FaceValue", pictureVideoBase.FaceValue), new MyParameter("@PictureType", pictureVideoBase.PictureType), new MyParameter("@SubFeatureID", pictureVideoBase.SubFeatureID), new MyParameter("@SubFeaturesid", pictureVideoBase.SubFeaturesid) }; Common.Set_Procedures("PictureVideos_Insert"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public ActionResult PictureVideos_Delete(PictureVideosBase pictureVideoBase) { try { actionResult.dtResult = mediatDL.PictureVideos_Delete(pictureVideoBase); if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0) { actionResult.IsSuccess = true; } } catch (Exception ex) { ErrorReporting.ActionLayerError(ex); } return(actionResult); }
public ActionResult CropMediaPicture_U(PictureVideosBase pictureVideoBase) { try { actionResult.dtResult = mediatDL.CropMediaPicture_U(pictureVideoBase); if (actionResult.dtResult != null && actionResult.dtResult.Rows.Count > 0) { //actionResult.RowsAffected = Convert.ToInt32(actionResult.dtResult.Rows[0]["result"]); actionResult.IsSuccess = true; } } catch (Exception ex) { ErrorReporting.ActionLayerError(ex); } return(actionResult); }
public DataTable PictureVideos_Delete(PictureVideosBase pictureVideoBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@MediaID", pictureVideoBase.MediaID) }; Common.Set_Procedures("PictureVideos_Delete"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public DataTable PicturesVideos_LoadAll(PictureVideosBase pictureVideosBase) { dtContainer = new DataTable(); try { MyParameter[] myParams = { new MyParameter("@PictureType", pictureVideosBase.PictureType), new MyParameter("@SubFeatureID", pictureVideosBase.SubFeatureID), new MyParameter("@SubFeaturesid", pictureVideosBase.SubFeaturesid) }; Common.Set_Procedures("PicturesVideos_LoadAll"); Common.Set_ParameterLength(myParams.Length); Common.Set_Parameters(myParams); dtContainer = Common.Execute_Procedures_LoadData(); } catch (Exception ex) { ErrorReporting.DataLayerError(ex); } return(dtContainer); }
public JsonResult GetAllMoveToPicture(string type, int id, int subFeatureid)//string Picture Type, SubFeature ID for Feature media { string json = ""; List <MediaModel> mediaListModel = new List <MediaModel>(); try { PictureVideosBase pictureVideosBase = new PictureVideosBase(); pictureVideosBase.PictureType = type; pictureVideosBase.SubFeatureID = id; pictureVideosBase.SubFeaturesid = subFeatureid; actionResult = mediaAction.PicturesVideos_LoadAll(pictureVideosBase); if (actionResult.IsSuccess) { mediaListModel = CommonMethods.ConvertTo <MediaModel>(actionResult.dtResult); json = Newtonsoft.Json.JsonConvert.SerializeObject(mediaListModel); } } catch (Exception ex) { ErrorReporting.WebApplicationError(ex); } return(Json(json, JsonRequestBehavior.AllowGet)); }