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));
}
