/// <summary> /// update row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true for successfully updated</returns> public bool Update(GIAYGIOITHIEU businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[GIAYGIOITHIEU_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("@KHAMTHUONGXUYENID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.KHAMTHUONGXUYENID)); sqlCommand.Parameters.Add(new SqlParameter("@YKIENDENGHI", SqlDbType.NVarChar, 2147483647, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.YKIENDENGHI)); 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("GIAYGIOITHIEU::Update::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of GIAYGIOITHIEU</returns> internal List <GIAYGIOITHIEU> PopulateObjectsFromReader(IDataReader dataReader) { List <GIAYGIOITHIEU> list = new List <GIAYGIOITHIEU>(); while (dataReader.Read()) { GIAYGIOITHIEU businessObject = new GIAYGIOITHIEU(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>GIAYGIOITHIEU business object</returns> public GIAYGIOITHIEU SelectByPrimaryKey(GIAYGIOITHIEUKeys keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[GIAYGIOITHIEU_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()) { GIAYGIOITHIEU businessObject = new GIAYGIOITHIEU(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch //(Exception ex) { return(null); //throw new Exception("GIAYGIOITHIEU::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(GIAYGIOITHIEU businessObject, IDataReader dataReader) { businessObject.ID = dataReader.GetInt32(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.ID.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.NGAY.ToString()))) { businessObject.NGAY = dataReader.GetDateTime(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.NGAY.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.KHAMTHUONGXUYENID.ToString()))) { businessObject.KHAMTHUONGXUYENID = dataReader.GetInt32(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.KHAMTHUONGXUYENID.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.YKIENDENGHI.ToString()))) { businessObject.YKIENDENGHI = dataReader.GetString(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.YKIENDENGHI.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.GHICHU.ToString()))) { businessObject.GHICHU = dataReader.GetString(dataReader.GetOrdinal(GIAYGIOITHIEU.GIAYGIOITHIEUFields.GHICHU.ToString())); } }