public PurchaseStatusDTO GetStatusById(int id)
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
conn.Open();
PurchaseStatusDTO purchaseStatus = new PurchaseStatusDTO();
comm.CommandText = $"select * from Seller where ID={id}";
SqlDataReader reader = comm.ExecuteReader();
while (reader.Read())
{
purchaseStatus = new PurchaseStatusDTO
{
ID = Convert.ToInt32(reader["ID"]),
StatusName = reader["StatusName"].ToString(),
PurchaseStatus = Convert.ToBoolean(reader["PurchaseStatus"]),
DateTime = Convert.ToDateTime(reader["Date/Time"])
};
}
return(purchaseStatus);
}
}
public void RemoveStatus(int ItemID)
{
Console.WriteLine("Enter ID to delete:");
PurchaseStatusDTO purchaseStatus = new PurchaseStatusDTO();
purchaseStatus.ID = Convert.ToInt32(Console.ReadLine());
Console.WriteLine($"Deleting PurchaseStatus ID: {purchaseStatus.ID}");
_purchaseStatusDAL.DeleteStatus(purchaseStatus.ID);
}
public PurchaseStatusDTO AddStatus(PurchaseStatusDTO purchaseStatus)
{
Console.WriteLine("Enter Status Name,PurchaseStatus, Date and Time");
purchaseStatus = new PurchaseStatusDTO
{
StatusName = Console.ReadLine(),
PurchaseStatus = Convert.ToBoolean(Console.ReadLine()),
DateTime = Convert.ToDateTime(Console.ReadLine())
};
return(_purchaseStatusDAL.CreateStatus(purchaseStatus));
}
public PurchaseStatusDTO ChangeStatus(PurchaseStatusDTO purchaseStatus)
{
Console.WriteLine("Change PurchaseStatus inf0: \n");
Console.WriteLine("ItemID, new Price, left OnStock");
Console.WriteLine("Enter StatusName, PurchaseStatus, Date and Time");
purchaseStatus = new PurchaseStatusDTO
{
StatusName = Console.ReadLine(),
PurchaseStatus = Convert.ToBoolean(Console.ReadLine()),
DateTime = Convert.ToDateTime(Console.ReadLine())
};
return(_purchaseStatusDAL.UpdateStatuse(purchaseStatus));
}
public PurchaseStatusDTO CreateStatus(PurchaseStatusDTO purchaseStatus)
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "insert into PurchaseStatus (StatusName, PurchaseStatus, Date/Time) values (@StatusName, @PurchaseStatus, @Date/Time)";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@FullName", purchaseStatus.StatusName);
comm.Parameters.AddWithValue("@Mail", purchaseStatus.PurchaseStatus);
comm.Parameters.AddWithValue("@Login", purchaseStatus.DateTime);
conn.Open();
purchaseStatus.ID = Convert.ToInt32(comm.ExecuteScalar());
return(purchaseStatus);
}
}
public PurchaseStatusDTO UpdateStatuse(PurchaseStatusDTO purchaseStatus)
{
using (SqlConnection conn = new SqlConnection(this._connectionString))
using (SqlCommand comm = conn.CreateCommand())
{
comm.CommandText = "update PurchaseStatus set StatusName= @StatusName,PurchaseStatus=@PurchaseStatus where ID = @ID";
comm.Parameters.Clear();
comm.Parameters.AddWithValue("@ID", purchaseStatus.ID);
comm.Parameters.AddWithValue("@StatusName", purchaseStatus.StatusName);
comm.Parameters.AddWithValue("@PurchaseStatus", purchaseStatus.PurchaseStatus);
conn.Open();
purchaseStatus.ID = Convert.ToInt32(comm.ExecuteScalar());
return(purchaseStatus);
}
}
