// редактирование товара или частн. объявления.
public bool UpdateProduct(NewProductInputModel model)
{
char res;
using (IDbConnection db = new SqlConnection(Global.Connection))
{
var resObj = db.Query <NewProductOutputModel>("sp_SearchUpdateAvito",
new {
Catalog = model.Catalog,
Id = model.Id,
Ctlg_Name = model.Ctlg_Name,
TArticle = model.TArticle,
TName = model.TName,
TDescription = model.TDescription,
TCost = model.TCost,
TImageprev = model.TImageprev,
Appcode = model.Appcode,
TypeProd = model.TypeProd,
PrcNt = model.PrcNt,
TransformMech = model.TransformMech,
audio = model.audio,
video = model.video,
CID = model.CID
},
commandType: CommandType.StoredProcedure).First();
res = resObj.Result;
}
return(res == '1');
}
//[Authorize]
public IActionResult Put([FromBody] NewProductInputModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest("Не верные параметры в запросе"));
}
var res = repo.UpdateProduct(model);
return(Ok(new { result = res }));
}
// [Authorize]
public IActionResult Post([FromBody] NewProductInputModel model)
{
var ts = DateTime.Now;
Console.WriteLine();
Console.WriteLine("Product Post request started" + ts.ToString());
if (!ModelState.IsValid)
{
return(BadRequest("Не верные параметры в запросе"));
}
var res = repo.InsertProduct(model);
Console.WriteLine("Product Post request ended " + (DateTime.Now - ts).TotalMilliseconds);
return(Ok(new { result = res.Result, prc_id = res.Prc_ID }));
}
// добавление нового товара или частн. объявления
public NewProductOutputModel InsertProduct(NewProductInputModel model)
{
//char res;
NewProductOutputModel res;
using (IDbConnection db = new SqlConnection(Global.Connection))
{
res = db.Query <NewProductOutputModel>("sp_SearchCreateAvito",
new {
Catalog = model.Catalog,
Id = model.Id,
Ctlg_Name = model.Ctlg_Name,
TArticle = model.TArticle,
TName = model.TName,
TDescription = model.TDescription,
TCost = model.TCost,
TImageprev = model.TImageprev,
Appcode = model.Appcode,
TypeProd = model.TypeProd,
PrcNt = model.PrcNt,
TransformMech = model.TransformMech,
video = model.video,
audio = model.audio,
CID = model.CID
},
commandType: CommandType.StoredProcedure).First();
}
//var path = Path.Combine(res.MediaLink);
//if (!Directory.Exists(path))
//{
// DirectoryInfo dir = Directory.CreateDirectory(path);
//}
//string link = Path.Combine(path, model.audio.FileName);
//var stream = new FileStream(link, FileMode.Create);
//stream.Position = 0;
//await model.audio.CopyToAsync(stream);
//await stream.FlushAsync();
return(res);
}
