public void update(dapper.user user)
{
if (user.phone != null)
{
user.phone = otherutils.parsenumber(user.phone);
}
if (user.phone2 != null)
{
user.phone2 = otherutils.parsenumber(user.phone2);
}
using (var connection = new MySqlConnection(conn))
{
var identity = connection.Update <dapper.user>(user);
var i = 0;
}
}
public dapper.user save(dapper.user user)
{
if (user.phone != null)
{
user.phone = otherutils.parsenumber(user.phone);
}
if (user.phone2 != null)
{
user.phone2 = otherutils.parsenumber(user.phone2);
}
using (var connection = new MySqlConnection(conn))
{
var identity = connection.Insert <dapper.user>(user);
user.id = (int)identity;
return(user);
}
}
public void delete(dapper.user user)
{
var finnacetransactionrepo = new financetransactionrepo();
bool hasuserfinancetransactions = finnacetransactionrepo.hasuserfinancetransactions(user.id);
if (hasuserfinancetransactions == false)
{
using (var connection = new MySqlConnection(conn))
{
var identity = connection.Delete <dapper.user>(user);
var i = 0;
}
}
else
{
otherutils.notify("Alert", "User has finance transaction, This user can not be deleted", 5000);
}
}
