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