public static void AssignLoginToNewEmp(AssignLoginToNewEmp_EL e)
{
using (SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-8HC3KF0;Initial Catalog=ALMS;Integrated Security=True;"))
{
SqlCommand cmd = new SqlCommand
{
CommandText = "spAddNewLogin",
Connection = con,
CommandType = CommandType.StoredProcedure
};
//passing values to sql parameter
cmd.Parameters.AddWithValue("@UserName", e.UserName);
cmd.Parameters.AddWithValue("@Pass", e.Pass);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
}
public static AssignLoginToNewEmp_EL AssignLoginToNewEmpInput()
{
Console.WriteLine("Enter UserName and Password for this Employee");
AssignLoginToNewEmp_EL altne = new AssignLoginToNewEmp_EL
{
UserName = Console.ReadLine(),
Pass = Console.ReadLine()
};
return(altne);
}
