Exemplo n.º 1
0
        public NV_KeHoachTuBo_ChiTiet GetById(int id)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_KeHoachTuBo_getByID", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@id", SqlDbType.Int);
                    pID.Value = id;
                    myCommand.Parameters.Add(pID);

                    DataTable dt;
                    NV_KeHoachTuBo_ChiTiet model = new NV_KeHoachTuBo_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_KeHoachTuBo_ChiTiet(dt.Rows[0]);
                    }
                    return(model);
                }
            }
        }
Exemplo n.º 2
0
        public bool update(NV_KeHoachTuBo_ChiTiet model)
        {
            using (SqlConnection myConnection = new SqlConnection(ConnectionString))
            {
                using (SqlCommand myCommand = new SqlCommand("NV_KeHoachTuBo_update", myConnection))
                {
                    myCommand.CommandType = CommandType.StoredProcedure;

                    SqlParameter pID = new SqlParameter("@KeHoachID", SqlDbType.Int);
                    pID.Value = model.KeHoachID;
                    myCommand.Parameters.Add(pID);


                    SqlParameter pTenDuAn = new SqlParameter("@TenDuAn", SqlDbType.NVarChar, 200);
                    pTenDuAn.Value = model.TenDuAn;
                    myCommand.Parameters.Add(pTenDuAn);

                    SqlParameter pDiaDiem = new SqlParameter("@DiaDiem", SqlDbType.NVarChar, 250);
                    pDiaDiem.Value = model.DiaDiem;
                    myCommand.Parameters.Add(pDiaDiem);


                    SqlParameter pDonViGiamSat = new SqlParameter("@DonViGiamSat", SqlDbType.Int);
                    pDonViGiamSat.Value = model.DonViGiamSat.DonViID;
                    myCommand.Parameters.Add(pDonViGiamSat);

                    SqlParameter pDonViThiCong = new SqlParameter("@DonViThiCong", SqlDbType.Int);
                    pDonViThiCong.Value = model.DonViThiCong.DonViID;
                    myCommand.Parameters.Add(pDonViThiCong);

                    SqlParameter pDonViThietKe = new SqlParameter("@DonViThietKe", SqlDbType.Int);
                    pDonViThietKe.Value = model.DonViThietKe.DonViID;
                    myCommand.Parameters.Add(pDonViThietKe);

                    SqlParameter pChuDauTu = new SqlParameter("@ChuDauTu", SqlDbType.Int);
                    pChuDauTu.Value = model.ChuDauTu.DonViID;
                    myCommand.Parameters.Add(pChuDauTu);

                    SqlParameter pCapQD = new SqlParameter("@CapQD", SqlDbType.Int);
                    pCapQD.Value = model.CapQD.DonViID;
                    myCommand.Parameters.Add(pCapQD);

                    SqlParameter pLyDo = new SqlParameter("@LyDo", SqlDbType.NVarChar, 250);
                    pLyDo.Value = model.Lydo;
                    myCommand.Parameters.Add(pLyDo);

                    SqlParameter pMotaQuaTrinh = new SqlParameter("@MotaQuaTrinh", SqlDbType.NText);
                    pMotaQuaTrinh.Value = model.MotaQuaTrinh;
                    myCommand.Parameters.Add(pMotaQuaTrinh);

                    SqlParameter pDiSanID = new SqlParameter("@DiSanID", SqlDbType.Int);
                    pDiSanID.Value = model.DiSan.DiSanID;
                    myCommand.Parameters.Add(pDiSanID);

                    SqlParameter pNoiDung = new SqlParameter("@NoiDung", SqlDbType.NText);
                    pNoiDung.Value = model.NoiDung;
                    myCommand.Parameters.Add(pNoiDung);

                    SqlParameter pThuocTinh = new SqlParameter("@ThuocTinh", SqlDbType.VarChar, 10);
                    pThuocTinh.Value = model.ThuocTinh;
                    myCommand.Parameters.Add(pThuocTinh);

                    SqlParameter pThuocHuyen = new SqlParameter("@ThuocHuyen", SqlDbType.VarChar, 10);
                    pThuocHuyen.Value = model.ThuocHuyen;
                    myCommand.Parameters.Add(pThuocHuyen);

                    SqlParameter pThuocXa = new SqlParameter("@ThuocXa", SqlDbType.VarChar, 10);
                    pThuocXa.Value = model.ThuocXa;
                    myCommand.Parameters.Add(pThuocXa);

                    SqlParameter pDuKienBatDau = new SqlParameter("@DuKienBatDau", SqlDbType.DateTime);
                    pDuKienBatDau.Value = model.DuKienBatDau;
                    myCommand.Parameters.Add(pDuKienBatDau);

                    SqlParameter pDuKienHoanThanh = new SqlParameter("@DuKienHoanThanh", SqlDbType.DateTime);
                    pDuKienHoanThanh.Value = model.DukienHoanThanh;
                    myCommand.Parameters.Add(pDuKienHoanThanh);

                    SqlParameter pTrangThai = new SqlParameter("@TrangThai", SqlDbType.Bit);
                    pTrangThai.Value = model.TrangThai;
                    myCommand.Parameters.Add(pTrangThai);

                    SqlParameter pThucTeBatDau = new SqlParameter("@ThucTeBatDau", SqlDbType.DateTime);
                    pThucTeBatDau.Value = model.ThucTeBatDau;
                    myCommand.Parameters.Add(pThucTeBatDau);

                    SqlParameter pThucTeHoanThanh = new SqlParameter("@ThucTeHoanThanh", SqlDbType.DateTime);
                    pThucTeHoanThanh.Value = model.ThucTeHoanThanh;
                    myCommand.Parameters.Add(pThucTeHoanThanh);

                    SqlParameter pChiPhiDuKien = new SqlParameter("@ChiPhiDuKien", SqlDbType.Decimal);
                    pChiPhiDuKien.Value = model.ChiPhiDuKien;
                    myCommand.Parameters.Add(pChiPhiDuKien);

                    SqlParameter pChiPhiThucTe = new SqlParameter("@ChiPhiThucTe", SqlDbType.Decimal);
                    pChiPhiThucTe.Value = model.ChiPhiThucTe;
                    myCommand.Parameters.Add(pChiPhiThucTe);

                    SqlParameter pFile = new SqlParameter("@File", SqlDbType.NVarChar, 500);
                    pFile.Value = model.File;
                    myCommand.Parameters.Add(pFile);
                    try
                    {
                        myConnection.Open();
                        myCommand.ExecuteNonQuery();
                        return(true);
                    }
                    catch
                    {
                        return(false);
                    }
                }
            }
        }