public ActionResult ChangeRecord(RecordsDTO rec) { try { var res = data.PutRecord(rec, rec.Id); return(RedirectToAction("Panel", "Admin")); } catch (Exception e) { return(RedirectToAction("Panel", "Admin")); } }
public void insertRecord(RecordsDTO recordsDTO) { sqlConnection.Open(); /*string sqlQuery = "UPDATE Records SET DonationDate='" + recordsDTO.DONATIONDATE + * "',Recipient='" + recordsDTO.RECIPIENT + * "',RecipientName='" + recordsDTO.RECIPIENTNAME + * "',RecipientAddress='" + recordsDTO.RECIPIENTADDRESS + * "' where DonorID=" + recordsDTO.DONORID;*/ string sqlQuery = " insert into Records values(" + recordsDTO.DONORID + ",'" + recordsDTO.DONATIONDATE + "','" + recordsDTO.RECIPIENT + "','" + recordsDTO.RECIPIENTNAME + "','" + recordsDTO.RECIPIENTADDRESS + "')"; sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlCommand.ExecuteNonQuery(); }
public string PutRecord(RecordsDTO newRecord, long id) { var sId = GetSpecialists(newRecord.SpecName);// var c = sId.Value.Where(s => (s.Name == newRecord.SpecName)).FirstOrDefault().Id; var newRec = new Record(newRecord.Id, newRecord.Clientid, //меняем специалиста по его id c, // newRecord.Date, newRecord.Time, newRecord.TypeWork, newRecord.Price); string curenturl = url + @"/Records/" + id; var res = httpClient.PutAsync( requestUri: curenturl, content: new StringContent(JsonConvert.SerializeObject(newRec), Encoding.UTF8, mediaType: "application/json") ).Result; return(res.StatusCode.ToString()); }
public async Task SaveMessage_WhenCalled_ReturnsMessage() { //Arrange var airTableService = Substitute.For <IAirTableService>(); var mapperConfiguration = new MapperConfiguration(cfg => { cfg.AddProfile <MessageMapper>(); }); IMapper mapper = mapperConfiguration.CreateMapper(); var command = new SaveMessageCommand("text", "title"); var handler = new SaveMessageCommand.SaveMessageCommandHandler(airTableService, mapper); var records = new RecordsDTO() { id = "recCR2LP7wZVioc5H", fields = new FieldsDTO() { id = "1", Message = "Message", receivedAt = DateTime.Now.ToString() } }; airTableService.SaveMessageAsync(Arg.Any <AirTableSaveRequestDTO>()).Returns(new AirTableSaveResponseDTO() { records = new List <RecordsDTO>() { records } }); // Act var result = await handler.Handle(command, new System.Threading.CancellationToken()); // Assert await airTableService.Received(Quantity.AtLeastOne()).SaveMessageAsync(Arg.Any <AirTableSaveRequestDTO>()); result.Should().NotBeNull(); result.records.Should().HaveCount(1); result.records.Should().Equals(records); result.records[0].fields.Message.Should().Equals("text"); result.records[0].fields.Summary.Should().Equals("title"); }
public void MapRecordsDTOToMessage_WhenCalled_MapValues() { //Arrange var config = new MapperConfiguration(cfg => cfg.AddProfile <MessageMapper>()); var mapper = config.CreateMapper(); var record = new RecordsDTO() { id = "1", fields = new FieldsDTO() { id = "1", Message = "message", receivedAt = DateTime.Now.ToString() }, createdTime = DateTime.Now.ToString() }; // Act var message = mapper.Map <RecordsDTO, Message>(record); // Assert Assert.Equal(message.Id, record.fields.id); Assert.Equal(message.Title, record.fields.Summary); Assert.Equal(message.Text, record.fields.Message); Assert.Equal(message.ReceivedAt, record.fields.receivedAt.ToString()); }
public List <RecordsDTO> LinkOfMeetingsAndContentsByCodeClassAndTime(string code, string date, string term) { SettingDTO setdto = setb.GetSettingByTermC(term); DAO.Adobe.SettingDAO sdao = new DAO.Adobe.SettingDAO(); List <RecordsDTO> assetList = new List <RecordsDTO>(); if (term == "93-94-1") { DataTable dtvc = recDAO.LinkOfMeetingsAndContentsByCodeClassAndTime(code, date, term); for (int i = 0; i < dtvc.Rows.Count; i++) { RecordsDTO asset = new RecordsDTO(); AdobeBusiness adobeBusiness = new AdobeBusiness(); asset.ClassCode = dtvc.Rows[i]["code"].ToString(); asset.LessonCode = dtvc.Rows[i]["lesson_code"].ToString(); asset.Size = dtvc.Rows[i]["storage"].ToString(); asset.Duration = dtvc.Rows[i]["Minute"].ToString(); asset.FileType = dtvc.Rows[i]["fileType"].ToString(); asset.FileName = dtvc.Rows[i]["name"].ToString(); asset.Date = dtvc.Rows[i]["Shamsi Date"].ToString(); // asset.Session = dtvc.Rows[i]["session"].ToString(); asset.Link = adobeBusiness.OpenMeetingAsView("http://192.168.30.140/", setdto.vName, setdto.vpass, dtvc.Rows[i]["SCO_ID"].ToString(), dtvc.Rows[i]["_val"].ToString(), "view", sdao.Decrypt(setdto.aPass, true)); assetList.Add(asset); } DataTable dtAdobe = recDAO.LinkOfMeetingsAndContentsByCodeClassAndTime(code, date, term); for (int i = 0; i < dtAdobe.Rows.Count; i++) { RecordsDTO asset = new RecordsDTO(); AdobeBusiness adobeBusiness = new AdobeBusiness(); asset.ClassCode = dtAdobe.Rows[i]["code"].ToString(); asset.LessonCode = dtAdobe.Rows[i]["lesson_code"].ToString(); asset.Size = dtAdobe.Rows[i]["storage"].ToString(); asset.Duration = dtAdobe.Rows[i]["Minute"].ToString(); asset.FileType = dtAdobe.Rows[i]["fileType"].ToString(); asset.FileName = dtAdobe.Rows[i]["name"].ToString(); asset.Date = dtAdobe.Rows[i]["Shamsi Date"].ToString(); // asset.Session = dtAdobe.Rows[i]["session"].ToString(); // asset.Link = dt.Rows[i]["URL"].ToString(); asset.Link = adobeBusiness.OpenMeetingAsView("http://adobe.iauec.ac.ir/", setdto.vName, setdto.vpass, dtAdobe.Rows[i]["SCO_ID"].ToString(), dtAdobe.Rows[i]["_val"].ToString(), "view", sdao.Decrypt(setdto.aPass, true)); assetList.Add(asset); } } else { DataTable dt_live = recDAO.LinkOfMeetingsAndContentsByCodeClassAndTime(code, date, term); for (int i = 0; i < dt_live.Rows.Count; i++) { RecordsDTO asset = new RecordsDTO(); AdobeBusiness adobe = new AdobeBusiness(); asset.ClassCode = dt_live.Rows[i]["code"].ToString(); asset.LessonCode = dt_live.Rows[i]["lesson_code"].ToString(); asset.Size = dt_live.Rows[i]["storage"].ToString(); asset.Duration = dt_live.Rows[i]["Minute"].ToString(); asset.FileType = dt_live.Rows[i]["fileType"].ToString(); asset.FileName = dt_live.Rows[i]["name"].ToString(); asset.Date = dt_live.Rows[i]["Shamsi Date"].ToString(); asset.Link = adobe.OpenMeetingAsHost(setdto.DomainName, setdto.vName, setdto.vpass, dt_live.Rows[i]["SCO_ID"].ToString(), dt_live.Rows[i]["_val"].ToString(), setdto.version == "9.5" ? "" : "view", sdao.Decrypt(setdto.aPass, true)); assetList.Add(asset); } } return(assetList); }