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