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);
}
