public List <ChucvuEntity> ChucvuGetByPK(long chucvuID)
{
List <ChucvuEntity> glstChucvu = new List <ChucvuEntity>();
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spGetChucvuByPK_iChucvuID", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@chucvuID", chucvuID);
SqlDataReader dar = cmd.ExecuteReader();
if (dar.HasRows)
{
while (dar.Read())
{
ChucvuEntity chucvu = new ChucvuEntity();
chucvu.PK_iChucvuID = Convert.ToInt64(dar["PK_iChucvuID"]);
chucvu.STenChucvu = dar["sTenChucvu"].ToString();
chucvu.ISoluong = Convert.ToInt64(dar["iSoluong"]);
glstChucvu.Add(chucvu);
}
}
cnn.Close();
return(glstChucvu);
}
}
public long ThemChucvu(string ten, long soluong)
{
ChucvuEntity chucvu = new ChucvuEntity();
chucvu.STenChucvu = ten;
chucvu.ISoluong = soluong;
return((new ChucvuDAL()).Insert(chucvu));
}
public bool SuaChucvu(long maChucvu, string tenChucvu, long soluong)
{
ChucvuEntity chucvu = new ChucvuEntity();
chucvu.PK_iChucvuID = maChucvu;
chucvu.STenChucvu = tenChucvu;
chucvu.ISoluong = soluong;
return((new ChucvuDAL()).Update(chucvu));
}
public long Insert(ChucvuEntity chucvu)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spInsertChucvu", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sTenChucvu", chucvu.STenChucvu);
cmd.Parameters.AddWithValue("@iSoluong", chucvu.ISoluong);
object i = cmd.ExecuteScalar();
cnn.Close();
return(Convert.ToInt64(i));
}
}
public bool XoaChucvu(long maChucvu)
{
List <LichsucongtacEntity> gltsLichsu = (new LichsucongtacBRL().gltsLichsucongtac(0));
ChucvuEntity chucvu = new ChucvuEntity();
chucvu.PK_iChucvuID = maChucvu;
gltsLichsu = gltsLichsu.FindAll(lichsu => lichsu.PK_iLichsucongtacID == maChucvu);
if (gltsLichsu.Count == 0)
{
return(new ChucvuDAL().Delete(chucvu));
}
else
{
return(false);
}
}
public bool Delete(ChucvuEntity chucvu)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spDeleteChucvu", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iChucvuID", chucvu.PK_iChucvuID);
int i = cmd.ExecuteNonQuery();
cnn.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
