public Data.Entity.Broadcast GetById(int id) { Data.Entity.Broadcast result = new Data.Entity.Broadcast(); using (AppDBContext dbContext = new AppDBContext(_config)) { result = dbContext.Broadcast.Where(r => r.Id == id).AsNoTracking().SingleOrDefault(); } return(result); }
public int Update(Data.Entity.Broadcast record) { int result = 0; using (AppDBContext dbContext = new AppDBContext(_config)) { dbContext.Entry(record).State = EntityState.Modified; result = dbContext.SaveChanges(); } return(result); }
public ApiResponseModel <Data.Entity.Broadcast> EditBroadcastWithDetail(int id, [FromBody] AddRequestModel requestModel, [FromHeader] string displayLanguage) { var responseModel = new ApiResponseModel <Data.Entity.Broadcast>() { DisplayLanguage = displayLanguage }; //user bilgilerinden filitre parametreleri eklenir. TokenModel tokenModel = TokenHelper.DecodeTokenFromRequestHeader(Request); var employeeId = tokenModel.ID; try { var broadcast = _broadcastService.GetById(id); if (broadcast == null) { responseModel.ResultStatusCode = ResultStatusCodeStatic.Error; responseModel.ResultStatusMessage = "No Records Found"; return(responseModel); } var record = new Data.Entity.Broadcast(); broadcast.Id = requestModel.Id; broadcast.TitleTR = requestModel.TitleTR; broadcast.TitleEN = requestModel.TitleEN; broadcast.DescriptionTR = requestModel.DescriptionTR; broadcast.DescriptionEN = requestModel.DescriptionEN; if (!String.IsNullOrEmpty(requestModel.ImageFilePath)) { broadcast.ImageFilePath = "BroadcastFiles/" + requestModel.ImageFilePath; } else { broadcast.ImageFilePath = broadcast.ImageFilePath; } broadcast.VideoFileUrl = requestModel.VideoFileUrl; broadcast.ValidationEndDateTime = requestModel.ValidationEndDateTime; broadcast.ModifiedDateTime = DateTime.Now; broadcast.ModifiedBy = employeeId; var dbResult = _broadcastService.Update(broadcast); if (dbResult > 0) { responseModel.Data = record; // oluşturulan entity bilgisinde id kolonu atanmış olur ve entity geri gönderiliyor responseModel.ResultStatusCode = ResultStatusCodeStatic.Success; responseModel.ResultStatusMessage = "Success"; } else { //hata oluşursa varsa resmi silmemiz gerekecek if (!string.IsNullOrEmpty(requestModel.ImageFilePath)) { var filePath = Path.Combine(_hostingEnvironment.WebRootPath, "BroadcastFiles") + "\\" + requestModel.ImageFilePath; if (System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath); } } responseModel.ResultStatusCode = ResultStatusCodeStatic.Error; responseModel.ResultStatusMessage = "Could Not Be Saved"; } } catch (Exception ex) { //hata oluşursa varsa resmi silmemiz gerekecek if (!string.IsNullOrEmpty(requestModel.ImageFilePath)) { var filePath = Path.Combine(_hostingEnvironment.WebRootPath, "BroadcastFiles") + "\\" + requestModel.ImageFilePath; if (System.IO.File.Exists(filePath)) { System.IO.File.Delete(filePath); } } responseModel.ResultStatusCode = ResultStatusCodeStatic.Error; responseModel.ResultStatusMessage = ex.Message; } return(responseModel); }