public bool Insert(T t) { try { IDbCommand cmd = connection.CreateCommand(); cmd.Parameters.Clear(); var iq = new InsertQuery(Entity); cmd.CommandType = CommandType.Text; cmd.CommandText = iq.GetQuerywithParameter(t); iq.SetParameter(ref cmd, t); var result = (Int32)cmd.ExecuteNonQuery(); if (result > 0) { return(true); } else { return(false); } } catch (MySqlException ex) { throw new System.Exception(Helpers.ErrorHandle(ex)); } }
public int GetLastID(T t) { int result = 0; try { IDbCommand cmd = connection.CreateCommand(); cmd.Parameters.Clear(); var iq = new InsertQuery(Entity); cmd.CommandType = CommandType.Text; cmd.CommandText = iq.GetQuerywithParameter(t) + "; select Last_Insert_ID();"; iq.SetParameter(ref cmd, t); result = Convert.ToInt32(cmd.ExecuteScalar()); } catch (MySqlException ex) { throw new System.Exception(Helpers.ErrorHandle(ex)); } return(result); }