public ActionResult OnGet(string zanr, string id)
{
Cassandra.ISession session = SessionManager.GetSession();
IMapper mapper = new Mapper(session);
String email = HttpContext.Session.GetString("email");
if (!String.IsNullOrEmpty(email))
{
Korisnik korisnik = mapper.FirstOrDefault <Korisnik>("select * from korisnik where email = '" + email + "'");
if (korisnik.tip == 1)
{
Message = "Admin";
}
else
{
Message = "User"; return(RedirectToPage("/Index"));
}
//Message = "Welcome " + korisnik.ime;
}
else
{
return(RedirectToPage("/Login"));
}
string slikaPrep = "data:image/jpeg;base64,";
zaEdit = mapper.FirstOrDefault <Knjiga>($"select * from \"EBook\".\"Knjiga\" where \"knjigaID\"='{id}' and zanr='{zanr}';");
slikaPrep += Convert.ToBase64String(System.IO.File.ReadAllBytes(Path.Combine(_environment.ContentRootPath, "wwwroot/" + zaEdit.slika)));
nazivSlike = zaEdit.slika;
zaEdit.slika = slikaPrep;
return(Page());
}
public IActionResult OnPost(string staraSlika)
{
Cassandra.ISession session = SessionManager.GetSession();
if (session == null)
{
return(RedirectToPage("/Error"));
}
string fileName = saveBase64AsImage(zaEdit.slika);
zaEdit.slika = "images/" + "Library" + "/" + fileName;
System.IO.FileInfo oldPic = new FileInfo(Path.Combine(_environment.ContentRootPath, "wwwroot/" + nazivSlike));
oldPic.Delete();
String query = $"update \"Knjiga\" set autor='{zaEdit.autor}', brstrana='{zaEdit.brstrana}', godina='{zaEdit.godina}', kolicina={zaEdit.kolicina}, naziv='{zaEdit.naziv}', opis='{zaEdit.opis}', pismo='{zaEdit.pismo}', slika='{zaEdit.slika}', jezik= '{zaEdit.jezik}'where \"knjigaID\"='{zaEdit.knjigaID}' and zanr='{zaEdit.zanr}'";
session.Execute(query);
return(RedirectToPage("/Book", new { id = zaEdit.knjigaID, zanr = zaEdit.zanr }));
}
public ApplicationSignInManager(
ApplicationUserManager userManager,
IHttpContextAccessor contextAccessor,
IUserClaimsPrincipalFactory <ApplicationUser> claimsFactory,
IOptions <IdentityOptions> optionsAccessor,
ILogger <SignInManager <ApplicationUser> > logger,
Cassandra.ISession session)
: base(userManager, contextAccessor, claimsFactory, optionsAccessor, logger, null)
{
this.Session = session;
this.mapper = new Mapper(this.Session);
this.usersTable = new Table <ApplicationUser>(this.Session);
this.userManager = userManager;
this.contextAccessor = contextAccessor;
}
public IActionResult OnPostObrisi(string id, string zanr, string slika)
{
Cassandra.ISession session = SessionManager.GetSession();
if (session == null)
{
return(RedirectToPage("/Error"));
}
String query = $"delete from \"Knjiga\" where \"knjigaID\"='{id}' and zanr='{zanr}'";
session.Execute(query);
System.IO.FileInfo oldPic = new FileInfo(Path.Combine(_environment.ContentRootPath, "wwwroot/" + slika));
oldPic.Delete();
return(RedirectToPage("/Library"));
}
// https://www.instaclustr.com/support/documentation/getting-started/connect-cassandra-c-sample-code/
// AnySqlWebAdmin.Sample.QueryKeyspaces().Wait();
// AnySqlWebAdmin.TestCassandra.Test();
public static void Test()
{
System.Console.WriteLine("Hello Cassandra!");
using (Cassandra.ICluster cluster = Cassandra.Cluster.Builder()
.AddContactPoints("127.0.0.1")
.WithPort(9042)
// .WithLoadBalancingPolicy(new Cassandra.DCAwareRoundRobinPolicy("AWS_VPC_AP_SOUTHEAST_2"))
// .WithAuthProvider(new Cassandra.PlainTextAuthProvider("Username", "Password"))
.Build())
{
// Connect to the nodes using a keyspace
using (Cassandra.ISession session = cluster.Connect("system_distributed"))
{
// Get name of a Cluster
System.Console.WriteLine("The cluster's name is: " + cluster.Metadata.ClusterName);
// Execute a query on a connection synchronously
using (Cassandra.RowSet rs = session.Execute("SELECT * FROM repair_history"))
{
// Iterate through the RowSet
foreach (Cassandra.Row row in rs)
{
string value = row.GetValue <string>("keyspace_name");
System.Console.WriteLine(value);
// Do something with the value
} // End Using row
} // End Using rs
Cassandra.Mapping.IMapper mapper = new Cassandra.Mapping.Mapper(session);
// System.Collections.Generic.IEnumerable<User> users = mapper.Fetch<User>("SELECT userid, name FROM users");
// System.Collections.Generic.IEnumerable<User> users2 = mapper.Fetch<User>("SELECT * FROM users WHERE name = ?", "someName");
// https://docs.datastax.com/en/developer/csharp-driver/3.6/features/parametrized-queries/
// https://docs.datastax.com/en/developer/java-driver/3.1/faq/
// https://docs.datastax.com/en/developer/csharp-driver/3.2/
// Cassandra.PreparedStatement statement = session.Prepare("SELECT * FROM table where a = :a and b = :b");
// Bind by name using anonymous types
// session.Execute(statement.Bind(new { a = "aValue", b = "bValue" }));
System.Collections.Generic.IEnumerable <SchemaKeyspaces> keySpaces1 = mapper.Fetch <SchemaKeyspaces>("SELECT * FROM system_schema.keyspaces");
System.Collections.Generic.List <SchemaKeyspaces> keySpaces = System.Linq.Enumerable.ToList(keySpaces1);
System.Console.WriteLine(keySpaces);
using (Cassandra.RowSet rs = session.Execute("SELECT * FROM system_schema.keyspaces"))
{
// Iterate through the RowSet
foreach (Cassandra.Row row in rs)
{
foreach (Cassandra.CqlColumn cc in rs.Columns)
{
object value = row.GetValue <object>(cc.Name);
System.Console.WriteLine(value);
// Do something with the value
} // Next cc
} // End Using row
} // End Using rs
} // End Using session
} // End Using cluster
} // End Sub Test
