public ElementP PribaviElementP(int id)
{
ElementP element = _context.ElementiP.FirstOrDefault(el => el.ElementPId == id);
Console.WriteLine(element.ToString());
return(element);
}
public List <ElementP> GetData(string time)
{
List <ElementP> elementPs = new List <ElementP>();
try
{
con.Open();
DateTime dateTime = DateTime.Parse(time);
dateTime = new DateTime(2000, 1, 1, dateTime.Hour, dateTime.Minute, dateTime.Second);
string sqlP = "SELECT IdentifikacioniKod,RedniBroj,DatumPretrage FROM ElementP";
SqlCommand cmdP = new SqlCommand(sqlP, con);
using (SqlDataReader oReader = cmdP.ExecuteReader())
{
while (oReader.Read())
{
if (dateTime < DateTime.Parse(oReader["DatumPretrage"].ToString()))
{
ElementP ELP = new ElementP();
ELP.IdentifikacioniKod = oReader["IdentifikacioniKod"].ToString();
ELP.RedniBroj = Int32.Parse(oReader["RedniBroj"].ToString());
elementPs.Add(ELP);
Console.WriteLine("Citanje Podataka P");
}
}
}
foreach (var item in elementPs)
{
List <ElementC> elementCs = new List <ElementC>();
string IDenKod = item.IdentifikacioniKod;
string sqlC = "SELECT Grupa,Vrednost FROM ElementC WHERE IDKOD=@IDenKod";
SqlCommand cmdC = new SqlCommand(sqlC, con);
cmdC.Parameters.AddWithValue("@IDenKod", IDenKod);
using (SqlDataReader oReader = cmdC.ExecuteReader())
{
while (oReader.Read())
{
ElementC ELC = new ElementC(oReader["Grupa"].ToString().ToCharArray()[0], Int32.Parse(oReader["Vrednost"].ToString()));
elementCs.Add(ELC);
}
}
item.AddCs(elementCs);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
return(elementPs);
}
public void AddData(ElementP elP)
{
Console.WriteLine("ADDDING DATA IN TO THE DATABASE >>> \n\n\n");
try
{
con.Open();
string sql = "INSERT INTO ElementP (IdentifikacioniKod,RedniBroj,DatumPretrage) values (@ID,@RB,@DP)";
cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@ID", SqlDbType.VarChar);
cmd.Parameters["@ID"].Value = elP.IdentifikacioniKod;
cmd.Parameters.Add("@RB", SqlDbType.Int);
cmd.Parameters["@RB"].Value = elP.RedniBroj;
cmd.Parameters.Add("@DP", SqlDbType.Time);
cmd.Parameters["@DP"].Value = DateTime.Now.TimeOfDay;
cmd.ExecuteNonQuery();
ElementC[] elementCs = elP.Elementi;
foreach (var item in elementCs)
{
sql = "INSERT INTO ElementC (IDKOD,Grupa,Vrednost) values (@IDK,@G,@V)";
cmd = new SqlCommand(sql, con);
cmd.Parameters.Add("@IDK", SqlDbType.VarChar);
cmd.Parameters["@IDK"].Value = elP.IdentifikacioniKod;
cmd.Parameters.Add("@G", SqlDbType.VarChar);
cmd.Parameters["@G"].Value = item.Grupa;
cmd.Parameters.Add("@V", SqlDbType.Int);
cmd.Parameters["@V"].Value = item.Vrednost;
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
con.Close();
}
}
public void Post([FromBody] ElementP value)
{
Console.WriteLine($"\n\n\nPOST REQUEST WITH VALUE : {value}\n\n\n");
dBS.AddData(value);
}
static void Main(string[] args)
{
try
{
var ctx = new ElementiContext();
_elementPService = new ElementPService(ctx);
_pretragaService = new PretragaService(ctx);
_elementCService = new ElementCService(ctx);
Random rnd = new Random();
int n = 0;
int k = 0;
int p = 0;
int brojPretraga = 0;
Console.WriteLine("Unesite zeljeni broj elemenata tipa ElementP.");
n = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Unesite zeljeni broj elemenata tipa ElementC.");
k = Convert.ToInt32(Console.ReadLine());
for (int i = 0; i < n; i++)
{
string idenTifikacioniKod = String.Format("elementp_{0}", i);
ElementP elP = new ElementP()
{
IdentifikacioniKod = idenTifikacioniKod, RedniBroj = i
};
for (int j = 0; j < k; j++)
{
char grupa = (char)rnd.Next(97, 122);
int vrednost = rnd.Next(1, 9);
ElementC elC = new ElementC()
{
Grupa = grupa, Vrednost = vrednost
};
elP.Elementi.Add(elC);
}
_elementPService.KreirajElementP(elP);
}
Console.WriteLine("Unesite zeljeni broj pretraga: ");
brojPretraga = Convert.ToInt32(Console.ReadLine());
for (int i = 0; i < brojPretraga; i++)
{
Console.WriteLine("Unesite zeljeni prag za koji će se vršiti pretraga Elemenata P po sumi njihovih članova ElementC");
p = Convert.ToInt32(Console.ReadLine());
List <DataLayer.Models.ElementP> elementiP = _elementPService.VratiSvePSaSumomCVecomOd(p);
Pretraga pret = new Pretraga()
{
VremePretrage = DateTime.Now
};
foreach (var el in elementiP)
{
pret.PronadjeniElementi.Add(el);
}
_pretragaService.KreirajElementP(pret);
}
ctx.Dispose();
}
catch (Exception e)
{
}
}
public ElementP PribaviElementPPoIdKodu(string identifikacioniKod)
{
ElementP pronadjeniElement = _context.ElementiP.FirstOrDefault(el => el.IdentifikacioniKod == identifikacioniKod);
return(pronadjeniElement);
}
public void KreirajElementP(ElementP element)
{
_context.ElementiP.Add(element);
_context.SaveChanges();
}
