public static BurnAddress GetBurnAddressNew(int custId, string burnAddressRef, string tag)
{
BurnAddress address = new BurnAddress();
MySqlConnection conn = new MySqlConnection(constr);
try
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "update `goraven`.`burn_address` na inner join(select min(`BurnAddressId`) as BurnAddressId from `goraven`.`burn_address` where `CustId` is null) mn on na.`BurnAddressId` = mn.`BurnAddressId` set na.`CustId`= " + custId.ToString() + ", na.`BurnAddressRef`= '" + burnAddressRef + "', na.`Tag`= '" + tag + "', na.`UpdateDateTime` = now()";
cmd.ExecuteNonQuery();
MySqlCommand cmd2 = conn.CreateCommand();
cmd2.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " order by BurnAddressId desc limit 1;";
MySqlDataReader reader = cmd2.ExecuteReader();
while (reader.Read())
{
address.burnAddress = reader.GetString("BurnAddress");
address.custId = Convert.ToInt32(reader.GetString("CustId"));
if (!reader.IsDBNull(3))
{
address.burnAddressRef = reader.GetString("BurnAddressRef");
}
if (!reader.IsDBNull(4))
{
address.burnAddressTag = reader.GetString("Tag");
}
if (!reader.IsDBNull(5))
{
address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime"));
}
if (!reader.IsDBNull(6))
{
address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime"));
}
}
reader.Close();
reader.Dispose();
}
catch (Exception ex)
{
return(null);
}
finally
{
conn.Close();
conn.Dispose();
}
return(address);
}
public static List <BurnAddress> GetBurnAddressList(int custId)
{
List <BurnAddress> burnAddressList = new List <BurnAddress>();
MySqlConnection conn = new MySqlConnection(constr);
conn.Open();
try
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " or `CustId` in (select `parentCustId` from `goraven`.`cust` where `CustId`= " + custId.ToString() + ");";
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BurnAddress address = new BurnAddress();
address.burnAddress = reader.GetString("BurnAddress");
address.custId = Convert.ToInt32(reader.GetString("CustId"));
if (!reader.IsDBNull(3))
{
address.burnAddressRef = reader.GetString("BurnAddressRef");
}
if (!reader.IsDBNull(4))
{
address.burnAddressTag = reader.GetString("Tag");
}
if (!reader.IsDBNull(5))
{
address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime"));
}
if (!reader.IsDBNull(6))
{
address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime"));
}
burnAddressList.Add(address);
}
reader.Close();
reader.Dispose();
}
catch (Exception ex)
{
//burnAddress = ex.ToString();
}
finally
{
conn.Close();
conn.Dispose();
}
return(burnAddressList);
}
public static BurnAddress GetBurnAddressByRef(int custId, string burnAddressRef)
{
BurnAddress address = new BurnAddress();
MySqlConnection conn = new MySqlConnection(constr);
conn.Open();
try
{
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from `goraven`.`burn_address` where `BurnAddressRef` = '" + burnAddressRef + "' and (`CustId` = " + custId.ToString() + " or `CustId` in (select `parentCustId` from `goraven`.`cust` where `CustId`= " + custId.ToString() + ")) limit 1;";
//cmd.CommandText = "select * from `goraven`.`burn_address` where `CustId` = " + custId.ToString() + " and `BurnAddressRef` = '" + burnAddressRef + "' limit 1;";
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
address.burnAddress = reader.GetString("BurnAddress");
address.custId = Convert.ToInt32(reader.GetString("CustId"));
if (!reader.IsDBNull(3))
{
address.burnAddressRef = reader.GetString("BurnAddressRef");
}
if (!reader.IsDBNull(4))
{
address.burnAddressTag = reader.GetString("Tag");
}
if (!reader.IsDBNull(5))
{
address.updateDateTime = Convert.ToDateTime(reader.GetString("UpdateDateTime"));
}
if (!reader.IsDBNull(6))
{
address.createDateTime = Convert.ToDateTime(reader.GetString("CreateDateTime"));
}
}
reader.Close();
reader.Dispose();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
conn.Dispose();
}
return(address);
}
