public void AddTva(Tvas tva)
{
using (new NotesDeFraisEntities())
{
e.Tvas.Add(tva);
e.SaveChanges();
}
}
public void AddCostumers(Customers cust)
{
using (new NotesDeFraisEntities())
{
e.Customers.Add(cust);
e.SaveChanges();
}
}
public void AddEmployes(Employees emp)
{
using (new NotesDeFraisEntities())
{
e.Employees.Add(emp);
e.SaveChanges();
}
}
public void AddProjet(Projects projet)
{
using (new NotesDeFraisEntities())
{
e.Projects.Add(projet);
e.SaveChanges();
}
}
public void AddPoles(Poles pole)
{
using (new NotesDeFraisEntities())
{
e.Poles.Add(pole);
e.SaveChanges();
}
}
public void AddExpanseType(ExpanseTypes expanseType)
{
using (new NotesDeFraisEntities())
{
e.ExpanseTypes.Add(expanseType);
e.SaveChanges();
}
}
public void AddExpansesReports(ExpanseReports exp)
{
using (new NotesDeFraisEntities())
{
e.ExpanseReports.Add(exp);
e.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "Id,Name")] AspNetRoles aspNetRoles)
{
if (ModelState.IsValid)
{
db.AspNetRoles.Add(aspNetRoles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetRoles));
}
public ActionResult Create([Bind(Include = "MigrationId,ContextKey,Model,ProductVersion")] C__MigrationHistory c__MigrationHistory)
{
if (ModelState.IsValid)
{
db.C__MigrationHistory.Add(c__MigrationHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(c__MigrationHistory));
}
public ActionResult Create([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName")] AspNetUsers aspNetUsers)
{
if (ModelState.IsValid)
{
db.AspNetUsers.Add(aspNetUsers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetUsers));
}
public ActionResult Create([Bind(Include = "LoginProvider,ProviderKey,UserId")] AspNetUserLogins aspNetUserLogins)
{
if (ModelState.IsValid)
{
db.AspNetUserLogins.Add(aspNetUserLogins);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetUserLogins.UserId);
return(View(aspNetUserLogins));
}
public ActionResult Create([Bind(Include = "Id,UserId,ClaimType,ClaimValue")] AspNetUserClaims aspNetUserClaims)
{
if (ModelState.IsValid)
{
db.AspNetUserClaims.Add(aspNetUserClaims);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Email", aspNetUserClaims.UserId);
return(View(aspNetUserClaims));
}
public ActionResult Create([Bind(Include = "Customer_ID,Name,Code")] Customers customers)
{
if (ModelState.IsValid)
{
customers.Customer_ID = Guid.NewGuid();
db.Customers.Add(customers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customers));
}
public ActionResult Create([Bind(Include = "TVA_ID,Name,Value")] Tvas tvas)
{
if (ModelState.IsValid)
{
tvas.TVA_ID = Guid.NewGuid();
db.Tvas.Add(tvas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tvas));
}
public ActionResult Create([Bind(Include = "ExpenseType_ID,Name,Ceiling,Fixed,OnlyManagers,Tva_ID")] ExpanseTypes expanseTypes)
{
if (ModelState.IsValid)
{
expanseTypes.ExpenseType_ID = Guid.NewGuid();
db.ExpanseTypes.Add(expanseTypes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Tva_ID = new SelectList(db.Tvas, "TVA_ID", "Name", expanseTypes.Tva_ID);
return(View(expanseTypes));
}
public ActionResult Create([Bind(Include = "ExpanseReport_ID,Employee_ID,Author_ID,CreationDate,Year,Month,StatusCode,ManagerValidationDate,AccountingValidatationDate,Total_HT,Total_TVA,Total_TTC,ManagerComment,AccountingComment")] ExpanseReports expanseReports)
{
if (ModelState.IsValid)
{
expanseReports.ExpanseReport_ID = Guid.NewGuid();
db.ExpanseReports.Add(expanseReports);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Employee_ID = new SelectList(db.Employees, "Employee_ID", "User_ID", expanseReports.Employee_ID);
ViewBag.Author_ID = new SelectList(db.Employees, "Employee_ID", "User_ID", expanseReports.Author_ID);
return(View(expanseReports));
}
public ActionResult Create([Bind(Include = "Project_ID,Name,Description,Budget,Customer_ID,Pole_ID")] Projects projects)
{
if (ModelState.IsValid)
{
projects.Project_ID = Guid.NewGuid();
db.Projects.Add(projects);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Customer_ID = new SelectList(db.Customers, "Customer_ID", "Name", projects.Customer_ID);
ViewBag.Pole_ID = new SelectList(db.Poles, "Pole_ID", "Name", projects.Pole_ID);
return(View(projects));
}
public ActionResult Create([Bind(Include = "Expanse_ID,ExpanseReport_ID,Day,ExpanseType_ID,Customer_ID,Project_ID,Amount_HT,Amount_TVA,Amount_TTC")] Expanses expanses)
{
if (ModelState.IsValid)
{
expanses.Expanse_ID = Guid.NewGuid();
db.Expanses.Add(expanses);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Customer_ID = new SelectList(db.Customers, "Customer_ID", "Name", expanses.Customer_ID);
ViewBag.ExpanseReport_ID = new SelectList(db.ExpanseReports, "ExpanseReport_ID", "ManagerComment", expanses.ExpanseReport_ID);
ViewBag.ExpanseType_ID = new SelectList(db.ExpanseTypes, "ExpenseType_ID", "Name", expanses.ExpanseType_ID);
ViewBag.Project_ID = new SelectList(db.Projects, "Project_ID", "Name", expanses.Project_ID);
return(View(expanses));
}
public void addRoles(AspNetRoles role)
{
using (new NotesDeFraisEntities())
{
e.AspNetRoles.Add(role);
e.SaveChanges();
}
}
public void Save()
{
Entities.SaveChanges();
}