public ActionResult InsertMetaData(MetadataModelParams data) { try { //validate the data if (data.movieId == 0 || data.language.Length == 0 || data.releaseYear == 0 || data.title.Length == 0) { IDictionary <string, string> data_error = new Dictionary <string, string>(); data_error.Add("error_message", "Please complete the data parameters"); return(NotFound(data_error)); } var lastdata = _metadataservice.GetLastDatainMetaData(); var record = _metadataservice.InsertMetaData(data, lastdata.Id); return(Ok(record)); } catch (Exception ex) { throw ex; } }
public MetadataModel InsertMetaData(MetadataModelParams data, int LastId) { var records = new List <MetadataModel>(); /* * DateTime.Now.ToString("h:mm tt") 5:50 AM * DateTime.Now.ToString("HH:mm:ss") 05:50:06 */ MetadataModel record = new MetadataModel(); record.Id = LastId + 1; record.MovieId = data.movieId; record.Title = data.title; record.Language = data.language; string Time = data.duration; DateTime date = DateTime.Parse(Time, System.Globalization.CultureInfo.CurrentCulture); string dateTimeduration = date.ToString("HH:mm:ss"); record.Duration = dateTimeduration.ToString(); record.ReleaseYear = data.releaseYear; records.Add(record); var config = new CsvConfiguration(CultureInfo.InvariantCulture) { HasHeaderRecord = false, }; using (var stream = new FileStream(csvFile, FileMode.Append)) using (var writer = new StreamWriter(stream)) using (var csv = new CsvWriter(writer, config)) { csv.WriteRecords(records); } return(record); }