public ActionResult _DeletePant(int Delete_Pant)
{
if ((int)Session["RoleID"] == 1)
{
PantsDAO _DeletePant = new PantsDAO();
_DeletePant.PantsID = Delete_Pant;
PantsDataAccess.deletePant(_DeletePant);
}
return(RedirectToAction("PantView"));
}
public Pant Map(PantsDAO _pantToUpdate)
{
Pant _PantToUpdate = new Pant();
_PantToUpdate.PantsID = _pantToUpdate.PantsID;
_PantToUpdate.Size = _pantToUpdate.Size;
_PantToUpdate.Color = _pantToUpdate.Color;
_PantToUpdate.PantPrice = _pantToUpdate.PantPrice;
return(_PantToUpdate);
}
public PantsDAO Map(Pant pantToCreate)
{
PantsDAO daPantToCreate = new PantsDAO();
daPantToCreate.PantsID = pantToCreate.PantsID;
daPantToCreate.Size = pantToCreate.Size;
daPantToCreate.Color = pantToCreate.Color;
daPantToCreate.PantPrice = pantToCreate.PantPrice;
return(daPantToCreate);
}
public PantsDAO createPant(PantsDAO pantToCreate)
{
PantsDAO createPant = new PantsDAO();
try
{
//This is creating a connection to the database
using (SqlConnection _connection = new SqlConnection(connectionString))
{
//This specifies what type of command
using (SqlCommand _command = new SqlCommand("SP_Pant_Create", _connection))
{
//This specifies what type of command is being used
_command.CommandType = CommandType.StoredProcedure;
//Here is where the Values will be passed to the command
_command.Parameters.AddWithValue("@Size", pantToCreate.Size);
_command.Parameters.AddWithValue("@Color", pantToCreate.Color);
_command.Parameters.AddWithValue("@PantPrice", pantToCreate.PantPrice);
//Here is where the connection is opened
_connection.Open();
using (SqlDataReader _reader = _command.ExecuteReader())
{
while (_reader.Read())
{
pantToCreate.Size = _reader.GetInt32(1);
pantToCreate.Color = _reader.GetString(2);
pantToCreate.PantPrice = _reader.GetInt32(3);
}
//This will excute the command
_command.ExecuteNonQuery();
_connection.Close();
}
}
}
}
catch (Exception error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(error);
}
return(pantToCreate);
}
public List <PantsDAO> GetAllPants()
{//Create a method that will get all my Books and place them in a list named _booklist
List <PantsDAO> _pantlist = new List <PantsDAO>();
try
{
//Establishing the connection for the database
using (SqlConnection _connection = new SqlConnection(connectionString))
{
using (SqlCommand _command = new SqlCommand("SP_Pant_Read", _connection))
{
//Establishing the command to pass to the database
//and defining the command
_command.CommandType = CommandType.StoredProcedure;
//connect to the database
_connection.Open();
//Open the sql data reader
using (SqlDataReader _reader = _command.ExecuteReader())
{
//Loop through the data sets or command and write each element
//to the _bookToList using the book object
while (_reader.Read())
{
PantsDAO _pantToList = new PantsDAO();
_pantToList.PantsID = _reader.GetInt32(0);
_pantToList.Size = _reader.GetInt32(1);
_pantToList.Color = _reader.GetString(2);
_pantToList.PantPrice = _reader.GetInt32(3);
_pantlist.Add(_pantToList);
}
}
}
}
}
catch (Exception error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(error);
}
return(_pantlist);
}
public PantsDAO GetPantById(int PantsID)
{//Create a method that will get all my Books and place them in a list named _booklist
PantsDAO _pantReturn = new PantsDAO();
try
{
//Establishing the connection for the database
using (SqlConnection _connection = new SqlConnection(connectionString))
{
using (SqlCommand _command = new SqlCommand("SP_Get_Pant_By_PantID", _connection))
{
//Establishing the command to pass to the database
//and defining the command
_command.CommandType = CommandType.StoredProcedure;
_command.Parameters.AddWithValue("@PantsID", PantsID);
//connect to the database
_connection.Open();
//Open the sql data reader
using (SqlDataReader _reader = _command.ExecuteReader())
{
//Loop through the data sets or command and write each element
//to the _bookToList using the book object
while (_reader.Read())
{
_pantReturn.PantsID = _reader.GetInt32(0);
_pantReturn.Size = _reader.GetInt32(1);
_pantReturn.Color = _reader.GetString(2);
_pantReturn.PantPrice = _reader.GetInt32(3);
}
}
}
}
}
catch (Exception error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(error);
}
return(_pantReturn);
}
// This is the method used to delete a book
public bool deletePant(PantsDAO pantToDelete)
{
bool yes = false;
try
{
//This is creating a connection to the database
using (SqlConnection _connection = new SqlConnection(connectionString))
{
//This specifies what type of command
using (SqlCommand _command = new SqlCommand("SP_Pant_Delete", _connection))
{
//This specifies what type of command is being used
_command.CommandType = CommandType.StoredProcedure;
//Here is where the Values will be passed to the command
_command.Parameters.AddWithValue("@PantsID", pantToDelete.PantsID);
//Here is where the connection is opened
_connection.Open();
//This will excute the command
_command.ExecuteNonQuery();
yes = true;
_connection.Close();
}
}
}
catch (Exception error)
{
Error_Logger Log = new Error_Logger();
Log.Errorlogger(error);
}
if (yes == true)
{
//Console.WriteLine("You have successfully deleted a Book");
// Console.ReadLine();
}
return(yes);
}