public MonHocBDO GetMonHocByID(string MaMonHoc)
{
MonHocBDO MonHoc = new MonHocBDO();
using (SqlConnection connection = new SqlConnection(ConnectionInformation.ConnectionString))
{
using (SqlCommand command = new SqlCommand("spGetMonHoc", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@Mamh", MaMonHoc);
connection.Open();
SqlDataAdapter MonHocAdapter = new SqlDataAdapter();
DataTable MonHocTable = new DataTable();
MonHocAdapter.SelectCommand = command;
MonHocAdapter.Fill(MonHocTable);
if (MonHocTable.Rows.Count > 0)
{
MonHoc.MaMH = (string)MonHocTable.Rows[0]["Mamh"];
MonHoc.TenMH = (string)MonHocTable.Rows[0]["Tenmh"];
MonHoc.SoTiet = (int)MonHocTable.Rows[0]["sotiet"];
}
}
}
return(MonHoc);
}
public List <MonHocBDO> GetAllKhoa()
{
List <MonHocBDO> ListMonHoc = new List <MonHocBDO>();
using (SqlConnection connection = new SqlConnection(ConnectionInformation.ConnectionString))
{
using (SqlCommand command = new SqlCommand("spGetMonHoc", connection))
{
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataAdapter MonHocAdapter = new SqlDataAdapter();
DataTable MonHocTable = new DataTable();
MonHocAdapter.SelectCommand = command;
MonHocAdapter.Fill(MonHocTable);
if (MonHocTable.Rows.Count > 0)
{
for (int i = 0; i < MonHocTable.Rows.Count; i++)
{
MonHocBDO MonHoc = new MonHocBDO();
MonHoc.MaMH = (string)MonHocTable.Rows[i]["Mamh"];
MonHoc.TenMH = (string)MonHocTable.Rows[i]["Tenmh"];
MonHoc.SoTiet = (int)MonHocTable.Rows[i]["sotiet"];
ListMonHoc.Add(MonHoc);
}
}
}
}
return(ListMonHoc);
}
public bool Update(MonHocBDO MonHoc)
{
if (MonHoc != null)
{
if (MonHoc.MaMH != null && MonHoc.MaMH != string.Empty)
{
MonHocDAL.Update(MonHoc);
return(true);
}
}
return(false);
}
public bool Update(MonHocBDO monhoc)
{
try
{
monhocBUS.Update(monhoc);
return(true);
}
catch (FaultException)
{
throw;
}
}
public int Add(MonHocBDO MonHoc)
{
using (SqlConnection connection = new SqlConnection(ConnectionInformation.ConnectionString))
{
using (SqlCommand command = new SqlCommand("spEditMonHoc", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StatementType", ConnectionInformation.Insert);
command.Parameters.AddWithValue("@Mamh", MonHoc.MaMH);
command.Parameters.AddWithValue("@Tenmh", MonHoc.TenMH);
command.Parameters.AddWithValue("@sotiet", MonHoc.SoTiet);
connection.Open();
return(command.ExecuteNonQuery());
}
}
}
