public bool Post(Medecine med) { MedecineService md = new MedecineService(); var result = md.AddOrUpdateMedeCine(med); return(result); }
/// <summary> /// Populate business object from data reader /// </summary> /// <param name="businessObject">business object</param> /// <param name="dataReader">data reader</param> internal void PopulateBusinessObjectFromReader(Medecine businessObject, IDataReader dataReader) { businessObject.MedecineId = dataReader.GetInt64(dataReader.GetOrdinal(Medecine.MedecineFields.MedecineId.ToString())); if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Medecine_ShorName.ToString()))) { businessObject.Medecine_ShorName = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Medecine_ShorName.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Medecine_Name.ToString()))) { businessObject.Medecine_Name = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Medecine_Name.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Contain.ToString()))) { businessObject.Contain = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Contain.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Used.ToString()))) { businessObject.Used = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Used.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Dosage_Children.ToString()))) { businessObject.Dosage_Children = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Dosage_Children.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Dosage_Adult.ToString()))) { businessObject.Dosage_Adult = dataReader.GetString(dataReader.GetOrdinal(Medecine.MedecineFields.Dosage_Adult.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.IsBaby.ToString()))) { businessObject.IsBaby = dataReader.GetBoolean(dataReader.GetOrdinal(Medecine.MedecineFields.IsBaby.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.Present_Id.ToString()))) { businessObject.Present_Id = dataReader.GetInt64(dataReader.GetOrdinal(Medecine.MedecineFields.Present_Id.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.ActorChanged.ToString()))) { businessObject.ActorChanged = dataReader.GetInt64(dataReader.GetOrdinal(Medecine.MedecineFields.ActorChanged.ToString())); } if (!dataReader.IsDBNull(dataReader.GetOrdinal(Medecine.MedecineFields.TimeChanged.ToString()))) { businessObject.TimeChanged = dataReader.GetDateTime(dataReader.GetOrdinal(Medecine.MedecineFields.TimeChanged.ToString())); } }
/// <summary> /// Populate business objects from the data reader /// </summary> /// <param name="dataReader">data reader</param> /// <returns>list of Medecine</returns> internal List <Medecine> PopulateObjectsFromReader(IDataReader dataReader) { List <Medecine> list = new List <Medecine>(); while (dataReader.Read()) { Medecine businessObject = new Medecine(); PopulateBusinessObjectFromReader(businessObject, dataReader); list.Add(businessObject); } return(list); }
/// <summary> /// Select by primary key /// </summary> /// <param name="keys">primary keys</param> /// <returns>Medecine business object</returns> public Medecine SelectByPrimaryKey(long keys) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[Medecine_SelectByPrimaryKey]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@MedecineId", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, keys)); MainConnection.Open(); IDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.Read()) { Medecine businessObject = new Medecine(); PopulateBusinessObjectFromReader(businessObject, dataReader); return(businessObject); } else { return(null); } } catch (Exception ex) { throw new Exception("Medecine::SelectByPrimaryKey::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// insert new row in the table /// </summary> /// <param name="businessObject">business object</param> /// <returns>true of successfully insert</returns> public bool Insert(Medecine businessObject) { SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandText = "dbo.[Medecine_Insert]"; sqlCommand.CommandType = CommandType.StoredProcedure; // Use connection object of base class sqlCommand.Connection = MainConnection; try { sqlCommand.Parameters.Add(new SqlParameter("@MedecineId", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.MedecineId)); sqlCommand.Parameters.Add(new SqlParameter("@Medecine_ShorName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Medecine_ShorName)); sqlCommand.Parameters.Add(new SqlParameter("@Medecine_Name", SqlDbType.NVarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Medecine_Name)); sqlCommand.Parameters.Add(new SqlParameter("@Contain", SqlDbType.NVarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Contain)); sqlCommand.Parameters.Add(new SqlParameter("@Used", SqlDbType.NVarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Used)); sqlCommand.Parameters.Add(new SqlParameter("@Dosage_Children", SqlDbType.NVarChar, 500, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Dosage_Children)); sqlCommand.Parameters.Add(new SqlParameter("@Dosage_Adult", SqlDbType.NChar, 10, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Dosage_Adult)); sqlCommand.Parameters.Add(new SqlParameter("@IsBaby", SqlDbType.Bit, 1, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.IsBaby)); sqlCommand.Parameters.Add(new SqlParameter("@Present_Id", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.Present_Id)); sqlCommand.Parameters.Add(new SqlParameter("@ActorChanged", SqlDbType.BigInt, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.ActorChanged)); sqlCommand.Parameters.Add(new SqlParameter("@TimeChanged", SqlDbType.DateTime, 8, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Proposed, businessObject.TimeChanged)); MainConnection.Open(); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { throw new Exception("Medecine::Insert::Error occured.", ex); } finally { MainConnection.Close(); sqlCommand.Dispose(); } }
/// <summary> /// Update existing Medecine /// </summary> /// <param name="businessObject">Medecine object</param> /// <returns>true for successfully saved</returns> public bool Update(Medecine businessObject) { return(_dataObject.Update(businessObject)); }
/// <summary> /// Insert new Medecine /// </summary> /// <param name="businessObject">Medecine object</param> /// <returns>true for successfully saved</returns> public bool Insert(Medecine businessObject) { return(_dataObject.Insert(businessObject)); }