public bool ThemBophan(string ten)
{
BophanEntity bophan = new BophanEntity();
bophan.STenBophan = ten;
return((new BophanDAL()).Insert(bophan));
}
public bool SuaBophan(long maBophan, string ten)
{
BophanEntity bophan = new BophanEntity();
bophan.PK_iBophanID = maBophan;
bophan.STenBophan = ten;
return((new BophanDAL()).Update(bophan));
}
private bool validate(BophanEntity bophan)
{
cnn.Open();
String sql = "select* from tblBophan where sTenBophan = N'" + bophan.STenBophan + "'";
SqlDataAdapter dap = new SqlDataAdapter(sql, cnn);
DataTable dataTable = new DataTable();
dap.Fill(dataTable);
cnn.Close();
if (dataTable.Rows.Count > 0)
{
return(false);
}
return(true);
}
public bool XoaBophan(long maBophan)
{
BophanEntity bophan = new BophanEntity();
bophan.PK_iBophanID = maBophan;
List <LichsucongtacEntity> gltsLichsu = (new LichsucongtacBRL().gltsLichsucongtac(0));
gltsLichsu = gltsLichsu.FindAll(lichsu => lichsu.PK_iLichsucongtacID == maBophan);
if (gltsLichsu.Count == 0)
{
return(new BophanDAL().Delete(bophan));
}
else
{
return(false);
}
}
public bool kiemtraBophan(string ten)
{
BophanEntity bophan = new BophanEntity();
bophan.STenBophan = ten;
List <BophanEntity> gltsBophan = GetBophanByPK(0);
int i = gltsBophan.FindIndex(bophandb => bophandb.STenBophan == ten);
if (i == -1)
{
return(true);
}
else
{
return(false);
}
}
public bool Delete(BophanEntity bophan)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spXoaBophan", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ma", bophan.PK_iBophanID);
int i = cmd.ExecuteNonQuery();
cnn.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public bool Insert(BophanEntity bophan)
{
if (validate(bophan))
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spThemBophan", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ten", bophan.STenBophan);
int i = cmd.ExecuteNonQuery();
cnn.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
return(false);
}
public List <BophanEntity> BophanGetByPK(long bophanID)
{
List <BophanEntity> glstBophan = new List <BophanEntity>();
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spXemdanhsachBophan", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@mabophan", bophanID);
SqlDataReader dar = cmd.ExecuteReader();
if (dar.HasRows)
{
while (dar.Read())
{
BophanEntity bophan = new BophanEntity();
bophan.PK_iBophanID = Convert.ToInt64(dar["PK_iBophanID"]);
bophan.STenBophan = dar["sTenBophan"].ToString();
glstBophan.Add(bophan);
}
}
cnn.Close();
return(glstBophan);
}
}
