public ActionResult tabla()
{
// Carga de Datos predeterminados.
Workers w = new Models.Workers();
// Definir los codigos de los empleados.
w.code[0] = 01;
w.code[1] = 02;
w.code[2] = 03;
w.code[3] = 04;
w.code[4] = 05;
// Definir los nombres de los empleados.
w.name[0] = "Jeremy Zelaya";
w.name[1] = "Susan Solano";
w.name[2] = "Tamara Richards";
w.name[3] = "Julian Rodriguez";
w.name[4] = "Angeles Rostran";
// Definir los roles de los empleados.
w.role[0] = "IT";
w.role[1] = "Proyect Manager";
w.role[2] = "Equipment Maintenance";
w.role[3] = "Production Supervisor";
w.role[4] = "Accountant";
// Definir los salarios de los empleados.
w.salary[0] = 1500000;
w.salary[1] = 2000000;
w.salary[2] = 1200000;
w.salary[3] = 1500000;
w.salary[4] = 1750000;
return(View(w));
}
private Workers AddEdit(int?id, Models.Workers worker, string confirmPassword)
{
string query;
if (id.HasValue)
{
//Düzenle
query = "UPDATE Workers SET RoleId=@p1,Name=@p2,Surname=@p3,Gender=@p4,TcNo=@p5,DateOfBirth=@p6,Tel=@p7,Mail=@p8,UserName=@p9,Password=@p10 WHERE Id = " + id.Value + "";
}
else
{
//Ekleme
query = "INSERT INTO Workers(RoleId,Name,Surname,Gender,TcNo,DateOfBirth,Tel,Mail,UserName,Password) VALUES (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9,@p10)";
}
using (SqlConnection sqlconnection = new SqlConnection(_connection))
{
var pass = IsPasswordConfirm(worker.Password, confirmPassword);
var name = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(worker.Name);
var surname = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(worker.Surname);
if (pass)
{
sqlconnection.Open();
SqlCommand sqlCommand = new SqlCommand(query, sqlconnection);
sqlCommand.Parameters.AddWithValue("@p1", worker.RoleId);
sqlCommand.Parameters.AddWithValue("@p2", name);
sqlCommand.Parameters.AddWithValue("@p3", surname);
sqlCommand.Parameters.AddWithValue("@p4", worker.Gender);
sqlCommand.Parameters.AddWithValue("@p5", worker.TcNo);
sqlCommand.Parameters.AddWithValue("@p6", worker.DateOfBirth);
sqlCommand.Parameters.AddWithValue("@p7", worker.Tel);
sqlCommand.Parameters.AddWithValue("@p8", worker.Mail);
sqlCommand.Parameters.AddWithValue("@p9", worker.UserName);
sqlCommand.Parameters.AddWithValue("@p10", worker.Password);
sqlCommand.ExecuteNonQuery();
sqlconnection.Close();
}
}
return(worker);
}
public IActionResult Add(Models.Workers worker, string confirmPassword)
{
AddEdit(null, worker, confirmPassword);
return(RedirectToAction("Index"));
}