public JsonResult UpdateOrInsert(string[] words)
{
var cookie = CookiesControll.UserAuthenticationInfo();
string word = "";
bool ok;
foreach (string wr in words)
{
word += $"{wr};";
}
word = !string.IsNullOrEmpty(word) ? word.Remove(word.Length - 1) : word;
PhraseDTO phrase = new PhraseDTO
{
Frase = word,
DataAlteracao = DateTime.Now,
UserId = cookie.Name
};
Debug.WriteLine($"{phrase.Frase} \n {phrase.DataAlteracao} \n {phrase.Id} \n {phrase.UserId}");
if (PhraseBLL.GetPhrase(cookie.Name).Id != "null")
{
ok = PhraseBLL.Update(phrase);
}
else
{
ok = PhraseBLL.Insert(phrase);
}
return(Json(new { ok, url = Url.Action("Configuracao", "Configuracao") }, JsonRequestBehavior.AllowGet));
}
public static bool Update(PhraseDTO person)
{
try
{
string query = $"UPDATE tb_frase SET ds_frase = '{person.Frase}', " +
$"dt_frase_alterada = '{person.DataAlteracao}' WHERE cd_usuario = '{person.UserId}'";
new Commands().ExecuteCommand(query);
return(true);
}
catch
{
return(false);
}
}
public static bool Insert(PhraseDTO person)
{
try
{
string query = "INSERT INTO tb_frase(ds_frase, dt_frase_alterada,cd_usuario) " +
$"VALUES('{person.Frase}','{person.DataAlteracao}','{person.UserId}')";
new Commands().ExecuteCommand(query);
return(true);
}
catch
{
return(false);
}
}
// POST api/<controller>
public IHttpActionResult Post(PhraseDTO pdto)
{
Phrase p = new Phrase();
p.Body = pdto.Body;
var retVal = Phrases.Store(p);
if (retVal != null)
{
return(Ok(retVal));
}
else
{
return(BadRequest("Record could not be created"));
}
}
// PUT api/<controller>/5
public IHttpActionResult Put(int id, PhraseDTO pdto)
{
Phrase p = new Phrase();
p.Id = id;
p.Body = pdto.Body;
Phrase retVal = Phrases.Put(p);
if (retVal != null)
{
return(Ok(retVal));
}
else
{
return(BadRequest("Record could not be updated"));
}
}
public static PhraseDTO GetPhrase(string clause = "")
{
string query = $"SELECT cd_frase as 'Id', ds_frase as 'Frase', dt_frase_alterada as 'DataAlteracao', " +
$"cd_usuario as 'UserId' from tb_frase {clause}";
Commands bd = new Commands();
var Phrase = new PhraseDTO {
Id = "null"
};
var datareader = bd.ExecuteCommandReader(query);
while (datareader.Read())
{
Phrase.Id = datareader["Id"].ToString();
Phrase.Frase = datareader["Frase"].ToString();
Phrase.DataAlteracao = (DateTime)datareader["DataAlteracao"];
Phrase.UserId = datareader["UserId"].ToString();
}
datareader.Close();
return(Phrase);
}
public static bool Insert(PhraseDTO phrase) => PhraseDAO.Insert(phrase);
public static bool Update(PhraseDTO phrase) => PhraseDAO.Update(phrase);
