private void VeranderInfoLijst()
{
//VolledigeLijst = await servicelayer.getKassas();
Info = new ObservableCollection <Register_Employee>();
if (Selected == "System.Windows.Controls.ComboBoxItem: Medewerker")
{
foreach (Register_Employee reg in VolledigeLijst)
{
if (reg.Medewerker.Name == SelectedList)
{
Info.Add(reg);
}
}
}
else
{
foreach (Register_Employee reg in VolledigeLijst)
{
if (reg.Kassa.Registername == SelectedList)
{
Register_Employee emp = reg;
emp.Kassa.Registername = reg.Medewerker.Name;
Info.Add(emp);
}
}
}
}
public static void Register_EmployerInvullen()
{
reg_emp = new Register_Employee();
reg_emp.Kassa = register;
reg_emp.Medewerker = ingelogdeMedewerker;
reg_emp.From = DateTime.Now;
}
public static void AddRegisterEmployee(Register_Employee r)
{
string sql = "INSERT INTO Register_Employee VALUES(@RegisterID, @EmployeeID, @Vanaf, @Until)";
DbParameter par1 = Database.AddParameter("ConnectionString", "@RegisterID", r.RegisterID);
DbParameter par2 = Database.AddParameter("ConnectionString", "@EmployeeID", r.EmployeeID);
DbParameter par3 = Database.AddParameter("ConnectionString", "@Vanaf", DateTimeToUnixTimeStamp(r.Vanaf));
DbParameter par4 = Database.AddParameter("ConnectionString", "@Until", DateTimeToUnixTimeStamp(r.Until));
Database.InsertData("ConnectionString", sql, par1, par2, par3, par4);
}
public static async Task <Boolean> SaveReg_Emp(Register_Employee reg_emp)
{
using (HttpClient client = new HttpClient())
{
client.SetBearerToken(ApplicationVM.token.AccessToken);
string json = JsonConvert.SerializeObject(reg_emp);
HttpResponseMessage resp = await client.PostAsync(baseUrl + "/register", new StringContent(json, Encoding.UTF8, "application/json"));
return(resp.IsSuccessStatusCode);
}
}
public static int SaveLogin(Register_Employee newLogin, IEnumerable <Claim> claims)
{
string sql = "INSERT INTO Register_Employee VALUES(@RegisterID,@EmployeeID,@FromTime,@UntilTime)";
DbParameter par1 = Database.AddParameter("ConnectionString", "@RegisterID", newLogin.RegisterID.RegisterID);
DbParameter par2 = Database.AddParameter("ConnectionString", "@EmployeeID", newLogin.EmployeeID.ID);
DbParameter par3 = Database.AddParameter("ConnectionString", "@FromTime", newLogin.From);
DbParameter par4 = Database.AddParameter("ConnectionString", "@UntilTime", newLogin.Until);
int id = Database.InsertData(Database.GetConnection(CreateConnectionString(claims)), sql, par1, par2, par3, par4);
return(id);
}
public static int AddRegister(Register_Employee register, IEnumerable <Claim> claims)
{
DbConnection con = GetConnection(claims);
string sql = "INSERT INTO Register_employee (RegisterId, EMployeeId, FromTime, UntilTime) VALUES (@Register,@Employe, @from, @until)";
DbParameter par1 = Database.AddParameter("System.Data.SqlClient", "@Register", register.Kassa.Id);
DbParameter par2 = Database.AddParameter("System.Data.SqlClient", "@Employe", register.Medewerker.Id);
DbParameter par3 = Database.AddParameter("System.Data.SqlClient", "@from", DateTimeToTimestamp(register.From));
DbParameter par4 = Database.AddParameter("System.Data.SqlClient", "@until", DateTimeToTimestamp(register.Until));
return(Database.InsertData(con, sql, par1, par2, par3, par4));
}
private void LogOut()
{
Until = DateTime.Now;
Register_Employee r = new Register_Employee();
r.RegisterID = registerID;
r.EmployeeID = EmployeeID;
r.Vanaf = From;
r.Until = Until;
InsertRegisterEmployeeIntoDB(r);
}
public static List <Register_Employee> GetListRegisters(IEnumerable <Claim> claims)
{
DbConnection con = GetConnection(claims);
List <Register_Employee> lijst = new List <Register_Employee>();
DbDataReader reader = Database.GetData(con, "Select reem.UntilTime, reem.FromTime,emp.Address, emp.Email, emp.EmployeeName,emp.Id,emp.Phone, reg.Device,reg.Id as 'regId',reg.Registername from dbo.Register_Employee reem left outer join dbo.Employee emp on reem.EmployeeId = emp.Id left outer join dbo.Registers reg on reem.RegisterId = reg.Id");
while (reader.Read())
{
Register_Employee re = CreateRegister_Employee(reader);
lijst.Add(re);
}
return(lijst);
}
private async void Logout()
{
Register_Employee newLogin = new Register_Employee();
newLogin.EmployeeID = GekozenEmployee;
newLogin.From = From;
newLogin.Until = DateTime.Now;
newLogin.RegisterID = GekozenKassa;
await SaveLogin(newLogin);
token = null;
ChangePage(new PageOneVM());
MenuVisibility = false;
}
public async Task <int> SaveLogin(Register_Employee newLogin)
{
using (HttpClient client = new HttpClient())
{
client.SetBearerToken(ApplicationVM.token.AccessToken);
string url = string.Format("{0}{1}", URL, "/RegisterEmployee");
string json = JsonConvert.SerializeObject(newLogin);
HttpResponseMessage response = await client.PostAsync(url, new StringContent(json, Encoding.UTF8, "application/json"));
if (response.IsSuccessStatusCode)
{
return(1);
}
else
{
return(0);
}
}
}
private async void InsertRegisterEmployeeIntoDB(Register_Employee r)
{
using (HttpClient client = new HttpClient())
{
string re = JsonConvert.SerializeObject(r);
HttpResponseMessage response = await
client.PostAsync("http://localhost:65079/api/RegisterEmployee", new StringContent(re,
Encoding.UTF8, "application/json"));
if (response.IsSuccessStatusCode)
{
ApplicationVM appvm = App.Current.MainWindow.DataContext as ApplicationVM;
appvm.ChangePage(new LoginVM());
}
else
{
MakeErrorLog("Couldn't add register employee to db", mname, "InsertRegisterEmployeeIntoDB");
}
}
}
public HttpResponseMessage Post(Register_Employee newRegister)
{
try
{
if (newRegister == null)
{
throw new HttpResponseException(AddRequest(HttpStatusCode.BadRequest, "parameter is empty"));
}
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int id = RegisterDA.AddRegister(newRegister, p.Claims);
HttpResponseMessage response = new HttpResponseMessage();
string url = string.Format("{0}{1}", HttpContext.Current.Request.Url.ToString(), id);
response.Headers.Location = new Uri(url);
response.StatusCode = HttpStatusCode.Created;
return(response);
}
catch
{
return(new HttpResponseMessage(HttpStatusCode.InternalServerError));
}
}
public HttpResponseMessage Post(Register_Employee r)
{
Register_EmployeeDA.AddRegisterEmployee(r);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
public int Post(Register_Employee newLogin)
{
ClaimsPrincipal p = Request.GetRequestContext().Principal as ClaimsPrincipal;
return(RegisterEmployeeDA.SaveLogin(newLogin, p.Claims));
}