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