public IList <ShiftType> GetAllShiftType()
{
List <ShiftType> allShiftTypes = new List <ShiftType>();
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand("GetAllShiftTypes", con);
command.CommandType = CommandType.StoredProcedure;
var results = command.ExecuteReader();
if (results.HasRows)
{
ShiftType shiftType;
int tempInt;
while (results.Read())
{
shiftType = new ShiftType();
shiftType.Name = results["Name"].ToString();
int.TryParse(results["ShiftID"].ToString(), out tempInt);
shiftType.ShiftID = tempInt;
allShiftTypes.Add(shiftType);
}
}
}
return(allShiftTypes);
}
public void DeleteShiftType(ShiftType record)
{
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand("DeleteShiftType", con);
command.CommandType = CommandType.StoredProcedure;
SqlParameter shiftID = GetParameter("@ShiftID", SqlDbType.Int, record.ShiftID);
command.Parameters.Add(shiftID);
var results = command.ExecuteNonQuery();
}
}
public void AddOrUpdateShiftType(ShiftType record, string sp)
{
using (SqlConnection con = GetConnection())
{
con.Open();
SqlCommand command = new SqlCommand(sp, con);
command.CommandType = CommandType.StoredProcedure;
SqlParameter shiftID = GetParameter("@ShiftID", SqlDbType.Int, record.ShiftID);
SqlParameter name = GetParameter("@Name", SqlDbType.VarChar, record.Name);
command.Parameters.Add(shiftID);
command.Parameters.Add(name);
var results = command.ExecuteNonQuery();
}
}
public void UpdateShiftType(ShiftType record)
{
AddOrUpdateShiftType(record, "UpdateShiftType");
}
public void AddShiftType(ShiftType record)
{
AddOrUpdateShiftType(record, "InsertShiftTypes");
}