public int getuserreceiveablessum(int userid)
{
financeaccountrepo financeaccountrepo = new financeaccountrepo();
financeaccount financeaccount = financeaccountrepo.getonebyname("account receivable");
string sql = "select sum(amount) from financetransaction where fk_user_targetto_in_financetransaction=" + userid + " and fk_financeaccount_in_financetransaction=" + financeaccount.id + ";";
using (var connection = new MySqlConnection(conn))
{
var res = connection.ExecuteScalar <int>(sql);
return(res);
}
}
public List <dapper.financetransactionextended> getmanybyselfnameandfinanceaccountname(string selfname, string financeaccountname)
{
financeaccountrepo financeaccountrepo = new financeaccountrepo();
financeaccount financeaccount = financeaccountrepo.getonebyname(financeaccountname);
string sql = "select " + joinselect + " where t1.name='" + selfname + "' and t1.fk_financeaccount_in_financetransaction=" + financeaccount.id + ";";
using (var connection = new MySqlConnection(conn))
{
var res = connection.Query <dapper.financetransactionextended>(sql).ToList();
return(res);
}
}
public int getuserpayablesum(int userid)
{
financeaccountrepo financeaccountrepo = new financeaccountrepo();
financeaccount financeaccount = financeaccountrepo.getonebyname("account payable");
var list = new List <KeyValuePair <string, object> >();
list.Add(new KeyValuePair <string, object>("fk_user_targetto_in_financetransaction", userid));
list.Add(new KeyValuePair <string, object>("fk_financeaccount_in_financetransaction", financeaccount.id));
string and = baserepo.getkeyValuestoSqlAnd(list);
string sql = "select sum(amount) from financetransaction where " + and + ";";
using (var connection = new MySqlConnection(conn))
{
var res = connection.ExecuteScalar <int>(sql);
return(res);
}
}