public IActionResult Edit(string workerid)
{
var viewModels = new ViewModel.WorkersViewModel
{
Roles = Roles()
};
using (SqlConnection sqlconnection = new SqlConnection(_connection))
{
sqlconnection.Open();
string query = "SELECT R.Id,R.Name,W.Id,W.Name,W.Surname,W.Gender,W.TcNo,W.DateOfBirth,W.Tel,W.Mail,W.UserName,W.Password FROM Roles AS R INNER JOIN Workers AS W On (R.Id=W.RoleId) WHERE W.Id = '" + workerid + "'";
SqlCommand sqlCommand = new SqlCommand(query, sqlconnection);
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
sqlDataReader.Read();
viewModels.RoleId = Convert.ToInt32(sqlDataReader[0].ToString());
viewModels.Id = Convert.ToInt32(sqlDataReader[2].ToString());
viewModels.Name = sqlDataReader[3].ToString();
viewModels.Surname = sqlDataReader[4].ToString();
viewModels.Gender = sqlDataReader[5].ToString();
viewModels.TcNo = sqlDataReader[6].ToString();
viewModels.DateOfBirth = DateTime.Parse(sqlDataReader[7].ToString());
viewModels.Tel = sqlDataReader[8].ToString();
viewModels.Mail = sqlDataReader[9].ToString();
viewModels.UserName = sqlDataReader[10].ToString();
viewModels.Password = sqlDataReader[11].ToString();
}
return(View(viewModels));
}
}
public IActionResult Add()
{
var viewModel = new ViewModel.WorkersViewModel
{
Roles = Roles()
};
return(View(viewModel));
}
