public NV_QuyTrinhXuLy_ChiTiet GetById(int id)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_QuyTrinhXuLy_getByID", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = id;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_QuyTrinhXuLy_ChiTiet model = new NV_QuyTrinhXuLy_ChiTiet();
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
if (dt != null && dt.Rows.Count > 0)
{
model = new NV_QuyTrinhXuLy_ChiTiet(dt.Rows[0]);
}
return(model);
}
}
}
public DataTable GetByQuyTrinh(int idQuyTrinh)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_QuyTrinhXuLy_getByQuyTrinhDN", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@IDQuyTrinh", SqlDbType.Int);
pID.Value = idQuyTrinh;
myCommand.Parameters.Add(pID);
DataTable dt;
NV_QuyTrinhXuLy_ChiTiet model = new NV_QuyTrinhXuLy_ChiTiet();
myConnection.Open();
using (SqlDataAdapter mData = new SqlDataAdapter(myCommand))
{
dt = new DataTable();
mData.Fill(dt);
}
return(dt);
}
}
}
public bool update(NV_QuyTrinhXuLy_ChiTiet model)
{
using (SqlConnection myConnection = new SqlConnection(ConnectionString))
{
using (SqlCommand myCommand = new SqlCommand("NV_QuyTrinhXuLy_update", myConnection))
{
myCommand.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter("@ID", SqlDbType.Int);
pID.Value = model.ID;
myCommand.Parameters.Add(pID);
SqlParameter pTen = new SqlParameter("@Ten", SqlDbType.NVarChar, 1000);
pTen.Value = model.Ten;
myCommand.Parameters.Add(pTen);
SqlParameter pIDQuyTrinh = new SqlParameter("@IDQuyTrinh", SqlDbType.Int);
pIDQuyTrinh.Value = model.IDQuyTrinh;
myCommand.Parameters.Add(pIDQuyTrinh);
SqlParameter pTrangThai = new SqlParameter("@TrangThai", SqlDbType.Bit);
pTrangThai.Value = model.TrangThai;
myCommand.Parameters.Add(pTrangThai);
SqlParameter pNgayHieuLuc = new SqlParameter("@NgayBatDau", SqlDbType.DateTime);
pNgayHieuLuc.Value = model.NgayBatDau;
myCommand.Parameters.Add(pNgayHieuLuc);
SqlParameter pNgayTao = new SqlParameter("@NgayHoanThanh", SqlDbType.DateTime);
pNgayTao.Value = model.NgayHoanThanh;
myCommand.Parameters.Add(pNgayTao);
SqlParameter pNguoiTao = new SqlParameter("@NguoiTao", SqlDbType.Int);
pNguoiTao.Value = model.NguoiTao;
myCommand.Parameters.Add(pNguoiTao);
SqlParameter pFileDauVao = new SqlParameter("@FileDauVao", SqlDbType.NVarChar, 200);
pFileDauVao.Value = model.FileDauVao;
myCommand.Parameters.Add(pFileDauVao);
SqlParameter pFileKQ = new SqlParameter("@FileKQ", SqlDbType.NVarChar, 200);
pFileKQ.Value = model.FileKQ;
myCommand.Parameters.Add(pFileKQ);
SqlParameter pNguoiYeuCau = new SqlParameter("@NguoiYeuCau", SqlDbType.NVarChar, 200);
pNguoiYeuCau.Value = model.NguoiYeuCau;
myCommand.Parameters.Add(pNguoiYeuCau);
SqlParameter pSoDienThoai = new SqlParameter("@SoDienThoai", SqlDbType.NVarChar, 50);
pSoDienThoai.Value = model.SoDienThoai;
myCommand.Parameters.Add(pSoDienThoai);
SqlParameter pEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
pEmail.Value = model.Email;
myCommand.Parameters.Add(pEmail);
SqlParameter pDiaChi = new SqlParameter("@DiaChi", SqlDbType.NVarChar, 500);
pDiaChi.Value = model.DiaChi;
myCommand.Parameters.Add(pDiaChi);
SqlParameter pThongTin = new SqlParameter("@ThongTin", SqlDbType.NVarChar, 2000);
pThongTin.Value = model.ThongTin;
myCommand.Parameters.Add(pThongTin);
SqlParameter pGhiChu = new SqlParameter("@GhiChu", SqlDbType.NVarChar, 4000);
pGhiChu.Value = model.GhiChu;
myCommand.Parameters.Add(pGhiChu);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
}
}
