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); } } }