public Order_ManagerDTO GetOrder_ManagerById(int O_M_id) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); Order_ManagerDTO Order_Manager = new Order_ManagerDTO(); comm.CommandText = $"select * from Order_Manager where O_M_id=@O_M_id"; comm.Parameters.AddWithValue("@O_M_id", O_M_id); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { Order_Manager = new Order_ManagerDTO { O_M_id = Convert.ToInt32(reader["O_M_id"]), Userid = Convert.ToInt32(reader["Userid"]), O_M_frist_name = reader["O_M_frist_name"].ToString(), O_M_last_name = reader["O_M_last_name"].ToString(), O_M_login = reader["O_M_login"].ToString(), O_M_e_mail = reader["O_M_e_mail"].ToString(), O_M_password = (byte[])(reader["O_M_password"]), salary = Convert.ToInt32(reader["salary"]), }; } return(Order_Manager); } }
public Order_ManagerDTO GetOrder_ManagerByLogin(string Order_ManagerLogin) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); Order_ManagerDTO Order_Manager = new Order_ManagerDTO(); comm.CommandText = $"select * from Order_Manager where Login = @Login"; comm.Parameters.AddWithValue("@Login", Order_ManagerLogin); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { Order_Manager = new Order_ManagerDTO { O_M_id = Convert.ToInt32(reader["O_M_id"]), Login = reader["Login"].ToString(), Password = (byte[])(reader["Password"]), E_mail = reader["E_mail"].ToString(), }; } return(Order_Manager); } }
public bool Login(string Password, string Login) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { conn.Open(); Order_ManagerDTO Order_Manager = new Order_ManagerDTO(); comm.CommandText = $"select * from Order_Manager where Login=@Login"; comm.Parameters.AddWithValue("@Login", Login); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { Order_Manager = new Order_ManagerDTO { O_M_id = Convert.ToInt32(reader["O_M_id"]), Login = reader["Login"].ToString(), Password = (byte[])(reader["Password"]), E_mail = reader["E_mail"].ToString(), }; if (new PasswordActions().PasswordDecryption(Order_Manager.Password) == Password) { return(true); } } } return(false); }
public Order_ManagerDTO CreateOrder_Manager(Order_ManagerDTO Order_Manager) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { comm.CommandText = "insert into Order_Manager (Login, Password, E_mail) output INSERTED.O_M_id values (@Login, @Password, @E_mail)"; comm.Parameters.Clear(); comm.Parameters.AddWithValue("@Login", Order_Manager.Login); comm.Parameters.AddWithValue("@Password", Order_Manager.Password); comm.Parameters.AddWithValue("@E_mail", Order_Manager.E_mail); conn.Open(); Order_Manager.O_M_id = Convert.ToInt32(comm.ExecuteScalar()); return(Order_Manager); } }
public Order_ManagerDTO UpdateOrder_Manager(Order_ManagerDTO Order_Manager) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { comm.CommandText = "update Order_Manager set E_mail = @E_mail where O_M_id = @O_M_id"; comm.Parameters.Clear(); comm.Parameters.AddWithValue("@O_M_id", Order_Manager.O_M_id); comm.Parameters.AddWithValue("@E_mail", Order_Manager.E_mail); conn.Open(); Order_Manager.O_M_id = Convert.ToInt32(comm.ExecuteScalar()); return(Order_Manager); } }
public void UpdateShipperTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); var shupper = dal.GetOrder_ManagerById(13); Order_ManagerDTO upd = new Order_ManagerDTO { Userid = 2, O_M_frist_name = "fname", O_M_last_name = "lname", O_M_login = "******", O_M_e_mail = "email1", salary = 10000, }; var result = dal.UpdateOrder_Manager(upd); Assert.IsTrue(result.O_M_e_mail == "Updated", "Order_Manager was not updated"); }
public Order_ManagerDTO UpdateOrder_Manager(Order_ManagerDTO Order_Manager) { using (SqlConnection conn = new SqlConnection(this.connectionString)) using (SqlCommand comm = conn.CreateCommand()) { comm.CommandText = "update into Order_Manager (O_M_frist_name, O_M_last_name, O_M_login, O_M_e_mail,O_M_password,salary) output INSERTED.O_M_id values (@O_M_frist_name,@O_M_last_name, @O_M_login, @O_M_e_mail,@O_M_password,salary)"; comm.Parameters.Clear(); comm.Parameters.AddWithValue("@O_M_frist_name", Order_Manager.O_M_frist_name); comm.Parameters.AddWithValue("@O_M_last_name", Order_Manager.O_M_last_name); comm.Parameters.AddWithValue("@O_M_login", Order_Manager.O_M_login); comm.Parameters.AddWithValue("@O_M_e_mail", Order_Manager.O_M_e_mail); comm.Parameters.AddWithValue("@O_M_password", Order_Manager.O_M_password); comm.Parameters.AddWithValue("@salary", Order_Manager.salary); conn.Open(); Order_Manager.O_M_id = Convert.ToInt32(comm.ExecuteScalar()); return(Order_Manager); } }
public void CreateShipperTest() { Order_ManagerDAL dal = new Order_ManagerDAL(ConfigurationManager.ConnectionStrings["Order_Manager"].ConnectionString); var result = new Order_ManagerDTO { Userid = 2, O_M_frist_name = "fname", O_M_last_name = "lname", O_M_login = "******", O_M_e_mail = "email1", salary = 10000, }; result = dal.CreateOrder_Manager(result); Assert.IsTrue(result.O_M_id >= 0, "returned ID should be more than zero"); }