public async Task <int> SaveSalaryDetails(SalaryInfoReq salaryInfoReq)
{
int result = 1;
try
{
paramralist = new List <NpgsqlParameter>();
paramralist.AddRange(new List <NpgsqlParameter> {
new NpgsqlParameter("v_basic", NpgsqlDbType.Numeric)
{
Value = salaryInfoReq.basic
},
new NpgsqlParameter("v_oa", NpgsqlDbType.Numeric)
{
Value = salaryInfoReq.oa
},
new NpgsqlParameter("v_uid", NpgsqlDbType.Integer)
{
Value = salaryInfoReq.u_id
}
});
result = await _dataBaseConnector.ExcuteCRUDOperationAsync("public.savesalaryDetails", paramralist);
result = 1;
}
catch (Exception ex)
{
result = 0;
}
return(result);
}
public async Task <int> SaveuserDetails(UserInfoReq userInfoReq)
{
int result = 1;
try
{
paramralist = new List <NpgsqlParameter>();
paramralist.AddRange(new List <NpgsqlParameter> {
new NpgsqlParameter("v_uname", NpgsqlDbType.Text)
{
Value = userInfoReq.uname
},
new NpgsqlParameter("v_email", NpgsqlDbType.Text)
{
Value = userInfoReq.email
},
new NpgsqlParameter("v_age", NpgsqlDbType.Integer)
{
Value = userInfoReq.age
},
new NpgsqlParameter("v_address", NpgsqlDbType.Text)
{
Value = userInfoReq.address
},
new NpgsqlParameter("v_designation", NpgsqlDbType.Text)
{
Value = userInfoReq.designation
}
});
result = await _dataBaseConnector.ExcuteCRUDOperationAsync("saveuserdetails", paramralist);
result = 1;
}
catch (Exception ex)
{
result = 0;
}
return(result);
}