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