public MergeTableDetails Details(string ChildTableCode)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE ChildTableCode = @ChildTableCode;";
cmd.Parameters.AddWithValue("@ChildTableCode", ChildTableCode);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
MergeTableDetails Details = new MergeTableDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.MergeTableID = Int64.Parse(dr["MergeTableID"].ToString());
Details.MainTableCode = dr["MainTableCode"].ToString();
Details.ChildTableCode = dr["ChildTableCode"].ToString();
}
return(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(MergeTableDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public void Update(MergeTableDetails Details)
{
try
{
Save(Details);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(MergeTableDetails Details)
{
try
{
Save(Details);
return(Int32.Parse(base.getLAST_INSERT_ID(this)));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Insert(MergeTableDetails Details)
{
try
{
Save(Details);
return Int32.Parse(base.getLAST_INSERT_ID(this));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(MergeTableDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveMergeTable(@MainTableCode, @ChildTableCode);";
cmd.Parameters.AddWithValue("MainTableCode", Details.MainTableCode);
cmd.Parameters.AddWithValue("ChildTableCode", Details.ChildTableCode);
cmd.CommandText = SQL;
return(base.ExecuteNonQuery(cmd));
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public Int32 Save(MergeTableDetails Details)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procSaveMergeTable(@MainTableCode, @ChildTableCode);";
cmd.Parameters.AddWithValue("MainTableCode", Details.MainTableCode);
cmd.Parameters.AddWithValue("ChildTableCode", Details.ChildTableCode);
cmd.CommandText = SQL;
return base.ExecuteNonQuery(cmd);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public MergeTableDetails Details(string ChildTableCode)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = SQLSelect() + "WHERE ChildTableCode = @ChildTableCode;";
cmd.Parameters.AddWithValue("@ChildTableCode", ChildTableCode);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
MergeTableDetails Details = new MergeTableDetails();
foreach (System.Data.DataRow dr in dt.Rows)
{
Details.MergeTableID = Int64.Parse(dr["MergeTableID"].ToString());
Details.MainTableCode = dr["MainTableCode"].ToString();
Details.ChildTableCode = dr["ChildTableCode"].ToString();
}
return Details;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
