public NV_DiaDanh_ChiTiet GetById(int id) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_DangKyDiSan_getByID", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@id", SqlDbType.VarChar, 10); pID.Value = id; myCommand.Parameters.Add(pID); DataTable dt; NV_DiaDanh_ChiTiet model = new NV_DiaDanh_ChiTiet(); myConnection.Open(); using (SqlDataAdapter mData = new SqlDataAdapter(myCommand)) { dt = new DataTable(); mData.Fill(dt); } if (dt != null && dt.Rows.Count > 0) { model.MaDiaDanh = dt.Rows[0]["MaDiaDanh"].ToString(); model.TenDiaDanh = dt.Rows[0]["TenDiaDanh"].ToString(); model.TenGoiKhac = dt.Rows[0]["TenGoiKhac"].ToString(); model.ThuocTinh = dt.Rows[0]["ThuocTinh"].ToString(); model.ThuocHuyen = dt.Rows[0]["ThuocHuyen"].ToString(); model.ThuocXa = dt.Rows[0]["ThuocXa"].ToString(); model.Stt = int.Parse(dt.Rows[0]["Stt"].ToString()); } return(model); } } }
public bool Update(NV_DiaDanh_ChiTiet model) { using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { using (SqlCommand myCommand = new SqlCommand("NV_DangKyDiSan_update", myConnection)) { myCommand.CommandType = CommandType.StoredProcedure; SqlParameter pID = new SqlParameter("@DiaDanhID", SqlDbType.Int); pID.Value = model.DiaDanhID; myCommand.Parameters.Add(pID); SqlParameter pMadiadanh = new SqlParameter("@MaDiaDanh", SqlDbType.NVarChar, 50); pMadiadanh.Value = model.MaDiaDanh; myCommand.Parameters.Add(pMadiadanh); SqlParameter pTendiadanh = new SqlParameter("@TenDiadanh", SqlDbType.NVarChar, 250); pTendiadanh.Value = model.TenDiaDanh; myCommand.Parameters.Add(pTendiadanh); SqlParameter pTengoikhac = new SqlParameter("@TenGoiKhac", SqlDbType.NVarChar, 250); pTengoikhac.Value = model.TenGoiKhac; myCommand.Parameters.Add(pTengoikhac); 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 pStt = new SqlParameter("@Stt", SqlDbType.Int); pStt.Value = model.Stt; myCommand.Parameters.Add(pStt); try { myConnection.Open(); myCommand.ExecuteNonQuery(); return(true); } catch { return(false); } } } }