public IHttpActionResult UpdateTrainingCourse(object obj)
{
try
{
JObject JsonObject = JObject.Parse(obj.ToString());
ViewModel.tblTrainingCourse UpdateTrainingCourse = JsonObject.ToObject <ViewModel.tblTrainingCourse>();
string FileUrl = "";
ViewModel.Search TrainingCourseSearch = new ViewModel.Search();
TrainingCourseSearch.Filter = " AND tblTrainingCourse.IDTrainingCourse ='" + UpdateTrainingCourse.IDTrainingCourse + "'";
TrainingCourseSearch.JsonResult = " FOR JSON PATH ";
JArray JsonTrainingCourse = BisTrainingCourse.GetTrainingCourseJsonData(TrainingCourseSearch);
if (UpdateTrainingCourse.PicUrl == "" && File.Exists(AppDomain.CurrentDomain.BaseDirectory + JsonTrainingCourse[0]["PicUrl"].ToString()))
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonTrainingCourse[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 imageTrainingCourse = 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\TrainingCourse\" + Guid.NewGuid() + FileType;
UpdateTrainingCourse.PicUrl = FileUrl;
imageTrainingCourse.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl);
}
}
}
bool retUpdate = BisTrainingCourse.UpdateTrainingCourse(UpdateTrainingCourse);
if (retUpdate)
{
return(Ok(retUpdate));
}
else
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + FileUrl);
return(NotFound());
}
}
catch (Exception ex)
{
return(NotFound());
}
}
public IHttpActionResult GetTrainingCourseDataForSiteByIDX(ViewModel.tblTrainingCourse TrainingCourseSearch)
{
try
{
JArray JsonTrainingCourse = BisTrainingCourse.GetDataForSiteByIDX(TrainingCourseSearch);
return(Ok(JsonTrainingCourse));
}
catch (Exception ex)
{
return(NotFound());
}
}
public IHttpActionResult AddTrainingCourse(object obj)
{
try
{
JObject JsonObject = JObject.Parse(obj.ToString());
ViewModel.tblTrainingCourse NewTrainingCourse = JsonObject.ToObject <ViewModel.tblTrainingCourse>();
byte[] imageBytes = Convert.FromBase64String(JsonObject["PicFile"].ToString().Split(',')[1]);
MemoryStream ms = new MemoryStream(imageBytes, 0,
imageBytes.Length);
ms.Write(imageBytes, 0, imageBytes.Length);
Image imageTrainingCourse = 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\TrainingCourse\" + NewTrainingCourse.IDTrainingCourse + FileType;
NewTrainingCourse.PicUrl = FileUrl;
bool retAdd = BisTrainingCourse.AddTrainingCourse(NewTrainingCourse);
if (retAdd)
{
try
{
imageTrainingCourse.Save(AppDomain.CurrentDomain.BaseDirectory + FileUrl);
return(Ok(retAdd));
}
catch (Exception)
{
ViewModel.tblTrainingCourse delete = new ViewModel.tblTrainingCourse();
delete.IDTrainingCourse = NewTrainingCourse.IDTrainingCourse;
bool retDelete = BisTrainingCourse.DeleteTrainingCourse(delete);
return(NotFound());
}
}
else
{
return(NotFound());
}
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public IHttpActionResult DeleteTrainingCourse(ViewModel.tblTrainingCourse DelTrainingCourse)
{
try
{
ViewModel.Search objSearch = new ViewModel.Search();
objSearch.Filter = " AND tblTrainingCourse.IDTrainingCourse = '" + DelTrainingCourse.IDTrainingCourse + "'";
objSearch.JsonResult = " For Json Path";
JArray JsonTrainingCourse = BisTrainingCourse.GetTrainingCourseJsonData(objSearch);
bool ret = BisTrainingCourse.DeleteTrainingCourse(DelTrainingCourse);
if (ret)
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + JsonTrainingCourse[0]["PicUrl"]);
return(Ok(ret));
}
else
{
return(NotFound());
}
}
catch
{
return(NotFound());
}
}
public bool DeleteTrainingCourse(ViewModel.tblTrainingCourse tblTrainingCourse)
{
return(sqlHelper.RunProcedure("sp_tblTrainingCourse_Delete", tblTrainingCourse) > 0);
}
public bool AddTrainingCourse(ViewModel.tblTrainingCourse tblTrainingCourse)
{
return(sqlHelper.RunProcedure("sp_tblTrainingCourse_Insert", tblTrainingCourse) > 0);
}
public JArray GetDataForSiteByIDX(ViewModel.tblTrainingCourse tblTrainingCourse)
{
return(sqlHelper.ReturnJsonData("sp_tblTrainingCourse_GetDataForSiteByIDX", tblTrainingCourse));
}
