internal string GetTodaysRemittance(RemittanceBO remittanceBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(remittanceBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.Text); command.CommandText = "SELECT ISNULL(SUM(AMOUNT),0) FROM Remittance where CONVERT(varchar(100),RemittedDate,103) = CONVERT(varchar(100),getdate(),103) and RemittedBy = " + remittanceBO.UserId; return(Convert.ToString(sqlHelper.ExecuteScalar(command))); }
internal int UpdateRemittance(RemittanceBO remittanceBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(remittanceBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "uspRemittance"; sqlHelper.AddParameter(command, "@Mode", "A", ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserId", remittanceBO.UserId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@BankId", remittanceBO.BankId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Amount", remittanceBO.Amount, ParameterDirection.Input); sqlHelper.AddParameter(command, "@latitude", remittanceBO.Latitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@longitude", remittanceBO.Longitude, ParameterDirection.Input); sqlHelper.AddParameter(command, "@processName", remittanceBO.ProcessName, ParameterDirection.Input); sqlHelper.AddParameter(command, "@mobileTransactionDate", remittanceBO.MobileTransactionDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@MobileReferenceNo", remittanceBO.MobRefNo, ParameterDirection.Input); sqlHelper.AddParameter(command, "@GpsSource", remittanceBO.GpsSource, ParameterDirection.Input); sqlHelper.AddParameter(command, "@Remarks", remittanceBO.Remarks, ParameterDirection.Input); if (remittanceBO.ServerSyncDate != "" && remittanceBO.MobileSyncDate != "") { sqlHelper.AddParameter(command, "@MobileSyncDate", remittanceBO.MobileSyncDate, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ServerSyncDate", remittanceBO.ServerSyncDate, ParameterDirection.Input); } if (!string.IsNullOrEmpty(remittanceBO.DenominationIds)) { sqlHelper.AddParameter(command, "@DenominationIds", remittanceBO.DenominationIds, ParameterDirection.Input); } if (!string.IsNullOrEmpty(remittanceBO.Denominations)) { sqlHelper.AddParameter(command, "@Denominations", remittanceBO.Denominations, ParameterDirection.Input); } if (!string.IsNullOrEmpty(remittanceBO.ApprovedBy)) { sqlHelper.AddParameter(command, "@ApprovedBy", remittanceBO.ApprovedBy, ParameterDirection.Input); } return(Convert.ToInt32(sqlHelper.ExecuteNonQuery(command))); }