public static PartCategory GetPartCategory(MySql.Data.MySqlClient.MySqlDataReader aReader)
{
PartCategory prtCat = null;
while (aReader.Read())
{
prtCat = new PartCategory();
prtCat.ID = Convert.ToInt32(aReader[0]);
prtCat.CODE = aReader[1].ToString();
prtCat.NAME = aReader[2].ToString();
prtCat.MODIFIED_BY = aReader["modified_by"].ToString();
prtCat.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString());
prtCat.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
}
return(prtCat);
}
public IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader)
{
IList result = new ArrayList();
while (aReader.Read())
{
PartCategory prtCat = new PartCategory();
prtCat.ID = Convert.ToInt32(aReader[0]);
prtCat.CODE = aReader[1].ToString();
prtCat.NAME = aReader[2].ToString();
prtCat.MODIFIED_BY = aReader["modified_by"].ToString();
prtCat.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString());
prtCat.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
result.Add(prtCat);
}
return(result);
}
public void Import(string s)
{
OpenConnection();
MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand();
aCommand.Connection = m_connection;
MySql.Data.MySqlClient.MySqlTransaction trc = m_connection.BeginTransaction();
aCommand.Transaction = trc;
try
{
string[] p = s.Split(',');
aCommand.CommandText = Part.GetByCodeSQLStatic(p[0]);
MySql.Data.MySqlClient.MySqlDataReader re = aCommand.ExecuteReader();
Part fpart = Part.GetPart(re);
re.Close();
if (fpart != null)
{
trc.Rollback(); return;
}
Unit u = GetUnit(aCommand, p[3], p[4]);
PartGroup pg = GetPartGroup(aCommand, p[5], p[6]);
Currency ccy = GetCurrency(aCommand, p[7], p[8]);
PartCategory pc = GetPartCategory(aCommand, p[9], "KECIL");
Part part = new Part();
part.CODE = p[0];
part.NAME = p[1];
part.BARCODE = p[2];
part.UNIT = u;
part.PART_GROUP = pg;
part.CURRENCY = ccy;
part.PART_CATEGORY = pc;
aCommand.CommandText = part.GetInsertSQL();
aCommand.ExecuteNonQuery();
trc.Commit();
}
catch (Exception x)
{
trc.Rollback();
throw x;
}
}
private PartCategory GetPartCategory(MySql.Data.MySqlClient.MySqlCommand aCommand, string code, string name)
{
//MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand();
aCommand.Connection = m_connection;
aCommand.CommandText = PartCategory.GetByCodeSQLStatic(code.Trim());
MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader();
PartCategory u = PartCategory.GetPartCategory(r);
r.Close();
if (u == null)
{
u = new PartCategory();
u.CODE = code;
u.NAME = name;
aCommand.CommandText = u.GetInsertSQL();
aCommand.ExecuteNonQuery();
aCommand.CommandText = u.GetMaximumIDSQL();
u.ID = Convert.ToInt32(aCommand.ExecuteScalar());
}
return(u);
}
