public void UpdateGurantor(GurantorModel model)
{
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
connection.ExecuteScalar($"update gurantor set gurantor_firstname = '{model.gurantor_firstname}', gurantor_middlename = '{model.gurantor_middlename}',gurantor_lastname = '{model.gurantor_lastname}', gurantor_currentaddress = '{model.gurantor_currentaddress}',gurantor_mobile = '{model.gurantor_mobile}', gurantor_relation = '{model.gurantor_relation}', gurantor_realtedpan = '{model.gurantor_realtedpan}', gurantor_realtedaadhar = '{model.gurantor_realtedaadhar}', gurantortype_id = '{model.gurantortype_id}'");
}
}
public GurantorModel CreateGurantor(GurantorModel model)
{
using (IDbConnection connection = new NpgsqlConnection(GlobalConfig.getDatabaseConnectionString()))
{
int id = connection.ExecuteScalar <int>($"insert into gurantor values('{model.gurantor_firstname}','{model.gurantor_middlename}','{model.gurantor_lastname}','{model.gurantor_currentaddress}','{model.gurantor_mobile}','{model.gurantor_relation}','{model.gurantor_realtedpan}','{model.gurantor_realtedaadhar}',{model.gurantortype_id})");
return(model);
}
}
