public ActionResult Index()
{
DirectoryDataSet ds = new DirectoryDataSet();
employeeTableAdapter da = new employeeTableAdapter();
da.Fill(ds.employee);
return(View("AdoNetIndex", ds.employee));
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
departmentsTableAdapter dadeps = new departmentsTableAdapter();
dadeps.Update(ds.departments);
employeeTableAdapter daemps = new employeeTableAdapter();
daemps.Update(ds.employee);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
departmentsTableAdapter dadeps = new departmentsTableAdapter();
ds = new DataSet2();
dadeps.Fill(ds.departments);
dgdept.ItemsSource = ds.departments.DefaultView;
employeeTableAdapter daemps = new employeeTableAdapter();
daemps.Fill(ds.employee);
dgData.ItemsSource = ds.employee.DefaultView;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
{
txtOrderDateLow.Text = DateTime.Now.Date.AddDays(-7).ToString("yyyy-MM-dd");
txtOrderDateHigh.Text = DateTime.Now.Date.ToString("yyyy-MM-dd");
employeeTableAdapter daEmp = new employeeTableAdapter();
daEmp.Fill(dsEmp.employee);
foreach (DataRow r in dsEmp.employee)
{
MakeTable(r);
}
}
}
public void ValidatePassword(string connectionString, string password, out string opName, out string opCode, out string error)
{
opName = "";
opCode = "";
error = "";
try
{
using (var eta = new employeeTableAdapter())
{
eta.Connection.ConnectionString = connectionString;
dsLogon.employeeDataTable edt = eta.GetData(password);
if (edt.Rows.Count > 0)
{
opName = edt[0].name;
opCode = edt[0].operator_code;
}
}
}
catch (SqlException ex)
{
if (ex.InnerException != null)
{
error = "Sql Exception: " + ex.InnerException.ToString();
}
else
{
error = "Sql Exception: " + ex.Message;
}
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
error = "Exception: " + ex.InnerException.ToString();
}
else
{
error = "Exception: " + ex.Message;
}
}
}
static Purchase()
{
receiptTableAdapter daReceipt = new receiptTableAdapter();
daReceipt.Fill(dsReceipt.receipt);
employeeTableAdapter daEmployee = new employeeTableAdapter();
daEmployee.Fill(dsReceipt.employee);
productTableAdapter daProducts = new productTableAdapter();
productTable = daProducts.GetData();
order_lineTableAdapter daLine = new order_lineTableAdapter();
daLine.Fill(dsReceipt.order_line);
service_orderTableAdapter daService = new service_orderTableAdapter();
daService.Fill(dsReceipt.service_order);
equipmentTableAdapter daEqu = new equipmentTableAdapter();
daEqu.Fill(dsReceipt.equipment);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string search = "empFull LIKE '%" + txtName.Text + "%' AND posName LIKE '%" + ((ddlPosition.SelectedIndex > 0) ? ddlPosition.SelectedItem.Text : "") + "%'";
employeeTableAdapter daEmp = new employeeTableAdapter();
try
{
daEmp.Fill(dsEmp.employee);
}
catch { }
//Execute where clause
DataRow[] rows = dsEmp.employee.Select(search);
//display results
foreach (DataRow r in rows)
{
MakeTable(r);
}
}
static Repair_Details()
{
employeeTableAdapter daEmployees = new employeeTableAdapter();
employees = daEmployees.GetData();
}
static Login()
{
var roleStore = new RoleStore <IdentityRole>();
var roleManager = new RoleManager <IdentityRole>(roleStore);
var userStore = new UserStore <IdentityUser>();
var userManager = new UserManager <IdentityUser>(userStore);
positionTableAdapter daPositions = new positionTableAdapter();
employeeTableAdapter daEmployees = new employeeTableAdapter();
DataTable posTable = daPositions.GetData();
EmmasEnginesLibrary.EmployeeDataSet dsEmployee = new EmmasEnginesLibrary.EmployeeDataSet();
daEmployees.Fill(dsEmployee.employee);
foreach (DataRow r in posTable.Rows)
{
if (!roleManager.RoleExists(r["posName"].ToString()))
{
if (!roleManager.Create(new IdentityRole(r["posName"].ToString())).Succeeded)
{
throw new Exception("Failed to create role " + r["posName"].ToString());
}
}
}
string userName;
string position = "";
foreach (DataRow r in dsEmployee.employee.Rows)
{
userName = r["empLogin"] != DBNull.Value? r["empLogin"].ToString() : r["empFirst"].ToString().ToLower()[0] + r["empLast"].ToString().ToLower() + r["id"].ToString();
if (r["posID"] != DBNull.Value)
{
position = posTable.Select("id = " + r["posID"].ToString())[0]["posName"].ToString();
}
IdentityUser user = userManager.FindByName(userName);
if (user == null)
{
user = new IdentityUser(userName);
if (!userManager.Create(user, "password").Succeeded)
{
throw new Exception("Failed to register user " + userName);
}
}
r["loginId"] = userManager.FindByName(userName).Id;
r["empLogin"] = userName;
if (user.Roles.Count == 0 && !String.IsNullOrEmpty(position))
{
userManager.AddToRole(user.Id, position);
}
if (user.Roles.Count > Convert.ToInt32(!String.IsNullOrEmpty(position)))
{
foreach (DataRow pr in posTable.Rows)
{
if (pr["posName"].ToString() != position && userManager.IsInRole(user.Id, pr["posName"].ToString()))
{
userManager.RemoveFromRole(user.Id, pr["posName"].ToString());
}
}
}
}
daEmployees.Update(dsEmployee.employee);
dsEmployee.AcceptChanges();
}
static Default()
{
employeeTableAdapter daEmployees = new employeeTableAdapter();
employees = daEmployees.GetData();
}