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