public ActionResult viewBooks()
{
var get = new DB3();
var books = get.Book.Include("Category");
return(View(books));
}
/// <summary>
/// Initializes a new instance of the ParamMap class.
/// </summary>
/// <param name="id">A DB3 identifier of a parameter.</param>
/// <param name="name">A name of a parameter.</param>
/// <param name="dataType">A data type.</param>
/// <param name="isOutput">A flag to indicate whether a parameter is an output parameter.</param>
public ParamMap(DB3 id, string name, DataType dataType, bool isOutput = false)
: base(id)
{
Name = name;
DataType = dataType;
IsOutput = isOutput;
}
public ActionResult signInData(signup s)
{
string o = null, k = null;
string email = Request["email"];
string pass = Request["pass"];
var db = new DB3();
var login = from signup in db.signup select signup;
try
{
var user = login.Single(u => u.email == s.email && u.pass == s.pass);
if (user != null)
{
o = "sign in";
Session["name"] = email;
}
}
catch (Exception e)
{
if (email == "admin@admin" && pass == "admin")
{
Session["id"] = "Admin";
return(RedirectToAction("Home", "Admin"));
}
}
return(RedirectToAction("Index", "User"));
}
public ActionResult viewRequest()
{
var db = new DB3();
var request = db.Requests.Include("Book");
return(View(request));
}
public Category updateCategory(Category c, int id)
{
var db = new DB3();
var result = db.Category.Single(i => i.Id == id);
return(result);
}
public IQueryable viewrecords(string email)
{
var db = new DB3();
var req = db.Requests.Where(x => x.email.Equals(email));
return(req);
}
public void signup(signup s)
{
var db = new DB3();
db.signup.Add(s);
db.SaveChanges();
}
public IQueryable addbooks()
{
var obj = new DB3();
var result = from Category in obj.Category select Category;
return(result);
}
public void rejected(int id)
{
var db = new DB3();
db.Requests.First(x => x.Id.Equals(id)).status = "Rejected";
db.SaveChanges();
}
public IQueryable viewuser()
{
var obj = new DB3();
var result = from signup in obj.signup select signup;
return(result);
}
public IQueryable vrecords()
{
var db = new DB3();
var req = from x in db.Requests select x;
return(req);
}
public void savaCategories(Category c)
{
var obj = new DB3();
obj.Category.Add(c);
obj.SaveChanges();
}
public IQueryable view()
{
var obj = new DB3();
var result = from cat in obj.Category select cat;
return(result);
}
internal static ConnectionKey CreateMapKey(DB3 databaseID)
{
var connKey = new ConnectionKey(0);
connKey._iKey = -databaseID.DbX;
return(connKey);
}
internal GraphPair(DB3 foreignKeyID, DB3 referenceID, int foreignKeyRX, int referenceRX)
{
ForeignKeyID = foreignKeyID;
ReferenceID = referenceID;
ForeignKeyRX = foreignKeyRX;
ReferenceRX = referenceRX;
}
public void deleted(int id)
{
var db = new DB3();
Requests r = db.Requests.Single(u => u.Id == id);
db.Requests.Remove(r);
db.SaveChanges();
}
public void accepted(int id)
{
var db = new DB3();
db.Requests.First(x => x.Id.Equals(id)).status = "Accepted";
db.Requests.First(x => x.Id.Equals(id)).issue_date = DateTime.Now;
db.SaveChangesAsync();
}
private Plc()
{
Db3 = new DB3();
timer.Interval = 1; // ms
timer.Elapsed += timer_Elapsed;
timer.Enabled = true;
lastReadTime = DateTime.Now;
}
public ActionResult reject()
{
int id = Int32.Parse(Request["p"]);
var db = new DB3();
data.rejected(id);
return(RedirectToAction("viewRequest"));
}
public ActionResult accept()
{
var db = new DB3();
int id = Int32.Parse(Request["p"]);
data.accepted(id);
return(RedirectToAction("viewRequest"));
}
//
// GET: /UserViewStatus/
public ActionResult viewStatus()
{
var db = new DB3();
var request = db.Requests.Include("Book");
// var all = from books in get.Book select books;
// ViewBag.display = books;
return(View(request));
}
public void updatedCategory(Category c, int id)
{
var db = new DB3();
var result = db.Category.Single(i => i.Id == id);
result.name = c.name;
result.Id = id;
db.SaveChanges();
}
public ActionResult viewDetails()
{
var p = Int32.Parse(Request["p"]);
var obj = new DB3();
var result = from signup in obj.signup where signup.Id == p select signup;
ViewBag.a = result;
return(View());
}
public void request(string email, int id)
{
var obj = new DB3();
Requests r = new Requests();
r.email = email;
r.book_id = id;
r.status = "Pending";
obj.Requests.Add(r);
obj.SaveChanges();
}
public ActionResult update()
{
int id = Int32.Parse(Request["p"]);
var db = new DB3();
var ubook = from b in db.Book where b.Id == id select b;
var result = db.Book.Include("Category");
ViewBag.a = result;
return(View(ubook));
}
public void delete()
{
int id = Int32.Parse(Request["p"]);
var db = new DB3();
//var result = db.Book.Include("Category").FirstOrDefault(u => u.catId == id);
//db.Book.Remove(result);
var result1 = db.Category.FirstOrDefault(u => u.Id == id);
db.Category.Remove(result1);
//db.SaveChanges();
}
public void updateBooks(Book b, int id)
{
// int cat = Int32.Parse(Request["p1"]);
var db = new DB3();
var result = db.Book.Single(i => i.Id == id);
result.cname = b.cname;
result.isbn = b.isbn;
result.catId = result.catId;
db.SaveChanges();
}
public void saveBooks(string cname, string isbn, string catName)
{
var obj = new DB3();
var cat = from bb in obj.Category where bb.name == catName select bb;
Book b = new Book();
b.cname = cname;
b.isbn = isbn;
b.catId = cat.First().Id;
// b.catId = Int32.Parse(catId);
obj.Book.Add(b);
obj.SaveChanges();
}
public ActionResult Import(HttpPostedFileBase jsonFile)
{
if (jsonFile == null || !Path.GetFileName(jsonFile.FileName).EndsWith(".json"))
{
ViewBag.Error = "Invalid file type";
}
else
{
jsonFile.SaveAs(Server.MapPath("~/JSONFiles/" + Path.GetFileName(jsonFile.FileName)));
StreamReader streamReader = new StreamReader(Server.MapPath("~/JSONFiles/" + Path.GetFileName(jsonFile.FileName)));
string data = streamReader.ReadToEnd();
List <Vol> vols = JsonConvert.DeserializeObject <List <Vol> >(data);
vols.ForEach(v =>
{
Vol vol = new Vol()
{
Numero = v.Numero,
Heure_Depart = v.Heure_Depart,
Heure_Arrivee = v.Heure_Arrivee,
Id_Date_Depart = v.Id_Date_Depart,
Id_Date_Arrivee = v.Id_Date_Arrivee,
Code_CompAerien = v.Code_CompAerien,
Code_IATA_Aeroport_Arrivee = v.Code_IATA_Aeroport_Arrivee,
Code_IATA_Aeroport_Depart = v.Code_IATA_Aeroport_Depart,
};
if (DB3.Aeroport().Vols != null && DB3.Aeroport().Vols.Find(vol.Numero, vol.Id_Date_Depart) == null)
{
DB3.Aeroport().Vols.Add(vol);
DB3.Aeroport().SaveChanges();
}
});
ViewBag.Success = "Success";
}
return(View("Charger_calendrier", "~/Views/Shared/_AdminLayout.cshtml", null));
}
// public ActionResult delete()
public string delete()
{
int id = Int32.Parse(Request["p"]);
int id1 = Int32.Parse(Request["p1"]);
var db = new DB3();
using (var conn = new DB3())
{
// return one instance each entity by primary key
var product = conn.Book.FirstOrDefault(p => p.Id == id);
// call Remove method from navigation property for any instance
// supplier.Product.Remove(product);
// also works
//product.Supplier.Remove(supplier);
conn.Book.Remove(product);
// call SaveChanges from context
conn.SaveChangesAsync();
}
//var all = from b in db.Book where b.Id == id select b;
//Book r = db.Book.Single(u => u.Id == id);
//r.catId = null;
//foreach(Book bb in all)
//{ db.Book.Remove(bb);
//Book r = db.Book.Single(u => u.Id == id);
//AdventureWorksEntities context = new AdventureWorksEntities();
//db.Book.Remove(r);
//}
return(id + " :" + id1);
//return RedirectToAction("viewBooks");
}
