public long Insert(CanboEntity canbo)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spInsertCanbo", cnn))
{
// @sTenCanbo , --sTenCanbo - nvarchar(100)
// @sTenTaikhoan , --sTenTaikhoan - nvarchar(50)
// @sMatkhau , --sMatkhau - varchar(50)
// @sSodienthoai, --sSodienthoai - char(10)
// @sEmail , --sEmail - varchar(150)
//@tNgaysinh , --tNgaysinh - date
// @bGioitinh, --bGioitinh - bit
//@sCMND , --sCMND - char(12)
// @sDiachi -
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@sTenCanbo", canbo.STenCanbo);
cmd.Parameters.AddWithValue("@sSodienthoai", canbo.SSodienthoai);
cmd.Parameters.AddWithValue("@sEmail", canbo.SEmail);
cmd.Parameters.AddWithValue("@tNgaysinh", canbo.TNgaySinh);
cmd.Parameters.AddWithValue("@bGioitinh", canbo.BGioiTinh);
cmd.Parameters.AddWithValue("@sCMND", canbo.SCMND);
cmd.Parameters.AddWithValue("@sDiachi", canbo.SDiaChi);
cmd.Parameters.AddWithValue("@sTenTaikhoan", canbo.STenTaikhoan);
cmd.Parameters.AddWithValue("@sMatkhau", canbo.SMatkhau);
Object iMacabo = cmd.ExecuteScalar();
return(Convert.ToInt64(iMacabo));
}
}
public List <CanboEntity> CanboGetByPK(long canboID)
{
List <CanboEntity> glstCabo = new List <CanboEntity>();
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spGetCanboByPK_iCanboID", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@canbID", canboID);
SqlDataReader dar = cmd.ExecuteReader();
if (dar.HasRows)
{
while (dar.Read())
{
CanboEntity canbo = new CanboEntity();
canbo.PK_iCanboID = Convert.ToInt64(dar["PK_iCanboID"]);
canbo.STenCanbo = dar["sTenCanbo"].ToString();
canbo.SSodienthoai = dar["sSodienthoai"].ToString();
canbo.SEmail = dar["sEmail"].ToString();
canbo.TNgaySinh = DateTime.Parse(dar["tNgaysinh"].ToString());
canbo.BGioiTinh = Boolean.Parse(dar["bGioitinh"].ToString());
canbo.STenTaikhoan = dar["sTenTaikhoan"].ToString();
canbo.SMatkhau = dar["sMatkhau"].ToString();
canbo.SCMND = dar["sCMND"].ToString();
canbo.SDiaChi = dar["sDiachi"].ToString();
glstCabo.Add(canbo);
}
}
cnn.Close();
return(glstCabo);
}
}
public long themCanbo(string tenCanbo, string sodienthoai, string email, DateTime Ngaysinh, bool gioitinh, string CMND, string taikhoan, string matkhau, string diachi)
{
CanboEntity canbo = new CanboEntity();
canbo.STenCanbo = tenCanbo;
canbo.SSodienthoai = sodienthoai;
canbo.SEmail = email;
canbo.TNgaySinh = Ngaysinh;
canbo.BGioiTinh = gioitinh;
canbo.SCMND = CMND;
canbo.SDiaChi = diachi;
canbo.SMatkhau = matkhau;
canbo.STenTaikhoan = taikhoan;
return(new CanboDAL().Insert(canbo));
}
public bool suaCanbo(CanboEntity canbo)
{
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spUpdateCanbo", cnn))
{
// @sTenCanbo , --sTenCanbo - nvarchar(100)
// @sTenTaikhoan , --sTenTaikhoan - nvarchar(50)
// @sMatkhau , --sMatkhau - varchar(50)
// @sSodienthoai, --sSodienthoai - char(10)
// @sEmail , --sEmail - varchar(150)
//@tNgaysinh , --tNgaysinh - date
// @bGioitinh, --bGioitinh - bit
//@sCMND , --sCMND - char(12)
// @sDiachi -
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PK_iCanboID", canbo.PK_iCanboID);
cmd.Parameters.AddWithValue("@sTenCanbo", canbo.STenCanbo);
cmd.Parameters.AddWithValue("@sSodienthoai", canbo.SSodienthoai);
cmd.Parameters.AddWithValue("@sEmail", canbo.SEmail);
cmd.Parameters.AddWithValue("@tNgaysinh", canbo.TNgaySinh);
cmd.Parameters.AddWithValue("@bGioitinh", canbo.BGioiTinh);
cmd.Parameters.AddWithValue("@sCMND", canbo.SCMND);
cmd.Parameters.AddWithValue("@sDiachi", canbo.SDiaChi);
cmd.Parameters.AddWithValue("@sTenTaikhoan", canbo.STenTaikhoan);
cmd.Parameters.AddWithValue("@sMatkhau", canbo.SMatkhau);
long i = cmd.ExecuteNonQuery();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public List <CanboEntity> GetCanbo(long chucvuID)
{
List <CanboEntity> glstCanboBophan = new List <CanboEntity>();
cnn.Open();
using (SqlCommand cmd = new SqlCommand("spGetCanboByFK_iChucvu", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@chucvuID", chucvuID);
SqlDataReader dar = cmd.ExecuteReader();
if (dar.HasRows)
{
while (dar.Read())
{
CanboEntity canbo = new CanboEntity();
canbo.PK_iCanboID = Convert.ToInt64(dar["PK_iCanboID"]);
canbo.STenCanbo = dar["sTenCanbo"].ToString();
glstCanboBophan.Add(canbo);
}
}
cnn.Close();
return(glstCanboBophan);
}
}