/// <summary>
/// Remove auto
/// </summary>
/// <param name="number">Number of the auto to delete</param>
public void RemoveAuto(string number)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.Auto.DeleteObject(context.Auto.First(o => o.Number == number));
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
}
/// <summary>
/// Create new department
/// </summary>
/// <param name="department">Department to add</param>
public Guid CreateDepartment(Department department)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
department.Id = Guid.NewGuid();
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.AddToDepartment(department);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
return(department.Id);
}
public void RemoveEmployeProfile(Guid guid)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.Employee.DeleteObject(context.Employee.First(o => o.Id == guid));
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
}
/// <summary>
/// Remove damages
/// </summary>
/// <param name="id">Id of the damages to delete</param>
public void RemoveDamages(int id)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.Damages.DeleteObject(context.Damages.First(o => o.Id == id));
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
}
/// <summary>
/// Create new customer profile
/// </summary>
/// <param name="employee">Added customer</param>
public Guid CreateCustomerProfile(Customer customer)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
customer.Id = Guid.NewGuid();
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.AddToCustomer(customer);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
return(customer.Id);
}
/// <summary>
/// Create new employee profile
/// </summary>
/// <param name="employee">Added employee</param>
public Guid CreateEmployeProfile(Employee employee)
{
AutoRentEntities context = new AutoRentEntities();
DbTransaction transaction = null;
try
{
employee.Id = Guid.NewGuid();
context.Connection.Open();
transaction = context.Connection.BeginTransaction();
context.AddToEmployee(employee);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
finally
{
context.Connection.Close();
}
return(employee.Id);
}
public List <Members> UsersInRole(string roleName)
{
AutoRentEntities context = new AutoRentEntities();
return(context.Roles.First(o => o.Name == roleName).Members.ToList());
}
public List <PermissionRule> ListObjPermRulles()
{
AutoRentEntities context = new AutoRentEntities();
return(context.PermissionRule.Select(o => o).ToList());
}
public bool Authorize(string login, string passwd)
{
AutoRentEntities context = new AutoRentEntities();
return(context.Members.Any(o => o.Lock == false && o.Login == login && o.Password == passwd));
}