/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(NHAPTHUOC businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[NHAPTHUOC_Update]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ID)); sqlCommand.Parameters.Add(new SqlParameter("@NGAY", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.NGAY)); sqlCommand.Parameters.Add(new SqlParameter("@BACSIID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.BACSIID)); sqlCommand.Parameters.Add(new SqlParameter("@TONGTIEN", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TONGTIEN)); sqlCommand.Parameters.Add(new SqlParameter("@GHICHU", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.GHICHU)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch //(Exception ex) { return(false); //throw new Exception("NHAPTHUOC::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
private void btnDong_Click(object sender, EventArgs e) { if (nhapthuoc.ID != 0) { NHAPTHUOCService.Update(nhapthuoc); } nhapthuoc = new NHAPTHUOC(); ClearPhieuNhap(); LockPHIEUNHAP(); LoadDgvCHITIETNHAP(); }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of NHAPTHUOC</returns> internal List <NHAPTHUOC> PopulateObjectsFromReader(IDataReader dataReader) { List <NHAPTHUOC> list = new List <NHAPTHUOC>(); while (dataReader.Read()) { NHAPTHUOC businessObject = new NHAPTHUOC(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
private NHAPTHUOC GetPhieuNhapByForm() { NHAPTHUOC ans = new NHAPTHUOC(); ans.BACSIID = (int)cbxBacSi.EditValue; ans.NGAY = DateNgay.DateTime; ans.GHICHU = txtGhiChu.Text; ans.TONGTIEN = CHITIETNHAPService.GetAllEntities().ToList() .Where(p => p.NHAPTHUOCID == nhapthuoc.ID) .Sum(p => p.THANHTIEN) .Value; return(ans); }
private void btnLuu_Click(object sender, EventArgs e) { nhapthuoc = GetPhieuNhapByForm(); if (NHAPTHUOCService.Insert(nhapthuoc)) { btnHoanThanh.Enabled = true; btnLuu.Enabled = false; MessageBox.Show("Thêm phiếu nhập thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Thêm phiếu nhập thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>NHAPTHUOC business object</returns> public NHAPTHUOC SelectByPrimaryKey(NHAPTHUOCKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[NHAPTHUOC_SelectByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@ID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys.ID)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { NHAPTHUOC businessObject = new NHAPTHUOC(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch //(Exception ex) { return(null); //throw new Exception("NHAPTHUOC::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(NHAPTHUOC businessObject, IDataReader dataReader) { businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.ID.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.NGAY.ToString()))) { businessObject.NGAY = dataReader.GetDateTime(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.NGAY.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.BACSIID.ToString()))) { businessObject.BACSIID = dataReader.GetInt32(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.BACSIID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.TONGTIEN.ToString()))) { businessObject.TONGTIEN = dataReader.GetInt32(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.TONGTIEN.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.GHICHU.ToString()))) { businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(NHAPTHUOC.NHAPTHUOCFields.GHICHU.ToString())); } }