public async Task <Tuple <bool, string, MasterChargesModel> > GetMasterCharges() { Tuple <bool, string, MasterChargesModel> result = null; MasterChargesModel masterCharges = new MasterChargesModel(); try { using (SqlConnection con = new SqlConnection(_dcDb)) { con.Open(); var mCharges = await con.QueryAsync <MasterChargesModel>("[dbo].[Select_MasterCharges]", commandType : CommandType.StoredProcedure, commandTimeout : 300); masterCharges = mCharges.FirstOrDefault(); con.Close(); } if (masterCharges != null) { result = Tuple.Create(true, "", masterCharges); } else { result = Tuple.Create(false, AppConstants.NO_RECORDS_FOUND, masterCharges); } } catch (Exception ex) { ErrorLog.Write(ex); result = Tuple.Create(false, "", masterCharges); } return(result); }
public async Task <Tuple <bool, string, MasterChargesModel> > AddMasterCharges(MasterChargesModel obj) { int status = -1; Tuple <bool, string, MasterChargesModel> objMasterCharges = null; MasterChargesModel masterCharges = new MasterChargesModel(); try { var parameters = new DynamicParameters(); using (SqlConnection cxn = new SqlConnection(_dcDb)) { parameters.Add("@DocumentationAdminFee", obj.DocumentationAdminFee, DbType.Decimal); parameters.Add("@DocumentationAdminFee1", obj.DocumentationAdminFee1, DbType.Decimal); parameters.Add("@PrepaidLoanCharges", obj.PrepaidLoanCharges, DbType.Decimal); parameters.Add("@RegistrationCharges", obj.RegistrationCharges, DbType.Decimal); parameters.Add("@AreaFee", obj.AreaFee, DbType.Decimal); parameters.Add("@DistrictFee", obj.DistrictFee, DbType.Decimal); parameters.Add("@DistrictClusterFee", obj.DistrictClusterFee, DbType.Decimal); parameters.Add("@StateFee", obj.StateFee, DbType.Decimal); parameters.Add("@StateClusterFee", obj.StateClusterFee, DbType.Decimal); parameters.Add("@MotherFee", obj.MotherFee, DbType.Decimal); parameters.Add("@SGST", obj.SGST, DbType.Decimal); parameters.Add("@CGST", obj.CGST, DbType.Decimal); parameters.Add("@IGST", obj.IGST, DbType.Decimal); parameters.Add("@TDS", obj.TDS, DbType.Decimal); parameters.Add("@pincommission", obj.PinCommission, DbType.Decimal); parameters.Add("@fundtransfercharges", obj.FundTransferCharges, DbType.Decimal); parameters.Add("@CreatedBy", Helper.FindUserByID().Id, DbType.String); parameters.Add("@CreatedOn", DateTime.Now, DbType.DateTime); masterCharges = await cxn.QuerySingleAsync <MasterChargesModel>("dbo.Insert_MasterCharges", parameters, commandType : CommandType.StoredProcedure); if (masterCharges != null) { objMasterCharges = Tuple.Create(true, "Master charges added successfully.", masterCharges); } else { objMasterCharges = Tuple.Create(false, "Master charges added failed.Please try again.", masterCharges); } cxn.Close(); } } catch (Exception ex) { ErrorLog.Write(ex); objMasterCharges = Tuple.Create(false, "Oops! Master charges added failed.Please try again.", masterCharges); } return(objMasterCharges); }
public async Task <Tuple <bool, string, MasterChargesModel> > AddMasterCharges(MasterChargesModel obj) { Tuple <bool, string, MasterChargesModel> result = null; try { result = await _repo.AddMasterCharges(obj); } catch (Exception ex) { ErrorLog.Write(ex); } return(result); }