public ShipperDTO GetShipperByLogin(string ShipperLogin)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
conn.Open();
ShipperDTO shipper = new ShipperDTO();
comm.CommandText = $"select * from Shipper where Login=@Login";
comm.Parameters.AddWithValue("@Login", ShipperLogin);
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
shipper = new ShipperDTO
{
ShipperID = Convert.ToInt32(reader["ShipperID"]),
Login = reader["Login"].ToString(),
Password = (byte[])(reader["Password"]),
EMail = reader["EMail"].ToString(),
Addres = reader["Adress"].ToString(),
Phone = reader["Phone"].ToString(),
Description = reader["Description"].ToString(),
};
}
return(shipper);
}
}
public int Login()
{
Console.WriteLine("Login to continue:\n");
Console.WriteLine("Login: "******"Password: "******"select * from Shipper where Login= '******'";
PasswordActions decrypt = new PasswordActions();
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
shipper.ShipperID = Convert.ToInt32(reader["ShipperID"]);
shipper.Login = reader["Login"].ToString();
shipper.Password = (byte[])reader["Password"];
if (shipper.Login != login || decrypt.PasswordDecryption(shipper.Password) != password)
{
throw new NotImplementedException("Incorrect Login or Password");
}
}
return(shipper.ShipperID);
}
}
public void RemoveShipper(int ShipperID)
{
ShipperDTO shipper = new ShipperDTO();
shipper.ShipperID = Convert.ToInt32(Console.ReadLine());
Console.WriteLine($"Deleting shipper ID: {shipper.ShipperID}");
_shipperDAL.DeleteShipper(shipper.ShipperID);
}
public ShipperDTO GetShipperById(int id)
{
ShipperDTO list = db.Shippers.Where(s => s.ShipperID == id).Select(e => new ShipperDTO()
{
ShipperID = e.ShipperID,
CompanyName = e.CompanyName,
Phone = e.Phone
}).FirstOrDefault();
return(list);
}
public ShipperDTO ChangeShipper(ShipperDTO shipper)
{
Console.WriteLine("ShipperID, new EMail, Address, Phone, Description");
shipper = new ShipperDTO
{
ShipperID = Convert.ToInt32(Console.ReadLine()),
EMail = Console.ReadLine(),
Addres = Console.ReadLine(),
Phone = Console.ReadLine(),
Description = Console.ReadLine()
};
return(_shipperDAL.UpdateShipper(shipper));
}
public IHttpActionResult PutShipper(ShipperDTO shipper)
{
Shipper shipperEdit = db.Shippers.FirstOrDefault(s => s.ShipperID == shipper.ShipperID);
shipperEdit.CompanyName = shipper.CompanyName;
shipperEdit.Phone = shipper.Phone;
if (db.SaveChanges() > 0)
{
return(Ok());
}
else
{
return(InternalServerError());
}
}
public void UpdateShipperTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
var shupper = dal.GetShipperById(13);
ShipperDTO upd = new ShipperDTO
{
ShipperID = 13,
EMail = "Updated",
Addres = "Updated",
Phone = "Updated",
Description = "Updated"
};
var result = dal.UpdateShipper(upd);
Assert.IsTrue(result.EMail == "Updated", "Shipper was not updated");
}
public IHttpActionResult GetShipperById(int id)
{
ShipperDTO list = db.Shippers.Where(s => s.ShipperID == id).Select(e => new ShipperDTO()
{
CompanyName = e.CompanyName,
Phone = e.Phone
}).FirstOrDefault();
if (list != null)
{
return(Ok(list));
}
else
{
return(NotFound());
}
}
public bool PutShipper(ShipperDTO shipper)
{
Shipper shipperInsert = db.Shippers.FirstOrDefault(s => s.ShipperID == shipper.ShipperID);
shipperInsert.CompanyName = shipper.CompanyName;
shipperInsert.Phone = shipper.Phone;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
public IHttpActionResult PostNewShipper(ShipperDTO shiper)
{
Shipper shipperInsert = new Shipper()
{
CompanyName = shiper.CompanyName,
Phone = shiper.Phone
};
db.Shippers.Add(shipperInsert);
if (db.SaveChanges() > 0)
{
return(Ok());
}
else
{
return(InternalServerError());
}
}
public ShipperDTO AddShipper(ShipperDTO shipper)
{
ConsoleProject.PasswordActions password = new ConsoleProject.PasswordActions();
Console.WriteLine("Login, Password, Email, Address, Phone, Descrition: ");
shipper = new ShipperDTO
{
Login = Console.ReadLine(),
Password = password.PasswordEncryption(Console.ReadLine()),
EMail = Console.ReadLine(),
Addres = Console.ReadLine(),
Phone = Console.ReadLine(),
Description = Console.ReadLine()
};
return(_shipperDAL.CreateShipper(shipper));
}
public ShipperDTO CreateShipper(ShipperDTO shipper)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "insert into Shipper (Login, Password, EMail, Adress, Phone, Description) output INSERTED.ShipperID values (@Login, @Password, @EMail, @Adress, @Phone, @Description)";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@Login", shipper.Login);
comm.Parameters.AddWithValue("@Password", shipper.Password);
comm.Parameters.AddWithValue("@EMail", shipper.EMail);
comm.Parameters.AddWithValue("@Adress", shipper.Addres);
comm.Parameters.AddWithValue("@Phone", shipper.Phone);
comm.Parameters.AddWithValue("@Description", shipper.Description);
conn.Open();
shipper.ShipperID = Convert.ToInt32(comm.ExecuteScalar());
return(shipper);
}
}
public bool PostNewShipper(ShipperDTO shipper)
{
Shipper shipperInsert = new Shipper()
{
ShipperID = shipper.ShipperID,
CompanyName = shipper.CompanyName,
Phone = shipper.Phone
};
db.Shippers.Add(shipperInsert);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
public ShipperDTO UpdateShipper(ShipperDTO shipper)
{
using (SqlConnection conn = new SqlConnection(this.connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "update Shipper set EMail= @EMail, Adress=@Adress, Phone=@Phone, Description=@Description where ShipperID = @ShipperID";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@ShipperID", shipper.ShipperID);
comm.Parameters.AddWithValue("@EMail", shipper.EMail);
comm.Parameters.AddWithValue("@Adress", shipper.Addres);
comm.Parameters.AddWithValue("@Phone", shipper.Phone);
comm.Parameters.AddWithValue("@Description", shipper.Description);
conn.Open();
shipper.ShipperID = Convert.ToInt32(comm.ExecuteScalar());
return(shipper);
}
}
public ActionResult Insert()
{
//HttpPostedFileBase file = Request.Files[0];
ShipperDTO shipper = new ShipperDTO();
//shipper.ShipperID = int.Parse(Request.Params["ShipperID"]);
shipper.CompanyName = Request.Params["CompanyName"];
shipper.Phone = Request.Params["Phone"];
bool check = new ShipperModels().PostNewShipper(shipper);
if (check)
{
return(Json(new { Ok = true }));
}
else
{
return(Json(new { Ok = false }));
}
}
public void CreateShipperTest()
{
ShipperDAL dal = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
PasswordActions password = new PasswordActions();
var result = new ShipperDTO
{
Login = "******",
Password = password.PasswordEncryption("1234"),
EMail = "Test",
Addres = "Test",
Phone = "Test",
Description = "Test"
};
result = dal.CreateShipper(result);
Assert.IsTrue(result.ShipperID >= 0, "returned ID should be more than zero");
}
public void AddShipperTest()
{
ItemDAL itemDAL = new ItemDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
ShipperDAL shipperDAL = new ShipperDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
CustomerDAL customerDAL = new CustomerDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
OrderDAL orderDAL = new OrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);;
AddToOrderDAL addtoorderDAL = new AddToOrderDAL(ConfigurationManager.ConnectionStrings["Shipper"].ConnectionString);
User result = new User(shipperDAL, itemDAL, customerDAL, orderDAL, addtoorderDAL);
var shipper = new ShipperDTO
{
Login = "******",
Password = new ConsoleProject.PasswordActions().PasswordEncryption("1234"),
EMail = "Test2",
Addres = "Test2",
Phone = "Test2",
Description = "Test2"
};
shipper = result.AddShipper(shipper);
Assert.IsTrue(shipper.ShipperID >= 0, "returned ID should be more than zero");
}
private void shipperSignUpButtom_Click(object sender, EventArgs e)
{
if (textBox1.Text.Length == 0 || textBox2.Text.Length == 0 || textBox3.Text.Length == 0 || textBox4.Text.Length == 0 || textBox5.Text.Length == 0 || textBox6.Text.Length == 0)
{
MessageBox.Show("Invalid data");
}
else
{
ShipperDTO user = new ShipperDTO
{
Login = textBox1.Text,
Password = new ConsoleProject.PasswordActions().PasswordEncryption(textBox2.Text),
EMail = textBox3.Text,
Addres = textBox4.Text,
Phone = textBox5.Text,
Description = textBox6.Text
};
_shipper.AddShipper(user);
var shipperMenu = new order_managerMenuForm(_shipper, user.ShipperID);
shipperMenu.Show();
this.Hide();
}
}
public IActionResult InsertProducto([FromBody] ShipperDTO oShipper)
{
var a = oShipper;
return(Ok(a));
}
public ShipperDTO AddShipper(ShipperDTO shipper)
{
return(_shipperDAL.CreateShipper(shipper));
}
public ShipperDTO ChangeShipper(ShipperDTO shipper)
{
return(_shipperDAL.UpdateShipper(shipper));
}
// DELETE api/<controller>
public void Post([FromBody] ShipperDTO value)
{
Northwind.AddShipper(value.ToShipper());
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] ShipperDTO value)
{
value.ShipperID = id;
Northwind.UpdateShipper(value.ToShipper());
}