private ChartOfAcc CreateObject(NullHandler oReader) { ChartOfAcc oChartOfAcc = new ChartOfAcc(); MapObject(oChartOfAcc, oReader); return(oChartOfAcc); }
public ChartOfAcc GetByID(int nID) { ChartOfAcc oChartOfAcc = new ChartOfAcc(); try { SqlCommand cmd = new SqlCommand("SP_ChartOfAcc_GetByID", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Coa_id", SqlDbType.Int)).Value = nID; if (_conn.State == ConnectionState.Open) { } else { cmd.Connection.Open(); } IDataReader reader = cmd.ExecuteReader(); NullHandler oReader = new NullHandler(reader); if (reader.Read()) { oChartOfAcc = CreateObject(oReader); } cmd.Dispose(); cmd.Connection.Close(); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oChartOfAcc); }
public bool UpDateChartOfAcc(ChartOfAcc oChartOfAcc, int nEditID) { try { SqlCommand cmd = new SqlCommand("SP_ChartOfAcc_Update", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Coa_parent_id", SqlDbType.Int)).Value = oChartOfAcc.Coa_parent_id; cmd.Parameters.Add(new SqlParameter("@Coa_is_perent", SqlDbType.Bit)).Value = oChartOfAcc.Coa_is_perent; cmd.Parameters.Add(new SqlParameter("@Coa_type", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_type; cmd.Parameters.Add(new SqlParameter("@Coa_title", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_title; cmd.Parameters.Add(new SqlParameter("@Coa_level_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_level_code; cmd.Parameters.Add(new SqlParameter("@Coa_account_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_account_code; cmd.Parameters.Add(new SqlParameter("@Coa_legacy_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_legacy_code; cmd.Parameters.Add(new SqlParameter("@Coa_is_ledgerhead", SqlDbType.Bit)).Value = oChartOfAcc.Coa_is_ledgerhead; cmd.Parameters.Add(new SqlParameter("@UpdateUserID", SqlDbType.Int)).Value = EMSGlobal._nCurrentUserID; cmd.Parameters.Add(new SqlParameter("@Coa_id", SqlDbType.Int)).Value = nEditID; if (_conn.State == ConnectionState.Open) { } else { cmd.Connection.Open(); } cmd.ExecuteNonQuery(); cmd.Dispose(); cmd.Connection.Close(); return(true); } catch (Exception e) { throw new ServiceException(e.Message, e); } }
private ChartOfAccs CreateObjects(IDataReader oReader) { ChartOfAccs oChartOfAccs = new ChartOfAccs(); NullHandler oHandler = new NullHandler(oReader); while (oReader.Read()) { ChartOfAcc oItem = CreateObject(oHandler); oChartOfAccs.Add(oItem); } return(oChartOfAccs); }
private void MapObject(ChartOfAcc oChartOfAcc, NullHandler oReader) { BusinessObject.Factory.SetID(oChartOfAcc, new ID(oReader.GetInt32("Coa_id"))); oChartOfAcc.Coa_type = oReader.GetString("Coa_type"); oChartOfAcc.Coa_parent_id = oReader.GetInt32("Coa_parent_id"); oChartOfAcc.Coa_is_perent = oReader.GetBoolean("Coa_is_perent"); oChartOfAcc.Coa_title = oReader.GetString("Coa_title"); oChartOfAcc.Coa_level_code = oReader.GetString("Coa_level_code"); oChartOfAcc.Coa_account_code = oReader.GetString("Coa_account_code"); oChartOfAcc.Coa_legacy_code = oReader.GetString("Coa_legacy_code"); oChartOfAcc.Coa_is_ledgerhead = oReader.GetBoolean("Coa_is_ledgerhead"); BusinessObject.Factory.SetObjectState(oChartOfAcc, ObjectState.Saved); }
public ID Save(ChartOfAcc oChartOfAcc) { try { if (oChartOfAcc.IsNew) { SqlCommand cmd = new SqlCommand("SP_ChartOfAcc_Insert", _conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Coa_parent_id", SqlDbType.Int)).Value = oChartOfAcc.Coa_parent_id; cmd.Parameters.Add(new SqlParameter("@Coa_is_perent", SqlDbType.Bit)).Value = oChartOfAcc.Coa_is_perent; cmd.Parameters.Add(new SqlParameter("@Coa_type", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_type; cmd.Parameters.Add(new SqlParameter("@Coa_title", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_title; cmd.Parameters.Add(new SqlParameter("@Coa_level_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_level_code; cmd.Parameters.Add(new SqlParameter("@Coa_account_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_account_code; cmd.Parameters.Add(new SqlParameter("@Coa_legacy_code", SqlDbType.VarChar)).Value = oChartOfAcc.Coa_legacy_code; cmd.Parameters.Add(new SqlParameter("@Coa_is_ledgerhead", SqlDbType.Bit)).Value = oChartOfAcc.Coa_is_ledgerhead; cmd.Parameters.Add(new SqlParameter("@DBUserID", SqlDbType.Int)).Value = EMSGlobal._nCurrentUserID; if (_conn.State == ConnectionState.Open) { } else { cmd.Connection.Open(); } int NewID = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); cmd.Connection.Close(); BusinessObject.Factory.SetID(oChartOfAcc, new ID(NewID)); } BusinessObject.Factory.SetObjectState(oChartOfAcc, ObjectState.Saved); } catch (Exception e) { throw new ServiceException(e.Message, e); } return(oChartOfAcc.ID); }