public object Clone()
{
var newComanda = (Comenzi)MemberwiseClone();
newComanda.Articole = new List <string>(Articole);
for (var i = 0; i < Articole.Count(); i++)
{
newComanda.Articole[i] = Articole[i];
}
return(newComanda);
}
private static void SendMessage(ConnectionFactory factory, Articole model)
{
using (var connection = factory.CreateConnection())
using (var channel = connection.CreateModel())
{
channel.QueueDeclare(queue: "test", durable: false, exclusive: false, autoDelete: false, arguments: null);
var json = JsonConvert.SerializeObject(model);
var body = Encoding.UTF8.GetBytes(json);
channel.BasicPublish(exchange: "", routingKey: "test", basicProperties: null, body: body);
}
}
protected void Cauta_Dupa_Autor(object sender, EventArgs e)
{
//string query = Server.UrlDecode(Request.Params["id"]);
string autor = Text_Dupa_Autor.Text;
Mesaj.Text = "";
Articole.SelectCommand = "SELECT b.Id, Titlu, Descriere, Username, Data_publicare, Cale FROM [Imagine] c,[Articol] b , [User] a WHERE b.id_user = a.Id AND b.Id = c.Id_Articol AND a.Username = @user";
Articole.SelectParameters.Clear();
Articole.SelectParameters.Add("user", autor);
Articole.DataBind();
Text_Dupa_Autor.Text = "";
//string dataCautare = Text_Data.Text;
}
protected void Cauta_Dupa_User(object sender, EventArgs e)
{
//string query = Server.UrlDecode(Request.Params["id"]);
string autor = Text_Stiri_Dupa_User.Text;
Mesaj.Text = "";
Articole.SelectCommand = "select a.Id, Titlu_propunere, Continut_propunere, Username, Data_propunere, c.Nume,Imagine_propunere from [Stiri_Propuse] a, [User] b,[Categorii] c where b.Id=a.User_propunere and a.Categorie_propunere=c.Id and b.Username = @user";
Articole.SelectParameters.Clear();
Articole.SelectParameters.Add("user", autor);
Articole.DataBind();
Text_Stiri_Dupa_User.Text = "";
pnl.Visible = false;
//string dataCautare = Text_Data.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack && Request.Params["q"] != null)
{
string query = Server.UrlDecode(Request.Params["q"]);
if (query.Length > 0)
{
Criteriu.Text = "Rezultatele cautarii: " + query;
}
Articole.SelectCommand = "SELECT distinct [Articol].[Id],[Articol].[Titlu], [Articol].[Descriere],[Articol].[Data_Publicare],[Imagine].[Cale], [User].[Username]"
+ " FROM [Articol],[User] ,[Imagine],[Categorii] "
+ " WHERE [Articol].[Id]=[Imagine].[Id_Articol] AND [Articol].[Id_User] = [User].[Id] AND [Articol].[Categorie] = [Categorii].[Id]"
+ " AND ([Articol].[Titlu] like @q OR [Articol].[Descriere] like @q OR [Categorii].[Nume] like @q) order by [Articol].[Titlu]";
Articole.SelectParameters.Clear();
Articole.SelectParameters.Add("q", "%" + query + "%");
Articole.DataBind();
}
}
protected void Cauta_Dupa_Data(object sender, EventArgs e)
{
//string query = Server.UrlDecode(Request.Params["id"]);
DateTime dataCautare;
if (DateTime.TryParse(Text_Data.Text, out dataCautare))
{
Mesaj.Text = "";
Articole.SelectCommand = "select b.Id, Titlu, Descriere, Username, Data_publicare, Cale from [Imagine] c,[Articol] b , [User] a where b.id_user = a.Id and b.Id = c.Id_Articol and convert(datetime, convert(varchar(10), Data_Publicare, 102)) = convert(datetime, @data)";
Articole.SelectParameters.Clear();
Articole.SelectParameters.Add("data", dataCautare.ToString());
Articole.DataBind();
Text_Data.Text = "";
}
else
{
Mesaj.Text = "Introdu o data valida!";
}
//string dataCautare = Text_Data.Text;
}
public ActionResult Create(Articole articol)
{
try
{
if (ModelState.IsValid)
{
ViewBag.Text = ci.InsertSqlRowsArticole(articol);
}
var factory = new ConnectionFactory()
{
Uri = new Uri("amqp://*****:*****@shark.rmq.cloudamqp.com/eoqhublt"),
UserName = "******",
Password = "******",
};
SendMessage(factory, articol);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
