// [ValidateAntiForgeryToken]
public ActionResult Details(EmployeeDetailsViewItem EmployeeDetails, string id, string Lastname, string LastName)
{
try
{
//context.Entry(Roles).State = System.Data.Entity.EntityState.Modified;
//context.SaveChanges();
_dbq.ChangeRole(id, EmployeeDetails.RoleName);
if (EmployeeDetails.ShiftGroupPartnerName == null)
{
return RedirectToAction("Index");
}
if (_dbq.CheckForShiftgroup(id) == true)
{
_dbq.DeleteShiftGroup(id);
}
ShiftGroup UpdateShiftGroup = new ShiftGroup(EmployeeDetails.ShiftGroupPartnerName, id);
_dbq.InsertNewShiftgroup(UpdateShiftGroup);
EmployeeDetails.UserId = id;
_dbq.UpdateEmployeebyDetail(EmployeeDetails);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public Boolean UpdateEmployeebyDetail(EmployeeDetailsViewItem Emp)
{
int ShiftGroupIdtmp = SelectShiftGroupId(Emp.UserId);
bool Result = false;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"UPDATE dbo.AspNetUsers SET UserName = @UserName, FirstName = @FirstName, LastName = @LastName, Email = @EMail, ShiftGroupID = @ShiftGroupId WHERE Id = @Id";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("UserName", Emp.UserName);
cmd.Parameters.AddWithValue("FirstName", Emp.FirstName);
cmd.Parameters.AddWithValue("LastName", Emp.LastName);
cmd.Parameters.AddWithValue("Email", Emp.Email);
cmd.Parameters.AddWithValue("ShiftGroupId", ShiftGroupIdtmp);
cmd.Parameters.AddWithValue("Id", Emp.UserId);
try
{
connection.Open();
cmd.ExecuteNonQuery();
Result = true;
}
catch (SqlException e)
{
{
Result = false;
}
}
}
}
return Result;
}
public void SelectEmployeebyDetailsById()
{
string id = "bff0f95a-5b1a-42cc-a1cc-8f520477c37a";
EmployeeDetailsViewItem emp;
string Idtmp = "";
string Usernametmp = "";
string FirstNametmp = "";
string LastNametmp = "";
string Emailtmp = "";
string RoleName = "";
string ShiftGroupPartnerName = "";
string DivisonName = "";
int ShiftGroupIDtmp = 0;
int DivisionIDtmp = 0;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"SELECT UserName, FirstName, LastName, Email, ShiftGroupID, DivisionID FROM [dbo].AspNetUsers WHERE Id= @EmployeeID";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("EmployeeID", "1e04bd54-4fb8-4bb8-806c-8ad7b8c90c43");
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
// Check if the reader has any rows at all before starting to read.
if (reader.HasRows)
{
// Read advances to the next row.
// Save DB-Return into variables
while (reader.Read())
{
Usernametmp = reader.GetString(reader.GetOrdinal("UserName"));
FirstNametmp = reader.GetString(reader.GetOrdinal("FirstName"));
LastNametmp = reader.GetString(reader.GetOrdinal("LastName"));
Emailtmp = reader.GetString(reader.GetOrdinal("Email"));
if (reader.IsDBNull(reader.GetOrdinal("ShiftGroupID")))
//Test, ob ID NULL, wenn ja ID = 0
{
ShiftGroupIDtmp = 0;
}
else
{
ShiftGroupIDtmp = reader.GetInt32(reader.GetOrdinal("ShiftGroupID"));
}
RoleName = "Admnistrator";
ShiftGroupPartnerName = "Tim Nicolaisen";
DivisionIDtmp = reader.GetInt32(reader.GetOrdinal("DivisionID"));
emp = new EmployeeDetailsViewItem(Idtmp, Usernametmp, FirstNametmp,
LastNametmp, Emailtmp, RoleName, ShiftGroupPartnerName, "");
}
}
else
{
}
}
}
}
}
public EmployeeDetailsViewItem SelectEmployeebyDetailsById(string id)
{
EmployeeDetailsViewItem emp;
string Idtmp = "";
string Usernametmp = "";
string FirstNametmp = "";
string LastNametmp = "";
string Emailtmp = "";
string RoleName = "";
string ShiftGroupPartnerId = "";
string ShiftGroupPartnerName = "";
string DivisonName = "";
int ShiftGroupIDtmp = 0;
int DivisionIDtmp = 0;
using (SqlConnection connection = new SqlConnection(sqlConnectionString))
{
string sqlStatement =
"SELECT [Id], [UserName], [FirstName], [LastName], [Email], [ShiftGroupID], [DivisionID] FROM dbo.AspNetUsers WHERE Id='" + id + "'";
using (SqlCommand cmd = new SqlCommand(sqlStatement, connection))
{
cmd.Parameters.AddWithValue("EmployeeID", id);
connection.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
// Check if the reader has any rows at all before starting to read.
if (reader.HasRows)
{
while (reader.Read())
{
Usernametmp = reader.GetString(reader.GetOrdinal("UserName"));
FirstNametmp = reader.GetString(reader.GetOrdinal("FirstName"));
LastNametmp = reader.GetString(reader.GetOrdinal("LastName"));
Emailtmp = reader.GetString(reader.GetOrdinal("Email"));
if (reader.IsDBNull(reader.GetOrdinal("ShiftGroupID")))
//Test, ob ID NULL, wenn ja ID = 0
{
ShiftGroupIDtmp = 0;
}
else
{
ShiftGroupIDtmp = reader.GetInt32(reader.GetOrdinal("ShiftGroupID"));
}
RoleName = SelectRole(id);
ShiftGroupPartnerId= SelectShiftPartner(id);
if (ShiftGroupPartnerId == null)
{
ShiftGroupPartnerName = "Keine Schichtgruppe";
}
else
{
ShiftGroupPartnerName = SelectEmployeeFullName(ShiftGroupPartnerId);
}
DivisionIDtmp = reader.GetInt32(reader.GetOrdinal("DivisionID"));
emp = new EmployeeDetailsViewItem(Idtmp, Usernametmp, FirstNametmp,
LastNametmp, Emailtmp, RoleName, ShiftGroupPartnerName, "");
return emp;
}
}
else
{
return null;
}
}
return null;
}
}
}