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); }