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